create log of macro use

[mcalvanelli]

I would like to create a table that will update with the date and time that a certain macro is run, everytime that macro is run.

I have the macro created, but how do I get it to update the table when it is run with the current date/time?

Thanks,
Melissa

Melissa Calvanelli
Assistant Court Administrator
Cumberland County, PA

http://www.ccpa.net

 

[JeremyNYC]

Make an update query that updates the table you want. Call that update query in your macro.

Jeremy

---
Jeremy Wallace
METRIX Project Coordinator
Fund for the City of New York