Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

log on user ID

Status
Not open for further replies.
Data69

Data69

Technical User
Jan 24, 2003
24
US
I have a multi-user database and I want to capture the logon user name in my table when a record is updated. How do I do this?
 
Sort by date Sort by votes
Capture the CurrentUser in a string variable then update the record with that value.

Dim UserName as String

UserName = CurrentUser
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Johnny S
  • Locked
  • Question
Create folder based on ID field MS Access
Replies
3
Views
148
MattGreer
MattGreer
Moss100
  • Locked
  • Question
Stop user changing size of Access Application (not form)
Replies
1
Views
355
Andrzejek
Andrzejek
DarkOne72
  • Locked
  • Question
Message Box Popup on certain days help !
2
Replies
23
Views
879
Norman Sherlock
Norman Sherlock
bobbyer
  • Locked
  • Question
ms accesss option group on report
Replies
4
Views
132
bobbyer
bobbyer
Moss100
  • Locked
  • Question
Transfer data from external table to identical local table - urgent please
2
Replies
27
Views
433
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top