lightcomputers
asked on
VBA Code to make a procudure stop/pause/wait for X number of seconds
I know this has been asked before, but i'm pulling my hair out trying to find a solution.
I just need a peice of code that i can insert half way into a procedure that will cause the procedure to pause for a second or so.
Using just Standard Access 2000
Thanks in advance!
I just need a peice of code that i can insert half way into a procedure that will cause the procedure to pause for a second or so.
Using just Standard Access 2000
Thanks in advance!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Why isn't it what you are looking for?
ASKER
I dont really need a timer in there - that will just complicate things
Sorry, I don't follow you. If you want your code to wait for, say, 5 seconds, you just call the sSleep sub with:
sSleep 5000
sSleep 5000
ASKER
Errrm - ok, you win!
ASKER