How do i show the date a report or query was last run?

  • Thread starter Thread starter Sean Bishop
  • Start date Start date
S

Sean Bishop

I am using Access 2007.

I have several reports and queries which are run on a fairly regular basis.
What I would like to be able to do is show the date the report was last run.

Is there any way I can show this on a form which would show the name of the
report or query and the date it was last run.

Thank you for any help you can give me.

Sean Bishop
 
The easiest way I know is to have whatever triggers your report to also
append a record to a table and to use DLokup on form to display Max dated
record.
 
If you are starting your report from a form (like you should be doing), add
a datefield to the underlying data table and a line in your code will save
the run date to that field overwriting the previous entry. Something as
simple as:

Me.txtDateField = Date

should work, assuming txtDateField is the name of the textbox, with that
data.
 
Back
Top