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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show the date of the last time the query was run 8
Restrict a report to a given date range 2
Reporting the last two updates 7
show last date in a query and report - JCW 1
do I want a report or a query? 2
Count records returned from Query 4
Access Access Report Works on One Machine but not Another 3
Data from a query and from a table on the same report. 2

Back
Top