Link to home
Start Free TrialLog in
Avatar of lightcomputers
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!
ASKER CERTIFIED SOLUTION
Avatar of shanesuebsahakarn
shanesuebsahakarn
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of lightcomputers
lightcomputers

ASKER

Not really what i'm looking for - any more ideas??
Why isn't it what you are looking for?
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
Errrm - ok, you win!