Extract user id

[Guest]

Within my database I have a notes system which allows network users to go on
and add notes to jobs.

If i create a new column called 'user id' on my notes table and form, is
there a formula or function that will extract the users network id and enter
it into the note. This will allow us to trace who put the notes on.


Any help would be apprecited

Christopher Buxton

 

[Brendan Reynolds]

There's code to retrieve the network user name at the following URL ...

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

 

[Allen Browne]

You can get the network user name with the code in this link:
http://www.mvps.org/access/api/api0008.htm

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

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...

 

[Guest]

There is a much easier solution then that. Simply use Environ$("UserName").

It will return you the username of the person currently logged on the PC.

Yanick

 

[Dirk Goldgar]

There is a much easier solution then that. Simply use
Environ$("UserName").

It will return you the username of the person currently logged on the
PC.

That's dependent on the operating system's storing the value in that
environment variable, and on the devious user not changing it.