Run querries with macro

[AndreasM]

I would like to create a macro to run three querries together. But i dont
want the user to see the results of the querries so I don`t want to use the
OpenQuerry macro. So how i create this macro?

 

[Steve Schapel]

Andreas,

I assume you are referring to action queries (Apend, Update, etc).
Normally the user would not see the "results of the queries" if you use
the OpenQuery action in a macro. Unless you mean the action query
confirmation messages, in which case this is taken care of by placing a
SetWarnings/No ction in the macro before the first OpenQuery.

Please post back with some more information and examples if you still
need further help with this.

 

[AndreasM]

In action Querry, of course, i havent problem. I have three select queries, i
have insert SetWarning(NO), OpenQuery, SetWernings(NO), Open Query,
SetWarning(NO), OpenQuery, SetWarning(NO), but when i run this macro i see
the resultof these three select queries...That`s i dont want to happen and
the setwarning doesnt to seem to do something

 

[Steve Schapel]

Andreas,

If you are running action queries in a macro, is is only necessary to
put one SetWarnings/No action before the first OpenQuery action, not one
for each OpenQuery action.

I can't think of any situation where anything is achieved by "running" a
Select Query in a macro. Yes, opening a select query like this will
mean you will see the query datasheet, but... What is your purpose in
opening a select query, I can't see how it can do anything?

 

[AndreasM]

The results of the query is the result of some function which i use to make
a final list and the user must not see these results.

 

[Steve Schapel]

Andreas,

Thanks. I still can't understand, though, what you hope to achieve by
opening a query datasheet... it doesn't actually *do* anything. If you
need more help with this, please post the SQL of the query, and try to
explain what is supposed to hapopen as a result of opening the query.