Controlling Call Execution

[toccata]

The following code calls the Crystal Report Engine:

stAppName = "C:\WinTBM\rptProcReg.exe"

Call Shell(stAppName, 1)

Response = MsgBox("Do you want to update the Procedure Register?", vbQuestion + vbYesNo + vbDefaultButton2 + vbMsgBoxSetForeground, "The Bloodstock Manager&quot

If Response = vbYes Then

UpdateProc

Response = MsgBox("Procedure Register Updated", vbOKOnly, "The Bloodstock Manager&quot
End If

My problem is the msgbox "Do you want to update...." appears before the called report has run and terminated. I want to enforce that the report is run and the msgbox does not appear until the .exe has terminated.

 

[KenReay]

Hi

As far as I know there is no way to do this with shell, from Access help, I quote:

"Note The Shell function runs other programs asynchronously. This means that a program started with Shell might not finish executing before the statements following the Shell function are executed."

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[RoyVidar]

Hi!

Found something that might offer a different solution than the shell at the end of this thread thread705-667547

HTH Roy-Vidar