"shell" in access should give option to run synchronously

[Mr.Roy]

"Shell" (Access 2003) gives only indication that the spawned command was
invoked. And return is immediate. So, you have to "doevents" until
who-knows-when, rather than simply wait on the completion of the child
process. This is stone-age!

 

[Dirk Goldgar]

"Shell" (Access 2003) gives only indication that the spawned command
was invoked. And return is immediate. So, you have to "doevents" until
who-knows-when, rather than simply wait on the completion of the child
process. This is stone-age!

That's the way the VB Shell function works. But you can do what you
want by using the ShellWait function posted here:

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