Automated data

[joe31709]

Right now I have an append Query setup to add users , there hours and date into a table. I am curious is there a way to do this automated, like it adds it to the table every day with out having to run the query.

Any info on how or where to look at would be great.

Joe

 

[llkhoutx]

Look at the Timer event. It allows code to be run at a particular interval or if the program does not run continuously, having the Timer check the clock and run your query at a specific time, or after a specific time if it hasn't been run yet because no one has run the program.

The concept is simple, but one needs to think of all the circumstances under which the query is run.

 

[joe31709]

Sounds good but um what do i need to do?

Thanks

Joe

Edit ...

Could i do this use the run macro , macro and do a requery to my append query?