schedulling MS Access

[TIbbs]

I want to schedule my application that on opening a form it will run a piece of code every minute, how would I go about it?
I was thinking maybe looping the code and on opening the application the code would be run unless someone pressed a button to quit.
What's the best approach?

 

[Kenln]

You can use the Time Interval property to set the amount of time.

Then use the On Timer event to preform your action.

You will need to keep the form open so you may wish to open it hidden.

 

[TIbbs]

the problem I have is that I just want my application to run the code, load an xml file and append to it, when finished to look for new records and append to the file if new records exist, if no records exist to wait a while then look again.
Can that be perfoprmed with the timer event?

 

[MrQ]

Hi Tibbs,
How does your code currently identify new records?

Q

 

[Kenln]

If you're using code now, there shouldn't be any difference. You just call the routine (or function) from the Timer Event or put the code in the form itself.

Either way the database and form both need to be open, but other than that it should work.

Do a search for AutoLogOff. This is an example of using a Timer Event to bump people off of a database.

 

[TIbbs]

Hi Tibbs,
How does your code currently identify new records?

Q

Sorry for replying late, I was away for a few days and only looked at it again now.
Each table has a Posted Yes/No field and a PostedDate field.
I load a recordset using ADO and pull out the data from each table where the Posted field is set to false.
After posting the data into the xml file I set the Posted field to true and set the PostedDate to today's date.
I am working on my timer now so will post again. Thanks for all the help.