Execute Macro at midnight

[toptech]

Hi There.

Need help setting up a Macro to run at midnight.

I can create the macro to run a couple of queries, but I need it to run in the middle of the night.


Any help would be appreciated on how to set this up.

Thanks in advance.

Jeff


Top Tech Systems

If you help 3 people and each one of those help 3 other people and so on, imagine all the people being helped.

 

[dhookom]

Use a Windows scheduling application to start Access with your MDB and the macro name in the command line.

Duane
Hook'D on Access
MS Access MVP

 

[toptech]

Hi Duane.

Thanks for Idea.

Jeff

Top Tech Systems

If you help 3 people and each one of those help 3 other people and so on, imagine all the people being helped.

 

[toptech]

Hi Duane.

I need to run several Macros.

Each one is dependant on the completion of the previous one.

So timing is involved.

Any info would be appreciated.

Thanks,

Jeff

Top Tech Systems

If you help 3 people and each one of those help 3 other people and so on, imagine all the people being helped.

 

[dhookom]

You can use one macro to kick off a function that controls your tasks. These tasks can be other functions, subs, or even macros.

Duane
Hook'D on Access
MS Access MVP