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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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
 
Back
Top