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]

Re: Removing Multiple objects

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" <mar10a@yahoo.c om> wrote in message
news:f338d997.0 412051552.50512 94f@posting.goo gle.com...[color=blue]
> 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?[/color]

[Jack MacDonald]

Re: Removing Multiple objects

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.setwarnin gs 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.SetWarnin gs true

HTH


On 5 Dec 2004 15:52:28 -0800, mar10a@yahoo.co m (mar10a) wrote:
[color=blue]
>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?[/color]


*************** *******
jackmacMACdonal d@telusTELUS.ne t
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

[Bas Cost Budde]

Re: Removing Multiple objects

Jack MacDonald wrote:[color=blue]
> 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.setwarnin gs false <enter>[/color]

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]

Re: Removing Multiple objects

Bas Cost Budde wrote:[color=blue]
> Jack MacDonald wrote:
>[color=green]
>> 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.setwarnin gs false <enter>[/color]
>
>
> 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 ;-) )[/color]

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]

Re: Removing Multiple objects

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" <jackMACmacdona ld@telus.net> wrote in message
news:9mk7r0dtjm nm51ngstilfl2ls m7g46bkja@4ax.c om...[color=blue]
> 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.setwarnin gs 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.SetWarnin gs true
>
> HTH
>
>
> On 5 Dec 2004 15:52:28 -0800, mar10a@yahoo.co m (mar10a) wrote:
>[color=green]
> >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?[/color]
>
>
> *************** *******
> jackmacMACdonal d@telusTELUS.ne t
> remove uppercase letters for true email
> http://www.geocities.com/jacksonmacd/ for info on MS Access security[/color]