Date Macro Last Ran

  • Thread starter Thread starter frustratedwthis
  • Start date Start date
F

frustratedwthis

I am not sure if this is possible, however, I have a "reporting" db. I have
a macro that updates the information from a MySQL table. All works
beautifully, EXCEPT, when I run my reports, they say "As of (DATE())". The
problem being, the tables might not have been updated today. Is there a way
to have the report read "As of (last date macro was run)" ?

Hope this makes sense!!

Thanks in advance!!
 
Add a date/time field to the table.

Change the Update query so it writes Date() into the field.
It will have the same value on every row, but it's a simple fix.

Other alternatives would be to create a table with a date field where you
append a record each time the table is updated, or use custom properties.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...
 
I was working on the second solution you mentioned and it works perfectly :)
Thanks for your prompt response!!
 
Back
Top