Get the User ID Programatically

[Bill Duris]

Hello,

Is there a way to get the user's system (Windows) login ID from Access 2002?
Is there a 3rd party function for this?

 

[Arvin Meyer]

Hello,

Is there a way to get the user's system (Windows) login ID from Access 2002?
Is there a 3rd party function for this?

Create a standard module. Put the following function in it:

http://www.mvps.org/access/api/api0008.htm

Call it from a query or as an expression.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Van T. Dinh]

See The Access Web article:

http://www.mvps.org/access/api/api0008.htm

 

[Guest]

howya

not sure it will help but when I was creating a form I used
=Environ("USERNAME") as the control source and it picks up my network logon.

DFC