Do you want to know 'who' recorded each record in your table? If so, using
the user name listed in Options will only tell you whose PC the work was
done on.
It is possible to use a call to the network to find the user name/initials
of the person who is logged on, instead.
It is to capture who updated a record. We are not able to pull the name from
our network and CurrentUser is just Admin - so saw that you could specify a
user name and initials under the Access Options and wondered if you could
access that information via VB or macro to populate in a table.
If you try searching at mvps.org/access, you may find a routine that will
allow you to pull user name from your network.
I'm not familiar with using the UserName in the Options, but perhaps another
reader is.
If you want to document who updated a record, you will need to do that via a
form, and you will need a field in your underlying table to hold that data
.... do you also want to record when (date/time)?
Like Jeff, I have seen no information about using that property. I wouldn't
be surprised if it was possible, but no idea how.
Maybe you could consider having the user sign in when first opening the
application, by entering their user name into a startup form. You could use
a SetTempVar macro to capture this, and this would then be available from
anywhere within the application for you to write into wherever you will be
recording the "updater".
Don't think that's applicable, Doug. Tom has explicitly explained that the
login does not apply in his scenario. Therefore he was exploring using the
Access user name as an alternative.
You're right. I was just responding to Jeff's post "If you try searching at
mvps.org/access, you may find a routine that will allow you to pull user
name from your network" without having read the whole thread.
If you mean the Access Option “Default database folder†or “Personalized your
copy of Microsoft Office – User name and Initials, these can be changed by
the user. So, it’s not advisable to use these.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
