jwcolby
jwcolby at colbyconsulting.com
Wed May 25 11:54:13 CDT 2011
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 >