Displaying the date when a macro was last run

J

John V

I have a macro set up to update information from a server. How can I show on
the switchboard when the macro was last run?
 
S

Steve Schapel

John,

I would think the date/time of the latest run should be stored in a
table somewhere. You could make a simple table with one field and one
record, specifically for this purpose. Then, add an action to the macro
itself to run an Update Query to change the value of this date/time to
Now(). And then, I suppose, bind the switchboard to this table, or add
this table to the query (if any) that the switchboard is currently bound
to, or put an unbound textbox on the switchboard form and use the
DLookup() function to retrieve the date/time value from the table. Hope
that makes sense.
 

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

Top