automatic start every night

  • Thread starter Thread starter Michel Peeters
  • Start date Start date
M

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
 
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.
 
tks Alvin, michel


Alvin said:
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


.
Click to expand...
Click to expand...
 
Back
Top