Query when another query was run

Number Six

Number Six
Local time
Today, 04:48
Joined
Jun 24, 2005
Messages
14
Is it possible to run a query to find out when (ie date and time) another query (or report) was last run?

If it isn't possible to do this by a query is there a bit of clever visual basic I could use? I'm fairly OK with queries but a complete novice on visual basic.

The reason for asking this is that we use Access a lot in the company I work for and it would be useful for my successor to know when certain reports had last been run.

Thanks
 
Last edited:
You could have a report table with the names of all your reports and a date column.

When a report is run update (using an update query) the date column in the report table that corresponds with the report
 
The query def object will tell you when the query was last updated. You could write some could to retrieve when each query was last ran and display it on a form
 

Users who are viewing this thread

Back
Top Bottom