Running Make Table Queries in a Macro

  • Thread starter Thread starter Sarah_PubHealth
  • Start date Start date
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!
 
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
 
Back
Top