Removing Multiple objects

[mar10a]

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?

[Douglas J. Steele]

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?

[Jack MacDonald]

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

[Bas Cost Budde]

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

[Trevor Best]

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

[Douglas J. Steele]

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