N
Nick
Is there any way I can put a field in a table that records who the last
person was that touched a record?
Thanks.
person was that touched a record?
Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick B
Yes. Do a search for "timestamp" or "audit trail". This is addressed in
here pretty often. You should find previous posts that point out how to do
this, and maybe even some links to sample databases and code.
You should always search the newsgroups before posting a new thread.
Hope that helps,
Rick B
here pretty often. You should find previous posts that point out how to do
this, and maybe even some links to sample databases and code.
You should always search the newsgroups before posting a new thread.
Hope that helps,
Rick B
A
Arvin Meyer
Nick said:Is there any way I can put a field in a table that records who the last
person was that touched a record?
Use the Before Update event of the form, something like:
Sub Form_BeforeUpdate(Cancel As Integer)
Me.txtLastUpdated = Now
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
L
Lynn Trapp
If you implement user level security, then you can use the following code to
insert the user name of the last person to update a record.
Sub Form_BeforeUpdate(Cancel As Integer)
Me.txtLastUpdatedBy = CurrentUser()
End Sub
insert the user name of the last person to update a record.
Sub Form_BeforeUpdate(Cancel As Integer)
Me.txtLastUpdatedBy = CurrentUser()
End Sub