Help on macro !

  • Thread starter Thread starter Newbie
  • Start date Start date
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.
 
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.
 
Back
Top