Running a timed Macro

[Russell G]

Hi

I have a number of queries that I have included in a macro. I wish to run this macro at a certian time, usually after hours. I have been playing around with the RUNMACRO command and the CONDITIONS of the Macro, but dont seem to be getting it right.

What I am looking for is a way to start the macro at say 16:00 hrs but the queries must only be run say at 20:00 hours.

Your help is appreciated.

[NeoPa]

I never use macros, but if you post what you have already and why it's not what you want I'd at least have somewhere to start looking from.

[MMcCarthy]

Also the database must be open for any queries to run. Access cannot run anything when the application is closed.

Mary