status text box

[Tony]

Hello,

Does anyone know how to add a text box to a form to show
the status of an event (i.e. Macro). I have a macro that
runs several queries pulling data from Oracle 11i and
takes an estimated 20 to 30 minutes to run. I think it
would be nice (for the user) to show a text box of what
query is being run. Kind of like an estimated time left.
If this can be done, I understand it would involve a
little VB.

Thanks Much!

Tony

 

[Allen Browne]

Use SetValue to assign some text to the form.
You may need to use RepaintObject to get it to show, since Access considers
running your macro to be more important than updating the screen.