Deleting more than one report or Query at once

S

Sunny_999

In excel or word it is possible to delete a number of items at onceby using
the folders. We are about to undertake a large deletion process as we have
progressed to a more efficient way of working. Rather than have to delete
each one is there a way of doing a similar sort of thing through access . I
tried holding the Control key down but that did not appear to work.
I would really appreciate any advice on this.
Many Thanks
 
M

MacDermott

AFAIK, there is no way to do this from the keyboard.
You can go into Tools - Options and turn off the warnings, so you don't get
the prompt every time, but I'd suggest you turn that back on when you're
through.
If the items to be deleted all have something in common in their names,
which none of those being kept have, you could write code to loop through
and delete only the ones which match the criteria - but even that might not
be worth it for a single time.

Be sure you make a backup before you start your deletions (it's too easy to
delete too much), and then compact your database when you're finished.

HTH
 
D

Douglas J. Steele

If you'd prefer not changing the option to turn off warnings, simply hold
down the Shift key as you're deleting.
 
S

Sunny_999

I have tried holding the shift key down but that does not let me delete more
than one report or query at once.
 
D

Douglas J. Steele

I didn't say it would. All I was saying is that if you hold the shift key
down while you're deleting, you won't get the "Do you really want to delete
this?" prompt, making it a bit faster to delete them one at a time.
 
Top