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

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?
 
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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

setting the argument in SETVALUE Action of macro 6
Run Macro If Cell have "x" value 0
Run Macros to update data 4
Combine and Insert query 7
"table already exists" 5
Macro with make table 1
Export table to txt file with a variable filename 0
Compact & Repair, Open table, close table, then run macro 3

Top