run a proces or kind of deamon in Access 1

[nkamp]

Hello,

I'm new to access.
I have in Access at certain times to execute a query which is exporting an XML file.

Is it possible to write some code in VBA access which is running in the background or sleep for a certain time. Wake up, checks if a certain time is passed and if so the query is executed which is exporting data to a XML file.

How do I write a routine which is running in the background and wakes up at a certain time.

I hope that my question is clear.

Thanks in advance.

Nico

 

[PHV]

Have a look at the Timer event of the Form object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886