append query to be activated on a specific date

  • Thread starter Thread starter Gunther Dawson
  • Start date Start date
Use whatever form or module your app starts up with.
Check the current date against the date you want to run the query.
 
What you could do is set up a macro that runs your query, but finish off
your query with the 'quit database' command. Then create a shortcut of your
macro on your desktop or wherever you want. Finally set up Windows' Task
Scheduler to automatically run the macro (via the shortcut) whenever you
want. The advantage of this method is that you don't need to open the
database yourself to run the query. You don't even need to be there! As long
as your PC is on, the Task scheduler will open it for you automatically and
the set date & time and the quit command in the macro will automatically
close the database when complete.

Hope this helps

David
 
Back
Top