working - message box

[VilMarci]

Hi,

I have a backend database on the network with a lot of temp tables, and
combined queries.
How is it possible to display a "working, please wait"-like box and remove
it when the work is finished?
I don't want percent counter (but if possible, would be good , just like
this

Sub Work()
Display "working box"
build tables, call the queries etc..
Remove box
End sub

No, creating a box and showing/hiding on the form is not a good idea,
because I've subforms and controls... not good...

Any ideas welcome,

Thanks in advance,
Marton

 

[Steve Schapel]

Marton,

I could not understand why you don't want to use a label on the form.
This is a good idea, and would normally be a workable solution.

Another approach is to make a simple little unbound form for the
purpose, with your 'please wait' message, and open the form at the
beginning of your macro and close it at the end. Except I see you are
not using a macro, you are using a VBA procedure, but the same idea applies.