Repeat macro every 3 minutes

[Guest]

I want to run a database in the background which will refresh data and print
reports say every three minutes from the time the application is started
until it is closed.

I would also like to program a delay because I have a shelled batch file in
my code and it needs time to run (maybe 20 seconds) before going to to other
code.

Please advise.

 

[Van T. Dinh]

Check Access (VB) Help on the Timer Event of the Form.

 

[Roger Carlson]

Check out this link:
http://www.thescarms.com/vbasic/wait.asp
for a method to wait for your Shell to finish executing before continuing to
process.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L