Novell user login name 1

[dvannoy]

I run 4 novell servers. with 4 access databases. what i want to do is, when a user makes a change or adds a record I want it to stamp there login name into a field..is this possible with novell??? if so does anyone have some code that will do this??

Thanks

 

[JoeMiller]

If the windows login name is the same as the novell login name (which it most likely is) then you can use the Environ function to get the user name. This function returns the currently logged in user as a string which you can then set up a control (IE: txtUserName) on the form that is mapped to a field in the table for storing the user's login. On the AfterUpdate event of the form put in code like so:

txtUserName = Environ("UserName&quot

It's also a good idea to date/time stamp the time when the change occurred so I would add another control (IE: txtChangeDate) and put a line right under the username function that goes:

txtChangeDate = Now()

Then you'll have an audit trail with time and username. Hope that helps!