Running Make Table Queries in a Macro

S

Sarah_PubHealth

I created a Macro to open, run then close several different Make Table
Queries. As you might know, when you run a Make Table Query, Access asks "Are
you sure you want to create a new table with the selected records?" Is there
any way to either turn-off this warning or include an action in the Macro to
answer "Yes" to this question when the warning appears? Thanks!
 
R

Roger Carlson

Sure. In your macro, there is a Set Warnings action. Set this to Off to
turn them off before any of you make-table queries run, but BE SURE to add
another Set Warnings action to set them back to On after you are done.
Otherwise ALL warnings will be off until you shutdown and restart the
database.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 

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

Setting column width in a table with a macro is not working 0
Macro to copy table of contents to a new doc 0
Not prompted when running append/make-table queries? 8
Macro for Table of Contents 2
Create a chart from a table in word thats dynamic 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Is It Possible to Control Access Warning Pop-Up Message Boxes? 6
Make Table Queries 2

Top