Prompts

[Kenster]

I see that SetWarnings will accept the default i.e.
Yes 'prompt' - but say on one particular query in the
macro that I wish to select the No prompt.

 

[Steve Schapel]

Kenster,

Technically, you will need to add a SetWarnings,Yes action to the macro
ahead of the OpenQuery action for the query that you don't want to
proceed. But, this is so wierd! Why do you want your macro to try to
run a query and then you are going to abort it? Why not just remove the
action for this query from the macro?