Message Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a group of querys which run one after the other and some VB code to
get around a timeout issue. As it takes awhile to run I would like to put a
message box on the screen to say where it is up to.

Thanks
 
In
MarkS said:
Hi,
I have a group of querys which run one after the other and some VB
code to get around a timeout issue. As it takes awhile to run I would
like to put a message box on the screen to say where it is up to.
Click to expand...

I'd use a form for this. Have a label or text box on the form that will
display your progress message. Open the form as you begin your process,
update the message (label caption or text box value) on the form as you
go along, and close the form when you're done.

One thing you may need to do, depending on what your code is doing, is
execute the DoEvents statement after you update the message on the form.
You may not have to, but sometimes tight loops can prevent the form from
being redrawn unless you put in a DoEvents.
 
Back
Top