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

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
>



More information about the AccessD mailing list