Trying to record user logon 3

[alr0]

Hi All,

I want to add a field to an Access 03 table that records the user logon that added a record. I thought I had used GetUser in the past but neither the help or knowledge base had that phrase or others I tried. Isn't there an easy way to trap the user logon?

Thanks,

alr

_____________________________________
There is no rule more invariable than that we are paid for our suspicions by finding out what we expected.

Henry David Thoreau

 

[Remou]

The Access user or the Windows user?

CurrentUser
Environ("username")

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

 

[alr0]

I'm sorry, Widows user logon.

alr

_____________________________________
There is no rule more invariable than that we are paid for our suspicions by finding out what we expected.

Henry David Thoreau

 

[Remou]

Then either:
[tt]Environ("username")[/tt]

Or the code here:

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

 

[alr0]

Thanks Remou,

Environ("username") worked just fine.

Are there circumstances where it would be advisable to use the API?

Thanks again,

alr

_____________________________________
There is no rule more invariable than that we are paid for our suspicions by finding out what we expected.

Henry David Thoreau

 

[Remou]

Environ("username") does not work in the same way in every situation, for example, you may have problems with it in Access 2003 because, I believe, it is restricted in Sandbox mode. In addition, you may get different results depending on the Windows version.