Share via

Access record modified date

Anonymous
2010-07-26T19:02:00+00:00

How do I get Access to automatically return a date on which the records in my table are added or modified? Thanks!

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2010-07-26T19:07:22+00:00

    Use a form to modify the data.  Then you can use the form's BeforeUpdate event to set the last modified date field:

       Me.[last modified date field] = Now

    If you also want a date created field in the record, set the table field's DefaultValue property to Now()

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  2. Anonymous
    2010-07-29T18:46:41+00:00

    Hello,

    You can capture when the record was added by using a field of DateTime type in your table (like TimeStamp ). Set it's Default property=Now(). However, to caprute modified date - you need to follow directions provided by Marshall Barton.

    Nadia

    Was this answer helpful?

    0 comments
  3. Anonymous
    2010-07-29T18:34:44+00:00

    Thank you!

    Was this answer helpful?

    0 comments