jwcolby
jwcolby at colbyconsulting.com
Fri May 27 09:41:29 CDT 2011
Usually they are bound to a query. John W. Colby www.ColbyConsulting.com On 5/26/2011 3:34 PM, Darrell Burns wrote: > 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 >>