Stop code until other application finished (1 Viewer)

[Mister-B]

I have finally gotten my code to work. From my form I create an outlook appointment from data on the form and send it to recipients that are also on the form. After generation the appointment is displayed in Outlook and I check for errors or may add notes manually. After all is OK I send the appointment manually by clicking the send button. While I am checking the appointment, the original code on my access form is continuing to run. Is there any way to make it stop or pause until i have actually sent the appointment?

 

[theDBguy]

Depending on what the rest of the code is doing, you may be able to make the code wait.

 

[Isaac]

You could simply raise a MsgBox with text "Click OK when displayed Calendar item is sent"
Add it after your .Display line of code for Outlook item

 

[Mister-B]

You could simply raise a MsgBox with text "Click OK when displayed Calendar item is sent"
Add it after your .Display line of code for Outlook item

Actually that is actually what I am doing, but the message appears before I have finished tending to Outlook.

 

[NauticalGent]

Can you post your complete code so we can see what's goin on? From what you are describing, there may be a couple of options.

 

[Isaac]

Actually that is actually what I am doing, but the message appears before I have finished tending to Outlook.

Yeah, that's what is supposed to happen.
You don't click OK until you're finished sending outlook.
The advantage here is a MsgBox is modal