William Benson (VBACreations.Com)
vbacreations at gmail.com
Wed May 25 15:01:00 CDT 2011
John, Hope this is clear ... I don't do this very much. Just saying it is possible ... and certainly I would use the loop method mentioned already, with Allforms - so this was just me describing an alternative The result of the database documentor can be exported to a Word or an Excel file and if you use Excel or Word automation you can read that file and get the details you want. I am not recommending one way over the other (well if I were to recommend one, it would be Allforms lol) Bill -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Wednesday, May 25, 2011 12:54 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] How do I create list of all forms/subforms Bill, Did I miss something? Why are you doing it in Excel or Word? I thought this was regarding subforms in Access. What in the heck is the doc/xls? John W. Colby www.ColbyConsulting.com On 5/25/2011 10:32 AM, William Benson (VBACreations.Com) wrote: >>> " probably the only way to do it" > Jon, with all due respect, I posted another way. It is very easy to > write a once-and-for-all macro in Excel or Word to loop through lines > in the output doc/xls and make a listing of subform controls... > > Bill > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby > Sent: Wednesday, May 25, 2011 9:22 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] How do I create list of all forms/subforms > > That's probably the only way to do it. Any form could be a subform. > > Unfortunately even this won't work if you use Just-In-Time subforms > since the subforms aren't bound until runtime. > > John W. Colby > www.ColbyConsulting.com > > On 5/24/2011 8:53 PM, Darrell Burns wrote: >> 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