Get the User ID Programatically

Bill Duris · Aug 2, 2004

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 · Aug 2, 2004

Bill Duris said:
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 · Aug 2, 2004

dogfish · Sep 13, 2004

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