Pause

[Chris]

Hello

I want to make a pause during the execution of my code
for at least 10 minutes to let the user make changes
after the 10 minutes the code will continue to execute in
a file can I do it in VBA

thanks for your help

 

[Rowland]

yes you can pause the code, one way to pause the code ist
to use the API sleep function. Here is the website that
will show you how to do that.

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

Rowland

 

[Bob]

Don't know why you would want code to stop executing for 10 minutes. But if
you really do, the previous post should work for you.