Pop-up form to stay on top of other forms while executing VBA code

[evander]

Hi guys!



I'm back again. I wanna ask for some help.

Question: How do I create a pop-up form that stays on top of other forms, or even on top of Microsoft Access (similar to a message box) so that Access freely executes some VBA code, and the user is prevented from accidentally halting its execution?

For example:

Private Sub AppendDatatoTemporaryTable
   DoCmd.OpenQuery.... 'To clear temporary table of any existing rows of data

   DoCmd.OpenQuery.... 'To append sales data
   DoCmd.OpenQuery.... 'To append purchases data
   DoCmd.OpenQuery.... 'To append collection data
   DoCmd.OpenQuery.... 'To append disbursement data
End Sub

While the above code executes, I want a form to appear. What properties can I set to achieve this form behavior. I can't use a message box for this task because a message box pauses a code execution.

Thanks guys! Glad I found this site months ago.

JAN(JOE)

[RuralGuy]

On the Other tab of the property sheet set PopUp *and* Modal to TRUE.

[evander]

RuralGuy, thanks a lot!

[RuralGuy]

Any time. Glad we could help.