p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: Re; Track who updated a record.


Message #1 by PStreeter@C... on Mon, 03 Jun 2002 13:02:24 CST
Someone asked about this and I got clumsy and deleted the 
letter from my inbox then from the trash. I use the following 
for a "Before Update" procedure for the form.

Private Sub Form_BeforeUpdate(Cancel As Integer)
On Error GoTo ERR_Form_BeforeUpdate
 Forms!Admin_Inv_F000100!Last_Transaction_Date = Date$
 Forms!Admin_Inv_F000100!Last_Transaction_User = get_username()
Exit_Form_BeforeUpdate:
Exit Sub
ERR_Form_BeforeUpdate:
Resume Exit_Form_BeforeUpdate

"Last_Transaction_Date" and "Last_Transaction_User" are fields 
defined in the tables.

To the best of my knowledge Access has nothing built in to do this.

Paul



  Return to Index