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 SkipVought 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
0
0
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
91
MattGreer
MattGreer
Moss100
  • Locked
  • Question
Stop user changing size of Access Application (not form)
Replies
1
Views
153
Andrzejek
Andrzejek
DarkOne72
  • Question
Message Box Popup on certain days help !
2
Replies
23
Views
506
Norman Sherlock
Norman Sherlock
bobbyer
  • Locked
  • Question
ms accesss option group on report
Replies
4
Views
74
bobbyer
bobbyer
Moss100
  • Locked
  • Question
Transfer data from external table to identical local table - urgent please
2
Replies
27
Views
287
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top