D dhstein Jan 30, 2009 #1 Is there a command to sleep or wait for a few seconds in VBA before continuing processing? Thanks for any help on this.
Is there a command to sleep or wait for a few seconds in VBA before continuing processing? Thanks for any help on this.
A Arvin Meyer [MVP] Jan 30, 2009 #2 dhstein said: Is there a command to sleep or wait for a few seconds in VBA before continuing processing? Thanks for any help on this. Click to expand... 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 said: Is there a command to sleep or wait for a few seconds in VBA before continuing processing? Thanks for any help on this. Click to expand... 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
D dhstein Jan 30, 2009 #3 Thanks Arvin - I'll try it out. Arvin Meyer said: 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 Click to expand...
Thanks Arvin - I'll try it out. Arvin Meyer said: 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 Click to expand...
P Paul Shapiro Jan 30, 2009 #4 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.
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.
