Getting User Information Automatically - Please Help!

[John]

How do I get user information for people using the data
base? I don't want to have to set up user groups in the
security section.
The database will be used through a Citrix environment and
I would like to get the Citrix user name. If not that
then maybe just the machine name to keep track of users
that access the database.

Thanks in advance.

John

 

[Cheryl Fischer]

John,

I am not sure about the Citrix environment; however, there is code for
getting the network user name at:

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

and, for machine name, at:

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

Give it a try and let us know ...

 

[Cheryl Fischer]

The following should work for User Name - just substitute the
fOSMachineName() function if you're going for Computer Name:

1. Create an unbound text box on your form.

2. In the Control Source property, insert:

=fOSUserName()

3. Set the Enabled property to False so that the user cannot change it.

 

[John]

Thank you Cheryl!!!! This works perfect and it gives me
the information that I need. Now all I have to do is
create a way to write that to a table with login time.

Thanks for your help!

John