get the login user name ?

[joyaccess1]

Hi,
I need to capture the windows user name who modifies the data in the form/table, is there a function or command to capture it in access 2007 ?

Thanks for the help
Joy

 

[boblarson]

This should reliably get it for you:

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

 

[joyaccess1]

Thanks Bob, with the instructions i was able to capture the user id during the insert, need to know how can i use fOSUserName() in the default value for the field property, Thanks.

 

[boblarson]

I don't think it will work as a default at table level. You really need to keep users out of the tables and use forms for user input as you have more control over things.

 

[joyaccess1]

Thanks bob, will use it in the form then....Thanks