Message Box

[MarkS]

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

[Dirk Goldgar]

In news:B9FAC4A3-3B63-4A9E...@microsoft.com,

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.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)