General discussion

Locked

Capturing LogIn ID

By donq ·
I have an Access 2000 Form (named ?PORmaint?) with a text field named UID (for user ID) on the form. Every time a user creates a new record I want Access to reach into the operating system, grab the Log-In User ID and paste its value into the records ?UID? field. I eventually need this to operate on any Windows and/or OS/2 operating system as well as Unix. The task should be reasonably simple for any of you MCSE type ?gurus? that have a limited knowledge of Access and/or VB but I have no clue where to begin. I would be extremely grateful to anyone providing commented code or pointing me toward a reference I can download. (this is how I will identify employees submitting a Purchase Order Request to the Purchasing Department over an intranetwithin an application module I am currently building) Thanks in advance - Don Quigg at <databyte@mindspring.com>

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Capturing LogIn ID

by JoeTech3 In reply to Capturing LogIn ID

Use the CurrentUser function. Set up a macro that saves the value into your field. Use the After Change event. Hope this helps.

Collapse -

Capturing LogIn ID

by donq In reply to Capturing LogIn ID

Too simple! You shamed me into breaking out the old Language Referance book so I could apply CurrentUser to a Form's BeforeInsert Event.

Good Help and thanks a ton!

Collapse -

Capturing LogIn ID

by donq In reply to Capturing LogIn ID

This question was closed by the author

Back to Windows Forum
3 total posts (Page 1 of 1)  

Operating Systems Forums