Setting up a shedule

[simon4amiee]

Hi guys, I know very little of code, but finding a few things out that are really my life easier. I have set up a macro which is very simple and just opens a number of queries. I dragged the macro to my desktop and then moved it to my StartUp menu on my PC. The result is when I turn my computer on it opens my database and runs these queries saving me some time.

Can I Impove on this?

Based on the same idea, what I am looking at doing is setting up a schedule where the macro runs a set of queries based on a date (I get my monthly work shedule in advance).

To explain I have a number of queries I run daily, and some weekly, and some just once a month, is this possible to build into a macro so that I dont have to remember to run all these and they run automatically.

 

[plog]

Windows Task Scheduler: http://windows.microsoft.com/en-US/windows/schedule-task#1TC=windows-7

This isn't an Access solution per se, its a windows thing. You can use it to have Access macros at specific times and intervals. You will still need to build the macros in Access, but then you schedule them using Windows Task Scheduler.