Capture Machine Name

[Sam]

I would like to capture the machine name of the computer making an update to
a table as part of an audit trail. Does anyone know the syntax/method on a
form for setting a field equal to the users machine name?

 

[Dan Artuso]

Hi,
This link will show you how:
http://www.mvps.org/vbnet/code/network/gethostname.htm

 

[Cheryl Fischer]

The code at the following link will get the computer name:

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

You can also get network user id with the code found at:

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

hth,

 

[Sam]

That works great. Thanks!!

The code at the following link will get the computer name:

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

You can also get network user id with the code found at:

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

hth,
--
Cheryl Fischer
Law/Sys Associates
Houston, TX

update on