[AccessD] How to create a form with the VBA Extensibility Library

philippe pons phpons at gmail.com
Fri Aug 10 08:51:10 CDT 2007


The same way as when the module is added "by hand": you click on Save.
I don't know if there is a programmatic way of doing that!

2007/8/10, jwcolby <jwcolby at colbyconsulting.com>:
>
> 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
>



More information about the AccessD mailing list