Getting rid of popup messages with make-tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am running a macro that runs several make-table queries. Is there a way to
get rid of the all of the yes/no messages that pop-up? For example: "You are
about to run a make-table that will modify data in your table, Are you sure
you want to run this type of action query?" There are several of those that
pop-up, and the answer is always yes. Is there a macro command or anything
else I can run that will stop those? Thanks!
 
DoCmd.SetWarnings False

This will prevent those pop up messages, and basically take the action
that would happen if the user clicks yes. After running the macro, add
DoCmd.SetWarnings True, so the messages will happen again normally
 

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

Running Make Table Queries in a Macro 2
Create Table Auto Answer 2
Macros 2
Make Table Queries 2
Is It Possible to Control Access Warning Pop-Up Message Boxes? 6
Search access Macros, Forms and VBA code for a specific table references 2
Get Rid of Relationship Among "ID" fields 3
Make Table query. 2

Back
Top