minimize/hide query windows

[john.tseven]

Hi all

I run ~200 queries which modify the data, create some tables etc,
through a macro. The macro runs when the user clicks a button on a
form. I would like the queries to be invisible while they are running;
but currently the user sees 50+ query windows open/close which is
ugly.

Is there a way to automatically minimize/hide query windows or disable
screen update? I know this is possible in Excel by setting
application.screenupdating =false, is there a similar way in Access?

Thanks,
jon

 

[Guest]

Jon,

Let me get this clear. You don't want the queries to be shown. That
implicates that you are refering to select queries. Those are meant to be
seen and thus have no meaning in hiding.

For the actionqueries you'll only get a messgabox with a statement telling
you it is about to....

if it's the messageboxes you are reffering to then look for the option
Warnings in the macro. They can be set to true or false

if this is not what you meant please give me a sample of a query statement
so we can look into it more...

Maurice