Display a message while the form is opening

[Lin]

In my main form I have a button to view the report. My issue is to when I hit
the button, it will take some time to pop up the report cause it is a huge
database. Is there any way I can display a message on my screen whily my
report is processing.
any help really appreciated.

thank you

 

[KARL DEWEY]

You can use a form with the Pop Up property set to Yes. The operator will
have to click to close it though.

 

[Kirstie Adam]

How about putting in a message box macro, or bit of code, in the On Open
even of your report?
I have a macro in the On Open event of a large report which just says,
"Please Wait While The Report Loads", and the user has to click OK on the
message box, then the form opens.

Kirstie

 

[OldPro]

In my main form I have a button to view the report. My issue is to when I hit
the button, it will take some time to pop up the report cause it is a huge
database. Is there any way I can display a message on my screen whily my
report is processing.
any help really appreciated.

thank you

I solved this problem by creating a progress form and a progress
function to call it. The form must be .Popup and not .Modal. It
should have a timer and a shape object that gets wider each time the
timer event fires. When the shape reaches the maximum width, reset to
zero. We don't know how long it will take, so this progress bar isn't
an actual indication of progress... just that some process is
happening. Use the Page event of the report to close the Progress
form.