MsgBox Question

[GregSmith]

I can get the MsgBox to pop up and allow you to hit 'ok'.
What I need is the box to pop up as information only. I do not want to have to press the 'ok' button to continue.

What I am trying to do is the following:

I am writing information to a file and want a pop up saying 'please wait' but have the program still run till the file exitsts then continue on.

 

[Cosmos75]

Can you just use a form that opens while the code is running and is close when the code is finished?

 

[Sohaila Taravati]

You have to put a timer on your form and just get rid of the ok button:

Private Sub Form_Timer()
Dim Res
Dim T As Variant
T = Format([Timer] - 1 - Time(), "Short Time")
If T >= "00:01" Then
DoCmd.Quit
End If
End Sub
You also have to specify a time in the timer interval also.

Of course, I am assuming you made your message box with a form