Microsoft Office 2000 Developer

Inserting ActiveX Designers into a VBA Project

See Also

Before you can use the Data Environment designer or the Data Report designer, you must activate them in your VBA project. The procedure for inserting ActiveX designers into the Visual Basic Editor environment is slightly different than for Visual Basic 6.0.

Note   In Office 2000 Developer, the ActiveX designers can only be inserted into a new project.

To activate ActiveX designers

1. On the Insert menu, click Components.
   
   
2. Click Designers, and select the desired designer. Office 2000 Developer provides the Data Environment and Data Report designers.
   
   
3. Click OK to close the dialog box.

This needs to be done once; afterwards, the designers will always be present in the Insert menu.

To use an ActiveX designer, you must insert it into the individual projects.

To insert the designers into a VBA project

1. Open the Visual Basic Editor environment.
   
   
2. On the File menu, click New Project. The New Project dialog box appears.
   
   
3. Click Empty Project. A new, empty project is inserted.
   
   
4. On the Insert menu, click the desired designer.

This adds the designers to your project. The next step is to configure the data source.

For examples of configuring data sources are found in Creating a Data Source Using the Data Environment Designer and Creating a Data Source Using the ActiveX Data Objects Library.

More Information about the Data Environment Designer

Overview documentation on using the Data Environment designer can be found in the Data Access Guide in the MSDN Library. For an overview of the Data Environment object, see "About the Data Environment Designer" in the Visual Basic Programmer's Guide. For information on designing a DataEnvironment object, see "Designing a DataEnvironment Object" in the Visual Basic Programmer's Guide.