Date and Time

#1 (**permalink**) 28-Jul-2006, 08:10 AM

How do you add a field to create a date and time stamp of all edits to a
record?

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10173-date-and-time.html

*

#2 (**permalink**) 28-Jul-2006, 08:10 AM

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".

--
Rick B

"Newbie to Access" Access@discussions.microsoft.com> wrote in
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10173
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10173
message news:6593E791-E31D-4822-BD71-69D528F57AFD@microsoft.com...
> How do you add a field to create a date and time stamp of all edits to a
> record?
>

#3 (**permalink**) 28-Jul-2006, 08:10 AM

Open the table in design view. Add a Date/Time field called dtmModDate, or
whatever you want to call it...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10173
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10173

In the form that is used to edit the record you can add the following in the
AfterUpdate event:

dtmModDate = Now()

"Newbie to Access" wrote:

> How do you add a field to create a date and time stamp of all edits to a
> record?
>