Message Box to Appear While Calculating

frankbutcher

Registered User.
Local time
Today, 08:53
Joined
Aug 6, 2004
Messages
192
Hi.
I have a form that takes a while to load, as it is based on a SQL ODBC link, and it has a calulation on the form.

The form loads and appears on the screen, and "calculating......" appears in the bottom left of the screen. While this is taking place, nothing can be done until it has finished.

Is it possible to have a message box or another form to pop up while it is calulating (saying "please wait....calculating") and then dissapear when it has finished?

Many Thanks.

Frank.
 
The easiest way is to use the hourglass method to turn your mouse cursor to the hourglass (egg timer).
 
You can also open your "Please Wait..." form first and open the other form hidden and then close the first form and set the second form visible when you have control in the second form.
 
I like that idea, will give that a go.
Many thanks for your replies.
Frank.
 
Your ideas r good, but in my case i would need som info form with text "query is running, wait pls....."

this code, is not working very well cos it appears after a few sec .. when query is running....
DoCmd.OpenForm "nazov_form"
Forms![nazov_form].Visible = False
..
DoCmd.runmacro "xxx"

Forms![nazov_form].Visible = True

i would need some solution.. where form is loaded in memory before action runquery and i only switch between show/hide this form.
Could somebody help me ?
 
Get all of your forms in the state you want them *before* running your macro. Do some DoEvents to give Access some computer time to get the form displayed.
 

Users who are viewing this thread

Back
Top Bottom