[AccessD] JIT Forms?

Charlotte Foust cfoust at infostatsystems.com
Fri Sep 3 15:03:17 CDT 2004


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



More information about the AccessD mailing list