how do I set up macro in access to run a query at a specific time.

T

TPratt

I'm sure the MVP's will have a better answer but if they don't....

I use the windows scheduler to kick off macros.

Set it up to run Microsoft Access at a specific time every day by using the
wizard first.

Then open the properties of the new scheduled task and, in the "Run" box, go
to the end of the data already there and type the following starting with a
space.

"Path of your database.mdb" /x NameOfYourMacro

It works pretty good and you can use the scheduler to compact a database as
well by typing /compact in place of the /x NameOfYourMacro.

T
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
Macro warning in word 1
Creating a Chart on form from selected data in query. 0
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Countdown macro - display settings 2
How do I convert shading to highlighting for specific colors 8
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top