I Isaac Sh Jun 30, 2003 #1 I need to get the computer name (the one one can see in the network identification tab) using VBA. Is that possible? TIA,
I need to get the computer name (the one one can see in the network identification tab) using VBA. Is that possible? TIA,
A Allen Browne Jun 30, 2003 #2 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") Isaac Sh said: I need to get the computer name (the one one can see in the network Click to expand... identification tab) using VBA. Is that
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") Isaac Sh said: I need to get the computer name (the one one can see in the network Click to expand... identification tab) using VBA. Is that
I Isaac Sh Jun 30, 2003 #3 Many Thanks! -- Yizhaq Shmaayahoo Allen Browne said: 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 Click to expand...
Many Thanks! -- Yizhaq Shmaayahoo Allen Browne said: 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 Click to expand...
M Mart Jun 30, 2003 #4 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.
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.
