Grabbing User Login ID within Access field

[Fozi]

I'm looking to write an audit control module which captures users activity on my system. For each activity the system records user name and date/time of update.

Ideally I'd like the user name fields to autofill with the users network login ID.

Any tips would be much appreciated.

 

[reclusivemonkey]

Try the

Environ(Username)

command.

 

[ghudson]

Searching the forum is a great way to discover and learn the answers to your Access programming questions.

How about using an Audit Trail

Also, you need quotes around the Environ variable...

Msgbox Environ("UserName")
Msgbox Environ("ComputerName")