Automated Routines

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to create an automated routine in the database that automatically
deletes records before a certain date.
Would I use macros or some form of query?!?
 
A Delete query is what will do the job; an Autoexec macro to run it
everytime you open the database might be a convenient trigger to run it.

HTH,
Nikos
 
If it needs to happen on a regular schedule you can always create a macro
inside the Access database to do it and then use Windows task scheduler to
run a batch file that will in turn open the database and execute the macro
that will delete the desired records at a preset time every day, week, or
month etc....
If you need more help with this let me know.

- SPARKER
 
hi..i have the same problem. I have an excel file contains pivot table and
I want to schedule a job like for example every friday morning to
automatically run the macro that will refresh the pivot table. Pls.
take note that the excel file has a password before opening. How can I do
that?
Thanks and thanks in advance.
 
Back
Top