G
Guest
How do I find the user name (like Application.username in word VBA)
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
V
Van T. Dinh
Use the CurrentUser() function.
C
Cheryl Fischer
To expand a little on Van's response, CurrentUser() will return the user
name if your database has implemented Access Security. If you're not using
Access Security, you would need to add some code to your database, which can
be found at:
http://www.mvps.org/access/api/api0008.htm
hth,
name if your database has implemented Access Security. If you're not using
Access Security, you would need to add some code to your database, which can
be found at:
http://www.mvps.org/access/api/api0008.htm
hth,
G
Guest
CurrentUser() returns 'Admin' which is not what I was looking for
G
Guest
Cheryl, your code returns the user logon name which is good, but I was looking for something like the Office user name which could be written to as well as read
C
Cheryl Fischer
CurrentUser() will return the Access User Name *if* you have implemented
Access Security; otherwise, it will return the default user name of Admin.
If you do not have Access Security implemented, the next available method of
getting the identification of the person (without having some other perhaps
custom login to your database) is the Network User ID. Are you asking
about development of a custom login scheme?
--
Cheryl Fischer
Law/Sys Associates
Houston, TX
well as read
Access Security; otherwise, it will return the default user name of Admin.
If you do not have Access Security implemented, the next available method of
getting the identification of the person (without having some other perhaps
custom login to your database) is the Network User ID. Are you asking
about development of a custom login scheme?
--
Cheryl Fischer
Law/Sys Associates
Houston, TX
looking for something like the Office user name which could be written to asAlan Bornat said:Cheryl, your code returns the user logon name which is good, but I was
well as read
J
Joan Wild
Not through Access - there is no equivalent 'username' like in Word. You
could set a reference to the Word library and retrieve it.
Word.Application.Username
--
Joan Wild
Microsoft Access MVP
well as read
could set a reference to the Word library and retrieve it.
Word.Application.Username
--
Joan Wild
Microsoft Access MVP
looking for something like the Office user name which could be written to asAlan Bornat said:Cheryl, your code returns the user logon name which is good, but I was
well as read
D
Dev Ashish
I was looking for something like the Office user name which could be
written to as well as read
As Joan and Cheryl have pointed out, there's no such property in Access.
The closest you can get within Access/DAO object model is to either use the
'Author' property off of the SummaryInfo document (which I won't recommend)
or define your own custom property in the Custom tab (off of the
UserDefined document following the same syntax).
?CurrentDB.Containers("Databases").Documents("SummaryInfo").Properties
("Author").Value
-- Dev
G
Guest
Thanks - in Word Help it says 'The information you type in the User Information dialog box is used by all Office programs' - so I was hoping to be able to access it through Access!
G
Guest
Thanks for your reply - no, I was just asking how to get the user information which is stored somewhere in Office - for example it says in Word help 'The information you type in the User Information dialog box is used by all Office programs'