I want that USER_Name captured... but how?

[Carl_R]

*Access97*

Had a look but can't seem to find anything related.

My DB is split on a network.

I have a form with a textbox called WHO. The ControlSource of WHO is =UCase(USER()) (USER is a module) - basically, this captures the user's ID from their NT logon session and displays it on the form.

This works fine but how do I capture that person's ID into my table?

 

[samson]

I use =currentUser()
together with work group security file.
There is a wizard to instal the work group. Takes abit of time to set up, but, I wouldn't be without it


Simon

 

[Carl_R]

I use =currentUser()
together with work group security file.
There is a wizard to instal the work group. Takes abit of time to set up, but, I wouldn't be without it


Simon

Thanks for the reply. I want to avoid using security... it's a really basic app.

The reason we want to capture the ID is because we want to track who is raising records (so we can spank them when they get it all wrong).

 

[R6Flyer]

Carl,

I assume that you have a table set up with the users details. If this is the case then simply include an additional field in this table to record their NT logon name.

After you have updated the table with the additional info you can use a lookup to display the user ID.

Cheers

Flyer

 

[ColinEssex]

This will capture the userName

MsgBox Environ("username")

Col

 

[Carl_R]

Excellent!
Thanks all for the assistance.

 

[ColinEssex]

Sorry, I should have said courtesy to GHudson for pointing out the Environ function a couple of weeks back. . . .

Col

 

[Cosmos75]

Get User ID - Environ("username") vs CurrentUser()

Originally posted by llkhoutx.
CurrentUser gives you the Access login ID, which is not necessarily the system login ID.