Discussion Locked

Capturing LogIn ID

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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

3 replies

by joetech3

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

by donq

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!

This discussion is closed to new replies.