How to put the condition in Macro ?

[Dawn]

I’ve finished a Marco with only the operation “openqueryâ€,
There are two kinds of queries in the Macro.
One is the make-table queries, the other is modify-table queries(for
example: function:â€alter†or “upgrade†)
For the first queries , they need to put in parameter before running.
For the other queries, there is warning msgbox pop-up before running.
My question is ,
1:How to enter the parameter in the macro?
2:How to automatic enter an “Enter†to respond to the warning msgbox.
If the 2 points are realized, the macro is absolutely automatic, not like
semi- automatic for present.
Thanks
Dawn

 

[Steve Schapel]

Dawn,

If you put a SetWarnings/No action at the beginning of the macro, this
will take care of the pop-up action query confirmation prompts.

As for the "parameter", can you give a specific example of what you are
talking about? I suppose you men a Criteria that is entered at the time
that the macro is run... is that right? Ideally this is referenced by
putting an unbound textbox on a form, where the user will enter the
criteria before the macro is run, and then the query references the textbox.