Record time report, macro or query runs

[argniw]

I need to track each time a report runs in my Access database, and
append the timestamp to a simple table. Along with the timestamp I
want to put in the user id (I already have a function that gets this)
and the report or macro name that just ran. What is the best way to do
this?

 

[Allen Browne]

Use the Open event of the report to record that fact that it ran.

In the event, execute an Append query statement that add the record to your
logging table.

You can use RunSQL in a macro, or Exeucte in code. Here's more detail about
how to run an action query, and which is better:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html