network username

[Mark P.]

I need to set the default value of a field to the username
of the network username. I am using Access 2000 and Access
2002. I was hoping there is a funtion or a command
available like %username%.

 

[Cheryl Fischer]

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

has code that will do that.

 

[Van T. Dinh]

In some cases, you can use Environ but The Access Web has the most reliable
method:

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

 

[Wayman Bell]

In my table I set the Default Value = Environ("Username")

In forms I used procedure
lbltext.caption = environ("Username")

works great!

WB