William Benson (VBACreations.Com)
vbacreations at gmail.com
Tue May 24 20:38:28 CDT 2011
You can use the database documenter select all forms, Under Include for Sections and Controls, pick Names and Properties (note if you have named your subforms with Subfrm in the controls' name, you only need to pick Names If you had to pick Names and Properties, then click the Properties button and deselect all but "Other Properties" to make things a little less voluminous. You can export the results to Word (or Excel if you think it will fit -- probably Excel 2007+ will have enough vertical space) Look for Subform/Subreport: [names will appear after these characters] The hard part is keeping track of what Form the control is on... a macro might help -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darrell Burns Sent: Tuesday, May 24, 2011 8:53 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] How do I create list of all forms/subforms I sorta figured it out, although it seems messy... 1. loop thru the Allforms collection, 2. open each form in acDesign and acHidden modes, 3. scan the controls for subforms and grab the names, 4. close each form If there's a more straightforward way, I'm still interested. BTW, thanx for the "Find and Replace" tip. That'll come in handy in some other places. Your other brother, Darrell -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins Sent: Tuesday, May 24, 2011 5:11 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] How do I create list of all forms/subforms ____________________________________________________________________________ ___________ Note: This e-mail is subject to the disclaimer contained at the bottom of this message. ____________________________________________________________________________ ___________ Any chance you can rename them? Or will your client get annoyed at you. If you can rename them then I use and recommend "Find and Replace" by Rick Fisher for this sort of job <<http://www.rickworld.com/>> you can use the free trial version, although I found the paid version paid for itself in about 5 mins flat (is is about $30 USD from memory). ________________________________________ From: accessd-bounces at databaseadvisors.com [accessd-bounces at databaseadvisors.com] On Behalf Of Darrell Burns [dhb at flsi.com] Sent: Wednesday, 25 May 2011 8:18 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] How do I create list of all forms/subforms I do too, but my client wasn't so thoughtful. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Tuesday, May 24, 2011 3:09 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] How do I create list of all forms/subforms That's why I use a naming convention in complex applications that specifically identifies subforms and keeps them together in the forms list :-) frmMain frmMain_subCustomersList frmMain_subCustomerDetails > I want to generate a list of all the forms and their subforms in my > application (whether loaded or not). Right now I'm looping over > Application.CurrentProject.Allforms and getting the name of every > form, but the object doesn't distinguish a subform from a form. I > tried the Type property but they're all Type 2. Is there a routine out > there I can scarf? Thanx, Darrell > > -- > 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 ____________________________________________________________________________ ___________ The information transmitted in this message and its attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information, by persons or entities other than the intended recipient is prohibited. If you have received this in error, please contact the sender and delete this e-mail and associated material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files, with the permission of the sender. This message has been scanned for viruses. ____________________________________________________________________________ ___________ -- 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