When a macro runs a qry that makes a table How can I have it answ.

A

AccessGrl

When a macro runs a qry that is making a table, how can I have the macro
answer yes to the make table questions automatically?
 
N

Nikos Yannacopoulos

Precede the OpenQuery action with a SetWarnings one with argument No.

It is not necessary to add a SetWarnings / Yes afterwards, as Access
will do so automatically when the macro execution is over; it's good
practice though, so you get its code equivalent if you conver the macro
to code at some point, as warnings are NOT reset in code!

HTH,
Nikos
 
M

MikeC

Within the macro, add, prior to the action which creates the table, insert
the SetWarning and ensure select No from the Warnings On box at the bottom
MikeC
 
Top