Returning Workstation Name

[Sion Smith]

Hi everyone

I want to be able to return the name of the workstation
that a particular user was using when they entered data.
I.e. as soon as a record is created I need a field that
returns CurrentUser() and - CurrentMachine/Workstation() -
unfortunately although access knows the user details
through CurrentUser() I need to know which workstation
they were on at the time.

Am I going to have to use WMI or is there a built in
object / variable that will return this value??

Cheers
Sion

 

[Cheryl Fischer]

There is a function available at:

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

that you can copy into a public module. Just use it in the same way that
you use CurrentUser().

 

[Sion Smith]

Cheryl,

That is very spooky, I have just found the exact link
you've added to your post! I think I'll go and put a
lottery ticket on now........

Many thanks
Sion Smith

 

[Cheryl Fischer]

And, if you win, you'll cut me in for a percentage??? <smile>