prevent datasheet from opening in an Openquery marco

tgleghorn58

Registered User.
Local time
Today, 01:12
Joined
Sep 9, 2014
Messages
26
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.
 

Attachments

  • macro example.JPG
    macro example.JPG
    37.5 KB · Views: 165
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"
 
even the select and crosstab queries are opening
 
Got it... The best thing probably is to write vba for this.

thank you for help
 
How about adding a close query(s) command before you exit the macro
 
there is no close query command. I will just have to do an event procedure to run the queries.
 
Use the macro command "Closewindow" command. Then you name the query
 

Users who are viewing this thread

Back
Top Bottom