Sleep or delay

[dhstein]

Is there a command to sleep or wait for a few seconds in VBA before
continuing processing? Thanks for any help on this.

 

[Arvin Meyer [MVP]]

Is there a command to sleep or wait for a few seconds in VBA before
continuing processing? Thanks for any help on this.

There's a sleep api that will work:

http://www.mvps.org/access/api/api0021.htm

but I use this code because it's fair simpler:

http://www.datastrat.com/Code/Delay.txt

 

[dhstein]

Thanks Arvin - I'll try it out.

There's a sleep api that will work:

http://www.mvps.org/access/api/api0021.htm

but I use this code because it's fair simpler:

http://www.datastrat.com/Code/Delay.txt


--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Paul Shapiro]

I use the api instead of a loop. The api puts the thread to sleep so it
doesn't consume any resources. The loop keeps the resources busy while its
not doing anything, or at least it did in older Access versions.