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
 

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

Run Make-table query 1
turning off action queries 3
ADODB from Excel - Running a Query 1
Informing user of a process running using MsgBox 3
2501 The OpenQuery action was canceled. 0
Excel Protection 2
Record insert/delete anomaly 0
Counting multiple memberships 1

Back
Top