[AccessD] How do I create list of all forms/subforms

>>" 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