automatic start every night

[Michel Peeters]

I would like to start Access every night for importing a table.
The code starts with the AutoExec macro.
The application stops also automaticly.

Any idea?


tks
Michel

 

[Alvin]

Forms have an "On Timer" event. If you can leave the
Access App running when you leave for the day, your last
action could be to click a cmd button, e.g. "[Start
Timer]", which would set the timer event to fire at the
desired time. that is, the button would calculate the
time between Now and desired run start, then set the timer.

I suppose you could add similiar code to the on start
macro for the app so you wouldn't have to remember to
click the [Start Timer] button before leaving.

 

[Michel Peeters]

tks Alvin, michel

Forms have an "On Timer" event. If you can leave the
Access App running when you leave for the day, your last
action could be to click a cmd button, e.g. "[Start
Timer]", which would set the timer event to fire at the
desired time. that is, the button would calculate the
time between Now and desired run start, then set the timer.

I suppose you could add similiar code to the on start
macro for the app so you wouldn't have to remember to
click the [Start Timer] button before leaving.

-----Original Message-----
I would like to start Access every night for importing a table.
The code starts with the AutoExec macro.
The application stops also automaticly.

Any idea?


tks
Michel


.