cousinconley
MIS
I have a macro in Access, say macro1, that copies data and sends it to an Excel file. I have a second macro, say macro2, that runs macro1 repeadily. What command do I use to have macro2 run macro1 every 15 minutes?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do I set my macro to run every 15 minutes?
- Thread starter cousinconley
- Start date
- Status
GeekinGlasses
Programmer
The Easiest way I found (and I'm sure there is a better way in VBA code) is to create an unbound form. Then on the ON TIMER event run your macro (ie macro2), then set the TIMER INTERVAL to 900,000. (1000 = 1 second)
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question