Hide from user the results of select query called from VBA 1

[WantToKnowMore]

I'm calling several stored queries that create temporary files from within VBA using "DoCmd.OpenQuery" calls. One of the queries is a select query.

How can I stop the results of the select query from being displayed to the user?

Thanks in advance!

 

[PHV]

If you don't want to display the results of a select query why launch it ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[WantToKnowMore]

The query is called from within another query that I am using for the desired end result. I just don't want to visibly see the results displayed to the screen.

 

[PHV]

A query called from another query should not be launched by the OpenQuery method as it is automagically executed by the calling query.
Again, don't launch yourself select queries you don't want the result displayed in the query window.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[WantToKnowMore]

You're right, and I know better too. I have a series of queries that I run that are named sequentially... so I just called the name and didn't think anymore about it. I deleted the call and it works fine.

Thanks for the reminder!