Charlotte Foust
cfoust at infostatsystems.com
Fri Aug 10 09:55:31 CDT 2007
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