[AccessD] Delete all reports and all forms

Max Wanadoo max.wanadoo at gmail.com
Wed Mar 17 12:39:03 CDT 2010


Thanks - will do

Max
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Wednesday, March 17, 2010 5:27 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Delete all reports and all forms

Use the ADODB.Catalog container.

Charlotte 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Wednesday, March 17, 2010 10:21 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Delete all reports and all forms


Aha, no I havent tried that  Charlotte. Good  pointer.

Am wrapped  up in something  else at mo,  but will try later.

Many thanks

Max
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Wednesday, March 17, 2010 5:15 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Delete all reports and all forms

Have you tried ADO?  I used to have code for this on my old machines but
I've lost track of it in upgrades.

Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Wednesday, March 17, 2010 10:13 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Delete all reports and all forms


Nope,

Access wont let you delete from the forms or reports collection.

Wonder if going through the mysys tables might do it....hmm

Ma
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Wednesday, March 17, 2010 5:07 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Delete all reports and all forms

In DAO, it should be pretty simple.  Just refer to the forms or reports
collection, start from the highest index in the collection and call delete.
You have to work backwards to loop through all of them

Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Wednesday, March 17, 2010 9:28 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Delete all reports and all forms


Anybody know how to loop through and delete all reports and all forms.

It seems that Access will not let you delete from the collections.

Must be a programmable way but never done it before.

Max


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list