Obtaining NT username via VBA

[Steve T]

We're running Access2002 on a Windows2000 network.

What code would I use to obtain a network username, or is it even possible?

Thanks in advance.

 

[Wayne Morgan]

This should help.

http://www.mvps.org/access/api/api0008.htm
http://www.mvps.org/access/api/api0062.htm
http://www.mvps.org/access/api/api0040.htm
http://www.mvps.org/access/api/api0009.htm
http://www.mvps.org/access/api/api0058.htm

 

[Guest]

Steve,

Try this:

mid(vba.Environ(25),instr(1,vba.Environ(25),"=")+1)

Jake


----- Steve T wrote: -----

We're running Access2002 on a Windows2000 network.

What code would I use to obtain a network username, or is it even possible?

Thanks in advance.

 

[Douglas J. Steele]

Or, MUCH better, try the code in http://www.mvps.org/access/api/api0008.htm
at "The Access Web".

It's trivial to reset Environment variables.