Display form during process

  • Thread starter Thread starter Don Pickering
  • Start date Start date
D

Don Pickering

Am running Access 2000.
I have a long update process. I want to display some message stating an
update is in process.
I tried using a form but all Access processing seems to stop when a form is
displayed. (The form was not modal).
How do I get a message to prominently display without stopping the update
process?
 
Don,

That shouldn't happen. I have a small non-modal dialog I use for keeping the
user distracted during short processes. I call it dlgWorking, and all it has
on it is a Label, whose caption reads "Working. Please wait...". I open the
form before I start the long process, and close it when it's finished.

I have another one I use for longer processes, but it has animations on it,
and I open it as an object so I can pass progress data to it.

Your custom dialog should not be modal, and should have no code in it at
all. Make sure to open the dialog BEFORE starting the long process, and
close it soon after.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html
 
Back
Top