I have a make-table query which prompts me that "the existing table will be deleted before I run this query. Do I wish to continue anyways y/n?"<br><br>Anybody have any idea for how to remove that msgbox from coming up?<br><br>I already have removed the msgbox that "I will run a make table query that will modify my tabular data yada yada yada" this was done through the drop down TOOLS->OPTIONS->EDIT/FIND Tab then clicking off confirm Action Queries.<br><br>Any help would be appreciated.<br><br>Thanks<br>Eric<br>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Remove Confirmation Box from Make Table Query 2
- Thread starter efinnen
- Start date
Guest_imported
New member
- Jan 1, 1970
- 0
The following example turns the display of system messages off:<br><br>DoCmd.SetWarnings False
- Thread starter
- #3
-
2
- #4
after the query is run you may want to turn the warnings back on so that you can't accidentally delete anything else.<br>i'm speaking from experience on that one. <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>
Guest_imported
New member
- Jan 1, 1970
- 0
You are correct on that last statement famousb. Any thoughts of a FAQ for this often asked question.
- Status
Similar threads
- Locked
- Question
- Locked
- Question