prevent datasheet from opening in an Openquery marco

[tgleghorn58]

I have multiple OpenQuery actions in a macro. I have SetWarning = no, however the datasheets are staying opened. I just want the queries to run without the user having so close each one.

I have attached a snapshot of the macro.

 

[Minty]

Unless they are action queries (Update, Append or Delete) then opening them will do exactly that - open them to look at. If they are only Select or CrossTab queries they don't really do anything when they are "Run"

 

[tgleghorn58]

even the select and crosstab queries are opening

 

[Minty]

even the select and crosstab queries are opening

Exactly - they will, they aren't action queries.

 

[tgleghorn58]

Got it... The best thing probably is to write vba for this.

thank you for help

 

[gandhawk]

How about adding a close query(s) command before you exit the macro

 

[tgleghorn58]

there is no close query command. I will just have to do an event procedure to run the queries.

 

[gandhawk]

Use the macro command "Closewindow" command. Then you name the query