Wait or Delay or Wakeup

  • Thread starter Thread starter John Proctor
  • Start date Start date
J

John Proctor

I have jobs that must run from Access that uses our SQL
data through ODBC. These jobs are started by users who
leave work at 4:00, but they slow down the system for the
users who are still working till 5:00. I need the 4:00
workers to start the process, and have it sit and wait
until after 5:00. How can I have this happen?
Thanks.
 
I would put, behind a command button, code that calls a
form with a timer on it. In the ontimer event, have it
check the local time. If the local time is 5pm (1700) or
hour(now()) = 17, then begin the process desired and close
the form with the timer.

BB
 
I have jobs that must run from
Access that uses our SQL
data through ODBC. These jobs
are started by users who leave work
at 4:00, but they slow down the
system for the users who are still
working till 5:00. I need the 4:00
workers to start the process, and
have it sit and wait until after 5:00.
How can I have this happen?
Click to expand...

An approach to putting an application temporarily to "sleep" using the
sapiSleep API is described at http://www.mvps.org/access/api/api0021.htm.

Another approach is to using the Timer property of an Access Form, and
checking the time in the Timer event when it fires. Once it reaches the time
and you initiate the process, disable the timer so you don't initiate the
same process over and over again.

Larry Linson
Microsoft Access MVP
 
Back
Top