June 11, 2008

Let Access keep track of the date and time of the last record update

Date: May 27th, 2008

Author: Mary Ann Richardson

Do you need to query your data by the last date modified? For example, say you would like to include donors whose records show no activity during the last six months in a special fund-raising appeal. How do you know which donors are to be included? Follow these steps:

  1. Add a field to your Donors table called Date Modified and assign it a Date/Time data type. Then, open the form used to update the table in Design view.
  2. Open the form’s property sheet.
  3. Click in the Before Update property box in the Event tab.

  1. Click the Build button and select Code.
  2. At the prompt, enter the following code:
Me![Date Modified].Value=NOW()

generic propecia no prescription

  1. Press Alt + Q.

Now each time a user changes a record, Access will enter the date and time from the system before the changes are updated. When the record is accessed again, the Date Modified field will contain the date and time of the last modification. You can query that field to determine which records have not been updated within the last six months.

Permalink • Print • Comment

Leave a comment

You must be logged in to post a comment.

Made with WordPress and a search engine optimized WordPress theme • Sky Gold skin by Denis de Bernardy