display message while processing

[LucasH]

Hi guys,

Quick question. How do I display a form/messagebox while some calculations and functions are being done by the database? I would then close it when the calulations are completed.

I know how to open and close a form, and I have set the first step of my autoexec function to open a form with a label saying "pleast wait..." etc, then the function begins its routine. However what happens is that I see my "please wait" form displayed, but it's like it doesn't finish displaying the form, I just see the outline of it as the processing is being done. Am I missing something?

Thanks.

 

[PHV]

Call the DoEvents function sometimes in your code.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[RoyVidar]

As PHV suggests, after opening the form, issue a

DoEvents

It comes with a cost, though, here are a couple of references

http://support.microsoft.com/kb/118468,

http://en.allexperts.com/q/Visual-Basic-1048/DoEvents-Function.htm,

http://www.a1vbcode.com/vbtip-48.asp

Roy-Vidar