stop popup or screen update activity

[Guest]

during a macro run which automatically runs and saves data out to excel
I've turned SetWarnings off during the run
how do I suppress the query window from popping up?
i'd like it to run in background without the screen rendering overhead, etc.

a small temporal messagebox indicating the process is running would be nice

 

[Steve Schapel]

Jim,

Not able to answer your question without knowing more details of what
you are doing. Can you please give the Actions and relevant Arguments
in your macro?

 

[Guest]

most relevent is the output query to an .xls file
the query takes a bit to run and causes a query window to pop-up while
generating the data to be output.

I'd prefer the intermediate query window to (run in background) not pop-up
and possibly a informative msgbox (non-interactive) to pop-up instead
explaining that the query is running - the msgbox to automatically disappear
once the query/output completes

 

[Steve Schapel]

Jim,

What I meant was, what are the Actions you are using in your macro?

Now, reading between the lines, it sounds like you may have an OpenQuery
action, applying to a Select Query. Is that right? If so, you have
probably misinterpreted the meaning of this action, you probably don't
need it, and could probably simply remove it from your macro in order to
solve the problem.

 

[Guest]

HourGlass On Yes
SetWarnings WarningsOn No
Output to (Select Query to .xls Output File)
Beep
SetWarnings WarningsOn Yes
HourGlass On No

 

[Steve Schapel]

I'm sorry, Jim, I can't see anything in that macro that would cause a
query datasheet to open. It's a mystery.