display user logon name

  • Thread starter Thread starter Lynn
  • Start date Start date
L

Lynn

I would like the user logged into the data base to have his/her name appear
automatically in the name field of all edited records in a form
 
I don't beleieve you can access the user's name unless you have the user
enter their name when they login or deduce their name from a table of login
id and name.

The login id (from Windows) is available by running:
Dim strUser as string
strUser = Environ("Username")

or you could use the function fosUserName (google it for details)

-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
Back
Top