G
Guest
How do you add a field to create a date and time stamp of all edits to a
record?
record?
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
This is a very common question. Do a search and read the previous posts on
the topic. Look for the keywords "timestamp" or "audit trail".
the topic. Look for the keywords "timestamp" or "audit trail".
R
Rick B
This is a very common question. Do a search and read the previous posts on
the topic. Look for the keywords "timestamp" or "audit trail".
the topic. Look for the keywords "timestamp" or "audit trail".
G
Guest
Open the table in design view. Add a Date/Time field called dtmModDate, or
whatever you want to call it...
In the form that is used to edit the record you can add the following in the
AfterUpdate event:
dtmModDate = Now()
whatever you want to call it...
In the form that is used to edit the record you can add the following in the
AfterUpdate event:
dtmModDate = Now()
G
Guest
Open the table in design view. Add a Date/Time field called dtmModDate, or
whatever you want to call it...
In the form that is used to edit the record you can add the following in the
AfterUpdate event:
dtmModDate = Now()
whatever you want to call it...
In the form that is used to edit the record you can add the following in the
AfterUpdate event:
dtmModDate = Now()