Run Query without confirmation

Q

Question Boy

I never know where to ask this type of quesion (Excel or Access).

I need to be able to run a make-table query from within an excel workbook
and no prompt the user for confirmation. Click the button in Excel and
Access simply run the query updating the data.

How can I do this using late binding?

Thank you for your guidance,

QB
 
P

Paolo

HI QB,

to switch off the access messages use
docmd.setwarnings false
and to switch on again use
docmd.setwarnings true

HTH Paolo
 
Top