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

jwcolby jwcolby at colbyconsulting.com
Fri Aug 10 08:25:54 CDT 2007


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




More information about the AccessD mailing list