Re: Access - Sleep function

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Wayne Morgan (comprev_gothroughthenewsgroup_at_hotmail.com)
Date: 11/19/04 

Date: Fri, 19 Nov 2004 07:20:18 -0600

For the Sleep command to work while using Shell, the loop that does the
checking will need to be in VBA, calling Shell each time you loop. If you
place the loop in a batch file (or whatever you're calling from Shell) then
you will need to put the pause there instead. If it is a batch file that
you're calling, there are some Dos utilities that will do what you ask. They
are tiny and can probably be found as a free download. They work similar to
Sleep. One I have used is called Wait.com. To use it the syntax is simply
(wait 1000). 

-- 
Wayne Morgan
MS Access MVP
"ceeuk" <ceeuk@discussions.microsoft.com> wrote in message 
news:DEBE7383-5287-45B4-8B93-52B3CBFA2C43@microsoft.com...
> how can I make an access function 'sleep' for a short period.  I want to
> check the results of a query, process them, then wait for a short period
> (e.g. 20 seconds) before checking the query results again.  I've looked at
> using the windows 'sleep' command but access issues the shell command
> asychronously so that won't work.  Has anyone else had a similar problem?

Relevant Pages

  • Re: Starting a process inside a shell script
    ... > without calling wait or sleep to wait for the process to start. ... sign is there that this switchover has occurred? ...
    (comp.unix.programmer)
  • cant get out of infinite while loop
    ... To get into the infinite loop, I write to a file the "on" status ... writing switch on ... ready to sleep for 10 seconds ... or die "Problem passing files to the bridge directory...$!"; ...
    (comp.lang.perl.misc)
  • Re: Unix-ify File Names
    ... special characters do make it more difficult to handle arbitrary file ... At least in POSIX shell. ... it's old value inside of the loop. ...
    (Debian-User)
  • Re: question about thread scheduling
    ... I doubt you will need to mess with the system tick to get what ... I will try what you suggested, the reason that I didn't use the sleep ... If the NN run in a different thread as the control loop ... Sleepputs your thread to sleep for 3 timer ticks and ...
    (microsoft.public.windowsce.platbuilder)
  • Re: question about thread scheduling
    ... I will try what you suggested, the reason that I didn't use the sleep method ... If the NN run in a different thread as the control loop ... Sleepputs your thread to sleep for 3 timer ticks and ...
    (microsoft.public.windowsce.platbuilder)