saving username and updating date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi
i have database and i want to share with my collegues at work
i need a code to keep record on the user hwo entered or updated records
suppose users are ( user, date)
 
Use the BeforeUpdate event procedure of your *form* to record this
information.

Privat Sub Form_BeforeUpdate(Cancel As Integer)
Me.[UpdatedBy] = CurrentUser()
Me.[UpdatedOn] = Now()
End Sub

If you want to record the Windows user name instead of the Jet user name,
see:
http://www.mvps.org/access/api/api0008.htm
 
Back
Top