Searching the forum is a great way to discover and learn the answers to your Access programming questions.
Why not use the
Environ() funtion?!?
It tastes great and it is less filling.
Code:
MsgBox "Network Name = " & Environ("username")
MsgBox "Computer Name = " & Environ("computername")
Search the forum for the keyword ENVIRON and my user name for I have a sample db posted somewhere that will list all of the Environ variables.