computer name

[Isaac Sh]

I need to get the computer name (the one one can see in the network identification tab) using VBA. Is that
possible?

TIA,

 

[Allen Browne]

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

If you want the network user name, see:
http://www.mvps.org/access/api/api0008.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to the newsgroup. (Email address has spurious "_SpamTrap")

I need to get the computer name (the one one can see in the network

identification tab) using VBA. Is that

 

[Isaac Sh]

Many Thanks!

--
Yizhaq Shmaayahoo

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

If you want the network user name, see:
http://www.mvps.org/access/api/api0008.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to the newsgroup. (Email address has spurious "_SpamTrap")


identification tab) using VBA. Is that

 

[Mart]

You may wush to try a quicker version...


strComputerName = Environ("ComputerName")

and for the user

strUserName = Environ("UserName")

if you do a for next loop for 0 to 256 you'll see a whole
host of bits in the Environ collection.

for x = 0 to 255
debug.print Environ(x)
next x

M.