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

William Benson (VBACreations.Com) vbacreations at gmail.com
Wed May 25 15:01:00 CDT 2011


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




More information about the AccessD mailing list