Append Query every day at certain time automatically

[ant1983]

Hi,

So i have a query qryStats. Basicaly i want to be able to see how the stats
have changed over a period so i was thinking of turning that simple query
into an Append Query so that it just add the results to a table tblStats.

I tested it and it works great so i can design reports and the result is
exactly what i want.

Problem is im going to forget to run the query each day. What are my
options? Can i write code of some kind that runs the append query each day
at, lets say 16:00?

 

[ruralguy via AccessMonster.com]

YES but your db would need to be running in order for that to work. You could
also create a scheduler task to run your db at a certain time and pass it a
command line parameter.

 

[ant1983]

Yeah the db would be open so thats not a problem. Alternatively, if i open
or close the db and it prmpted me; that could work to.

Do you know how to do it as im a novice?

 

[ruralguy via AccessMonster.com]

I run a hidden for as the first form to load in my systems. You could then
use the timer event of that form to watch the time. It is useful for all
kinds of housekeeping chores. It is also the last form to close so you can do
clean up or stop the closing if you want. I would set the timer interval to
maybe 30 minutes or whatever resolution you need. Too often and it can bog
down your system.

Yeah the db would be open so thats not a problem. Alternatively, if i open
or close the db and it prmpted me; that could work to.

Do you know how to do it as im a novice?

YES but your db would need to be running in order for that to work. You could
also create a scheduler task to run your db at a certain time and pass it a

[quoted text clipped - 12 lines]

 

[PieterLinden via AccessMonster.com]

The code here will do that...
http://www.mvps.org/access/modules/mdl0042.htm

Yeah the db would be open so thats not a problem. Alternatively, if i open
or close the db and it prmpted me; that could work to.

Do you know how to do it as im a novice?

YES but your db would need to be running in order for that to work. You could
also create a scheduler task to run your db at a certain time and pass it a

[quoted text clipped - 12 lines]

 

[ruralguy via AccessMonster.com]

Does the MVP Scheduler take less resources than just using the Task Scheduler
that is built into Windows?

The code here will do that...
http://www.mvps.org/access/modules/mdl0042.htm

Yeah the db would be open so thats not a problem. Alternatively, if i open
or close the db and it prmpted me; that could work to.

[quoted text clipped - 6 lines]