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 in Microsoft Access
Provided by: Luke Chung, President of FMS, Inc.
Selecting Multiples Objects in Microsoft Access 2007
One of the nice features in Microsoft Access 2007's
Navigation Pane (the replacement for the database container) is the
ability to select multiple objects. This can be done by selecting a
range of objects of different types, via the Shift + Mouse Click, or
individual objects via the Ctrl + Mouse Click. One can then press the
Delete key to delete them
Deleting Multiples Objects in Microsoft Access 2003 and
Earlier
For earlier versions of Microsoft Access, it's not so
simple. By default, Access prompts you each time you manually delete an
object from the database container. 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
|
|
