Computer Name

[teel73]

Is there a way to find out what the computer name of the computer that's logged in to the database. For instance, I have a workgroup file that's associated with my database. I can set a variable to CurrentUser() and it returns the current user logged in. How can I retrieve the computer information from the computer logged in?

 

[pbaldy]

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

 

[rainman89]

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

 

[boblarson]

You can use this:

Environ("computername")

or:

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

 

[rainman89]

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

Ahhh you beat me to it!

 

[boblarson]

Holy cow! Three of the same posts in a quick time span. <rofl>

 

[Rabbie]

Holy cow! Three of the same posts in a quick time span. <rofl>

Atleast you all gavethe same answer so it must be right!

 

[boblarson]

Atleast you all gavethe same answer so it must be right!

We certainly HOPE so, eh? It would be bad if we all gave the wrong answer (not likely but certainly possible).

 

[rainman89]

We certainly HOPE so, eh? It would be bad if we all gave the wrong answer (not likely but certainly possible).

If it came from me its probably wrong

 

[boblarson]

If it came from me its probably wrong

Not true anymore Ray. I am sure that you are right way more than you are wrong now

 

[teel73]

thanks guys. that worked perfectly.