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

Stuart McLachlan stuart at lexacorp.com.pg
Tue May 24 20:47:14 CDT 2011


I gave up on shared subforms a long time ago - had too many situations where new 
requirements meant that the same sub-form no longer worked on both master forms. 

Like you , I try to keep event procedures down to simple function calls with all the grunt work 
done in standard modules.

-- 
Stuart


On 24 May 2011 at 21:23, William Benson (VBACreations. wrote:

> Works fine if ... you don't share subforms between multiple forms. I
> suppose you could always just duplicate the subforms, but I find
> keeping the code synchronized between multiple copies a mild hazard. 
> 
> Of course lately I have been calling procedures and functions stored
> in standard modules, when events on my forms and subforms run ... so
> it hasn't been as big a deal.
> 
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
> McLachlan Sent: Tuesday, May 24, 2011 6: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
> 






More information about the AccessD mailing list