Within Access version 7....
I have a VBA sub that does many things. At one point I use shell() to invoke an external application which copies a file from the PC to a unix box. After shell(), I use Sendkeys() to fill in the remote copy application's dialog box. When using Sendkeys I turn the wait flag = True.
Upon completion of the remote copy the VBA routine continues on doing other things.
The Problem: The copy takes so long that Sendkeys() wait stops waiting and flow of execution continues while the copy is still in progress. This screws up everything because subsequent keystrokes no longer are in synch with the place they are supposed to be entered.
The Question: Anyway for me to set/change the duration of the Sendkeys wait flag. Any other timer that I should set/change to ensure that my processing stays sequential. Any other ideas?