How To Automatically Run A Macro Once A Day

[jereece]

I have a database on a LAN that operates 24/7. I have several queries in this database that I have a macro set up to launch when I click on a button. Problem is these queries take a little time to run. I would like to know if there is a way I can have my macro launch and run all my queries at night...say around 9pm. Does anyone now of any way to do this?

Thanks,
Jim

 

[Brian1960]

Can you re-write them as a BAT or VBS file and then just use the scheduler in your server.

 

[ibjhb]

Try this as a daily scheduled task:

"C:\MSOffice\Microsoft Office\Office\MSACCESS.EXE" "J:\yourdatabase.mdb" /x macronamehere

 

[stevenjones35]

If the windows scheduler doesn't work, you can use a form and the On timer function to call the macro at a certain time, provided the database remains open. Its pretty easy to work out but may take some playing around with. There are several macro scheduler programs out there that use the same On Timer functions, my favorite is:

http://macros.subpacket.com

Its open source and very easy to understand the logic in making the macro (no VB code), so you can basically change it around to suite your needs. Costs $30 bucks, but well worth the money provided it took me over 6 hours to initially figure out a similar process when I first had the same problem..

Steve