User Name in Access Options

  • Thread starter Thread starter tbjohnso2
  • Start date Start date
T

tbjohnso2

I'm working with Access 2007 - is there any way to grab the user name listed
in the Access Options and populated in a field on a table?
 
I'm not sure what you are trying to accomplish...

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.

But what is the underlying business need?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
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)?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Tbjohnso,

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.
 
Back
Top