Run Query without confirmation

  • Thread starter Thread starter Question Boy
  • Start date Start date
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
 
HI QB,

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

HTH Paolo
 
Back
Top