[AccessD] How to create a form with the VBA ExtensibilityLibrary

Jim, CreateForm does not seem to be useful for me, as I want to make a
simple copy ofa template form. However, I just found that:
DoCmd.CopyObject, "frmNew", acForm, "frmTemplate" do the job I want.

Thanks again, Philippe


2007/8/10, Charlotte Foust <cfoust at infostatsystems.com>:
>
> John,
>
> I used to do a lot of code building in code in Access 97.  I can
> probably dig some old code out for you if you're interested.  Inheriting
> from a class is a better approach for the latest versions.
>
> Charlotte
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Friday, August 10, 2007 6:26 AM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] How to create a form with the VBA
> ExtensibilityLibrary
>
> How did you SAVE the module once created?
>
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of philippe pons
> Sent: Friday, August 10, 2007 8:09 AM
> To: accessd at databaseadvisors.com
> Subject: [AccessD] How to create a form with the VBA Extensibility
> Library
>
> Hi all,
>
> I just discovered the capabilities of this library that allows to
> programmaticaly control the VBE.
> I can now create a new class module with:
> Application.VBE.ActiveVBProject.VBComponents.Add (vbext_ct_ClassModule)
>
> or a standard module using the vbext_ct_StdModule constante.
>
> But I can't find how to create a new Form!
> There is a vbext_ct_MSForm constante, but it creates a UserForm, very
> similar to the ones used in Excel, not an Acces Form.
>
> Do you know if it is possible, and how to do that?
>
> TIA,
>
> Philippe
> --
> 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
>