[AccessD] JIT Forms?

Thanks for the tip...  I suppose this is something could not be done
in an MDE/ADE environment if it requires that the form be opened in
Design view...


On Fri, 3 Sep 2004 13:03:17 -0700, Charlotte Foust
<cfoust at infostatsystems.com> wrote:
> Look at the Application.CreateControl method for creating controls from
> code.  If you want code behind that control, you need to add that to the
> form's module and set the control's named event to "[event procedure]"
> to connect them.
> 
> Charlotte Foust
> 
> 
> 
> 
> -----Original Message-----
> From: John W. Colby [mailto:jwcolby at colbyconsulting.com]
> Sent: Friday, September 03, 2004 12:32 PM
> To: 'Access Developers discussion and problem solving'
> Subject: RE: [AccessD] JIT Forms?
> 
> Well... The thing to understand is that a control is nothing more than
> VB code.  You can export a form to text and see the vb code used to
> create it. Thus when you add a control to a form you are literally
> adding code to the form's module except that you are doing so via the
> design wizard.  You can add code to the module directly, but it has to
> be in design view.
> 
> I have never done this, but I know the concept.  I have done
> manipulation of code in the modules before.  I would advise looking at
> the form's vba to see what you need to do.
> 
> John W. Colby
> www.ColbyConsulting.com
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Francisco
> Tapia
> Sent: Thursday, September 02, 2004 11:47 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] JIT Forms?
> 
> so the idea is to open the form up in design first add the fields? is
> that right?
> 
> thanks,
> 
> On Tue, 31 Aug 2004 13:47:27 -0400, John W. Colby
> <jwcolby at colbyconsulting.com> wrote:
> > You can do that but only in design view.
> >
> > John W. Colby
> > www.ColbyConsulting.com
> >
> >
> >
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Francisco
> > Tapia
> > Sent: Tuesday, August 31, 2004 11:46 AM
> > To: Access Developers discussion and problem solving
> > Subject: [AccessD] JIT Forms?
> >
> > Anyone have a link, or advice on creating controls JIT?
> >
> > Access2000 / ADP
> > I have an unbound form, that I'd like to pass a recordset to and thus
> > be able to on-the-fly create controls that match the recordset... any
> > ideas?
> >
> > --
> > -Francisco
> > --
> > _______________________________________________
> > 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
> >
> 
> --
> -Francisco
> --
> _______________________________________________
> 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
> 



-- 
-Francisco