Recording User login

[shaz123]

Hello,

I am developing a cylinder tracking system, when i user logs in its necessary to record this action, as when they try to fill a cylinder i need to be able to record that this particular employee has updated the table and by recorindg the user login in i will able to do this.

IS the anyway of being able to record whos logged in?

 

[edtab]

One way to capture the user name is via the Environ function.

Syntax : Environ("UserName")

You can store the value derived from this function
in your table. I usually trigger this update via a DoCmd.RunSQL.