How can I have MS Access Identify the Computer Name?

[Guest]

In my multi-user MS Access 2003 database I would like to identify and enter
the computer name into a record when a new entry is made. How can I have MS
Access identify the Computer Name and then enter that information into a
record?

 

[Allen Browne]

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

If you want the user name as well:
http://www.mvps.org/access/api/api0008.htm

 

[Guest]

You can create a new blank module in your database and copy the function from
http://www.mvps.org/access/api/api0009.htm. Save the module with the name
"modAPIs". You can then add a locked text box to your form with the default
value of
=fOSMachineName()