A
Albert D. Kallal
JimP said:I have a lengthy append query that runs when WindowHide is set to yes. The
problem is that users have no way of knowing that the query is running
because the status bar is not displayed.
How can I force a form to open before the query runs and then close when
it finishes without user interaction?
1. Simply opening the form before the query runs, partially loads the form
while the query runs.
Just open the form, but place a doevents right after.
Eg:
docmd.OpenForm "MyPleaseWaitMessageForm"
doevents
run long query here....
docmd.Close "MyPleaseWaitmessageForm",acForm
msgbox "done"