Quick Find: Search for:
Free Resources
from FMS
 

Demos

Email Newsletter

Technical Papers

Tips and Techniques

Links

Book Recommendations

View all FMS products for Microsoft AccessMicrosoft Access Resource Center

 

 

"Thank you! Thank you!
I just finished reading this
document, which was part of a link in the recent Buzz newsletter. I have printed it for others to read, especially those skeptical on the powers of Access and its capabilities.
" 
- Darren D.
 
  

 

Easily Delete Many Objects at One Time

Provided by: Luke Chung, President of FMS, Inc.

By default, Microsoft Access prompts you each time you manually delete an object from the database container or navigation pane. This confirmation is helpful to avoid accidental deletions of an object, but is a pain if you need to delete many objects. It'd be much nicer to simply press the Delete key on each object until all the objects you need to delete are gone.

Fortunately, it's easy to eliminate the confirmation prompt by temporarily turning off warning messages. Just open the Immediate Window (Ctrl G) and enter this:

DoCmd.SetWarnings False

Now you'll be able to delete your objects without a warning message each time. When you're done, be sure to turn warnings back on:

DoCmd.SetWarnings True

Good luck!

Return to the tips page.

Questions  l   Web questions: Webmaster   l   Copyright © 2008 FMS, Inc.

Celebrating 21 Years of Software Excellence