Delay or sleep function?
Posted on 2000-03-23
What is the best way to pause in Access VBA? There are two goals here.
1. Sleep for x seconds (without hogging the resources). [30 pts]
2. Use the Shell command to do a task such as copy a large file and do nothing until that finishes. [70 pts]
I have the problem of my program using a copy before DOS actually finishes the copy process. I can wait 10 seconds if necessary but would rather just wait until it finishes before going on just in case the computer is a slow one or to take advantage of it finishing more quickly.
Full points to good answers to #1 and #2, partial points to just one or the other.