Slightly OT - VBA Get computer name?

[Sean Mc]

I know this isn't really an Access question, but I will be running this from
Access VBA.
Does anyone know the method for returning the Computer Name of the local
machine?

Thank You,
Sean Mc

 

[Albert D. Kallal]

Actually, you right on topic, and you asked a good question in the right
place:

You can get the current network logon name with:
http://www.mvps.org/access/api/api0008.htm

And, the current computer name with:
http://www.mvps.org/access/api/api0009.htm

And, if using ms-access security, then currentuser() will return the
ms-access logon.

I often log all 3 of the above values in some applications.

 

[Arvin Meyer [MVP]]

Sure. Try:

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

 

[Sean Mc]

Just wanted to say thanks to both of you for your replies - been away and
couldn't try this out right away, but it did exactly as I was hoping.
Thanks -
Sean Mc