MsgBox Variation

[linanderson]

I have one form which takes some time to open. I did place a MsgBox "Please wait while the records open" in the OnClick to open the form. This does require the user to press OK from the message box before the sequence can continue an open the form.

I was wondering if there was a way of have a message box type form without the 'OK' and for the form to only remain open for only 10 seconds and then close.

I have experienmented with an un-bound form which has a label "Please wait while the records open" and then OnOpen opens the main client form. This un-bound form does remain open however. I cannot get anything to work at the moment.

It sounds so simple. Is there a better way of looking at this?

 

[ColinEssex]

There was a post last week about "pausing" code in order to allow something else to happen.

If you had some code that opened the "Please Wait" form then paused it while it opened the "slow" form then when the "slow" form is opened the "Please Wait" form closes.

Have a search for "pause" or "Pausing code" and see how you get on. Post back if you have a prob.

Meanwhile someone else may have a solution at their fingertips.

Col

 

[Jerry Stoner]

Use the unbound form you made and close it from the timer event.

 

[Oldsoftboss]

Use
DoCmd.Close acForm, "YourPopUpFormName"
on the timer event of the slow form as Jerry suggests. Can't see why this wont work, but we are dealing with a computer remember!!