Dont show query in macro

[rustyg]

Hi,

I am using the "open query" command for some queries I want to run as part of my macro, The problem is I dont really want to "open" the queies, just run them without displaying the data on the screen. Is there a way I can run them without displaying them? maybe I need to use a different command in my query?


Russ

 

[seth_belgium]

The queries you open in a macro wil not be visible when they are "action"-queries (like deletequeries, addqueries, etc...).

The only type of query that will result in a recordset is the selectionquery, so as long as your queries aren't selection-queries, you're good with this method.

If you want to avoid the warnings and confirmation-popups, you can add the command "Show Messages" before and after the Open Query-commands. In the first one, you set the value on False, in the last one, you set the value on True again.

Good luck!

 

[rustyg]

Cheers Mate,

All its all fixed up, I have a couple of selectqueries but I just close them with the close command after they have run.

Russ