Creating a scheduled task

C

cdb

I am trying to create a scheduled task to run at the early hours of each
morning so I can run a fairly time consuming event before I get in. I have
read about the Windows Scheduler, but unfortunately as I'm on a work PC it
seems that it has been locked out from use, so is there any other way I can
run something automatically in Access??
 
A

AlCamp

Well, you could leave your Access application running (idling), and with a
Timer event, check every hour to see what time it is. (ex. is time between
1AM and 2AM?) When that time arrives, your code could be triggered.
An hour later, the time criteria would fail.

Seems as though that should be do-able...
hth
Al Camp
 
C

cdb

Having thought about it for a bit myslf, that was the only conclusion I could
come up with too, was just hoping for something a bit easier.

Cheers.
 
A

AlCamp

cdb,
Well... the easier method would be to use Windows Task Scheduler.
Someone else may have other ideas, but my solution is pretty reasonable.
Why not try it, and continue to wait for more responses. If you don't get
any more suggestions you can try a repost.
Using the Timer events is not that difficult (although every time I need
to use it I have to go back to Help for a refresher)
Try to just get it to set off a BEEP to start with... no need to
expirement with the real job.
Give it a go, we're here if you get stuck.
hth
Al Camp
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top