Max Wanadoo
max.wanadoo at gmail.com
Wed Mar 17 12:21:23 CDT 2010
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