Run a query every 10 days etc

[kabir_hussein]

Hi i need to make a query run every 10 or so days as it is a query which checks if any printers in the database are running out of warranty

Can anyone help on this

I basically am trying to make this query run where if there is any data a report will preview stating this printer warranty is expiring etc

Many thanks in advance

 

[freakazeud]

re:

Hi,
there are two methods to achieve this...if the application is open 24/7 then use a form's on timer event to check the current system date and see if it what you need...then execute the query/report...if it is not open all the time then create a macro which checks the query/prints report or calls a procedure which does the same...then use the macro command line switch in a batch file and call it with some scheduling software like the windows scheduler. Some instructions on this method can be found here.
Make sure the last action of the macro is to shut down the application.
HTH
Good luck