Running a macro at a specified time interval

[Dan Sprouse]

I am wanting to run a macro that will run a make-table
query at a specified time interval, specifically once a
week on Sundays. I've tried searching for help on this,
but have had no luck. Any suggestions?

Thanks for the help.

-Dan.

(to respond via e-mail, just remove the _no_spam part of
the email address).

 

[Casey]

Dan,

Use timer interval and on timer properties in conjunction
with the update of a textbox on a form by a macro that
sets the value of that text box. Then in the afterupdate
property of the text box that is updated with the time by
a macro that is assigned to the ontimer form property, in
that afterupdate property of that box create a macro which
will per the time that is existent in the text box use the
openquery method to open the make table query you are
interested in.

I actually typed this message in a much longer and
specific form for you, but the server failed to send it,
and blanked my screen, so I am sending you this shorter
version of what to do.

I am sorry if it is too short.

Casey