jwcolby
jwcolby at colbyconsulting.com
Fri Aug 10 08:58:49 CDT 2007
That is what I was after. I have delved into that stuff before and never found a way to programmatically save. 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 9:51 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] How to create a form with the VBA ExtensibilityLibrary 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 > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com