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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Stamp Userid

Status
Not open for further replies.
humphreyoji

humphreyoji

Technical User
Sep 30, 2004
12
NL
If I have fields called USERID and DATETIME in my table and I want the userid of the logged-on user as well as date/time to be stmaped when a record is updated, what do I do ?
 
Sort by date Sort by votes
If you're entering/editing data through a form, use the form's BeforeUpdate event to populate these fields... VBA along the lines of...

Me.Userid = CurrentUser()
Me.[Datetime] = Now()
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

fishtek
  • Locked
  • Question
Date stamp in table for when record was last exported 1
Replies
3
Views
50
fishtek
fishtek
realtallgal
  • Locked
  • Question
Date Stamp
Replies
1
Views
39
PHV
PHV
officemanager2
  • Locked
  • Question
time stamped notes 1
Replies
19
Views
118
officemanager2
officemanager2
RandDUser
  • Locked
  • Question
Add Time Stamp to Every Record
Replies
5
Views
49
RandDUser
RandDUser
osp001
  • Locked
  • Question
Date stamp
Replies
1
Views
15
TheAceMan1
TheAceMan1

Part and Inventory Search

Sponsor

Back
Top