I have a bunch of queries that run in a macro, which can take hours,
sometimes, to run.

Is there any way I can have the name of the currently running query be
displayed somewhere on the screen (maybe in status bar or somewhere
else)?

TIA

Pete

"hedrew3" <peteg (AT) garlic (DOT) com> wrote

Here's one way:
Just before running the query, open a small form displaying the name of the
query you're about to run. If your macro closes the query, have it close
the little display form immediately after, and then open another little
display form before starting the next query.

You could even have the form display the time that the query began, by
having an unbound textbox with Control Source set to Now(), which will plug
in the current time when the form is opened.

Bruce Pic

"hedrew3" <peteg (AT) garlic (DOT) com> wrote