[AccessD] Delete all reports and all forms

Charlotte Foust cfoust at infostatsystems.com
Wed Mar 17 12:14:34 CDT 2010


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




More information about the AccessD mailing list