Help on macro !

N

Newbie

Folks,
I have a macro wherein I am running a few queries as a part of the whole
processing. Now what happens is, when these queries are running, for a few
seconds, it all shows up on the screen, and finally the outcome shows.
Now I want the user interface to be clean in the manner that it should all
happen in the background, and the user shouldn't know what is happening.
Though I would like to have a progress bar or a message box saying taht it
is in progress, but not teh processing thing.

Any ideas on how to suppress this?
TIA.
 
S

Steve Schapel

Newbie,

Can you please let us know what the actions in your macro are, and what
the queries are doing? I am having difficulty to imagine what is the
meaning of "it all shows up on the screen", and what "the outcome" is.
"Running a query" in a macro would normally refer to an action query
such as an Append or Update query, and there is normally no screen
display at all when they are being processed.
 
Top