Run Append query

[amfroehlich]

I have a macro which runs a couple append queries. Is it possible to make that macro run everyday at a certain time by itself?

 

[jsi]

Oneway
1. create a new db
2. Create a form to open at startup
3. On the Open event of the form, place the code to run the append queries
4.Save and close.
Use Windows scheduler to open the db at specific times of the day.
If you need more details, shout out.
HTH
Jim

 

[amfroehlich]

This sounds like a great idea. Thank you

 

[jsi]

Glad to help.
Note** Remember to link the required tables into your Automatically opening Db

Jim