[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.
> ____________________________________________________________________________
> ___________
>