By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,932 Members | 1,454 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,932 IT Pros & Developers. It's quick & easy.

Removing Multiple objects

P: n/a
I have an extensive access database and have about 50 to 60 forms and
50-60 reports I need to remove.

I can't seem to find a way to select all of these at one time to
delete all at once. I've been deleting these one at a time. I hoping
that this is not the only way to do this, does anyone know if more
than one item can be selected to delete?
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Through the graphic interface, you're limited to deleting one object at a
time.

If you've got a list, though, you could quickly cobble together a VBA
program to delete the objects.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"mar10a" <ma****@yahoo.com> wrote in message
news:f3**************************@posting.google.c om...
I have an extensive access database and have about 50 to 60 forms and
50-60 reports I need to remove.

I can't seem to find a way to select all of these at one time to
delete all at once. I've been deleting these one at a time. I hoping
that this is not the only way to do this, does anyone know if more
than one item can be selected to delete?

Nov 13 '05 #2

P: n/a
as Douglas says, it's one at a time.

However, you can turn OFF the confirmation dialog, which will greatly
speed up the process.
Ctrl-G to bring up the Immediate Window
enter docmd.setwarnings false <enter>

be careful that you REALLY want to delete the objects -- you won't get
a second chance.

When you are finished the deletions:
Ctrl-G
Docmd.SetWarnings true

HTH
On 5 Dec 2004 15:52:28 -0800, ma****@yahoo.com (mar10a) wrote:
I have an extensive access database and have about 50 to 60 forms and
50-60 reports I need to remove.

I can't seem to find a way to select all of these at one time to
delete all at once. I've been deleting these one at a time. I hoping
that this is not the only way to do this, does anyone know if more
than one item can be selected to delete?

**********************
ja**************@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
Nov 13 '05 #3

P: n/a
Jack MacDonald wrote:
as Douglas says, it's one at a time.

However, you can turn OFF the confirmation dialog, which will greatly
speed up the process.
Ctrl-G to bring up the Immediate Window
enter docmd.setwarnings false <enter>


SetWarnings? I wasn't aware of that suppressing deletion of documents.
Usually I set this from Tools->Options, under Edit, those three ticks
(and, to be honest, while I work the confirmation for document deletions
stays on, I've killed two hours work of queries so far ;-) )
--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea
Nov 13 '05 #4

P: n/a
Bas Cost Budde wrote:
Jack MacDonald wrote:
as Douglas says, it's one at a time.

However, you can turn OFF the confirmation dialog, which will greatly
speed up the process.
Ctrl-G to bring up the Immediate Window
enter docmd.setwarnings false <enter>

SetWarnings? I wasn't aware of that suppressing deletion of documents.
Usually I set this from Tools->Options, under Edit, those three ticks
(and, to be honest, while I work the confirmation for document deletions
stays on, I've killed two hours work of queries so far ;-) )


It can be a bad thing too if left off so make sure you turn it back on
when you've finished.

--
This sig left intentionally blank
Nov 13 '05 #5

P: n/a
Holding down the shift key while you delete also suppresses the warning.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Jack MacDonald" <ja**************@telus.net> wrote in message
news:9m********************************@4ax.com...
as Douglas says, it's one at a time.

However, you can turn OFF the confirmation dialog, which will greatly
speed up the process.
Ctrl-G to bring up the Immediate Window
enter docmd.setwarnings false <enter>

be careful that you REALLY want to delete the objects -- you won't get
a second chance.

When you are finished the deletions:
Ctrl-G
Docmd.SetWarnings true

HTH
On 5 Dec 2004 15:52:28 -0800, ma****@yahoo.com (mar10a) wrote:
I have an extensive access database and have about 50 to 60 forms and
50-60 reports I need to remove.

I can't seem to find a way to select all of these at one time to
delete all at once. I've been deleting these one at a time. I hoping
that this is not the only way to do this, does anyone know if more
than one item can be selected to delete?

**********************
ja**************@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.