How do you pick up the user? 1

[MikeRBS]

I have an app (someone else wrote it) that displays items for lots of people. I would like to display only those connected with the user. ie something like WHERE T1.USERID = NT_LOGON_ID. I can't see anything in Help. Any suggestions - I want to avoid them having to sign on to the app.

 

[PHV]

Take a look at Environ("USERNAME")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[MikeRBS]

PHV

Works a treat. A new field Userid: environ("username") gets the NT logon. Wasn't in Help. I found these whilst looking:

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

http://www.tek-tips.com/gfaqs.cfm/pid/181/fid/3779