Update date

[Ron]

I have an Access 2002 db that is tied to data from MS Project. Several times
a week I update the Access tables by saving the MS Project as an Access db
and overwrite the main data table. I make a number of reports available to
all departments that they access through a form. In this form is a list box
that gives the date and time that the data was updated. Is there a way to
have the list box automatically return the date and time that the data
tables are updated from the MS Project data? When the main data table is
overwritten from MS Project could that trigger an update of the time and
date in the list box and how could this be accomplished? Any help would be
appreciated.
Ron

 

[Guest]

I would add an UpdateDate field to your main table. Create 2 queries to
automate the process of updating the table. One query will be a delete query
that simply removes all the records from the main table. The other query is
an append query that will paste the new records into the main table. In your
append query, create an UpdateDate field as such: UpdateDate: Now()

Create a macro that runs the delete query first, then runs the append query
and assign the macro to a command button (cmdImport). When you click the
Import button, the macro will clear the records from your table, paste in the
new records, and assign the exact date and time you imported the records in
the UpdateDate field.