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

Darryl Collins Darryl.Collins at iag.com.au
Tue May 24 19:10:39 CDT 2011


_______________________________________________________________________________________

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.
_______________________________________________________________________________________




More information about the AccessD mailing list