How do I set my macro to run every 15 minutes?

[cousinconley]

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?

 

[GeekinGlasses]

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)