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

Darrell Burns dhb at flsi.com
Thu May 26 14:34:47 CDT 2011


John,
Are your JIT subforms pre-bound to a table or query, or do you create the
recordsource on the fly?
DB

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Thursday, May 26, 2011 3:09 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] How do I create list of all forms/subforms

In any event, as I mentioned, it is possible to bind subforms into subform
controls at runtime.  I 
call it Just In Time subforms.  The subform control is there but that
control does not have a 
subform bound in it.  In fact once common technique is to bind different
subforms into the same 
subform control.  This is done all the time in Microsoft's wizards.  The
upshot is that the 
documentor does not know that a subform is a subform, nor will the loop pick
these up.

I use JIT subforms extensively to speed up loading of complex forms.

John W. Colby
www.ColbyConsulting.com

On 5/25/2011 4:01 PM, William Benson (VBACreations.Com) wrote:
> 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
>
-- 
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