How to remove OK buttons during query

  • Thread starter Thread starter test guy
  • Start date Start date
T

test guy

Can someone point me to a tutorial on how to remove the confirmation
dialogues (OK buttons) that might occur when a query is running.. I want
them to all default so I don't see them..
 
You can turn them off in Tools | Options menu.

However, just remember that they won't turn back on unless you manually turn
them back on.
 
Either DoCmd.SetWarnings False before you run the query (and
DoCmd.SetWarnings True after), or else use the .Execute method of either the
database or QueryDef object.
 
You must log in or register to reply here.

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

How to remove stuff that appears when I click on the windows button on the bottom left of my screen? 2
Run Macro if Query is Not Null 4
Run 2nd query using results from 1st query 0
Generate reports directly to Email 3
Update/Append Queries minus confirmation Dialouge 3
Adding a "re-run" button to an Access 2007 ribbon 3
Action Queries 3
Computer Nooby , advice needed. 1

Back
Top