datestamp

  • Thread starter Thread starter -EvaMendes
  • Start date Start date
E

-EvaMendes

How do I make a datestamp on the records of a table when there is
modification or creation? I am using access97. Thanks.
 
How do I make a datestamp on the records of a table when there is
modification or creation? I am using access97. Thanks.

Creation's easy: put a Date/Time field in the table (call it DateCreated) and
set its Default Value property to either =Date() to store the date, or
(probably better in most cases) to =Now() to store the date and time that the
record was created.

Tracking modifications is harder: table don't have usable events. you'll need
to take steps (using Access security say) to ensure that users can ONLY update
the table using a Form that you develop. In the Form's BeforeUpdate event set
a date/time field to Date() or to Now() as appropriate.

John W. Vinson [MVP]
 
Back
Top