Microsoft Office 2000 Developer

Data Connectivity

Microsoft^® Office 2000 Developer enhances the data access scenario with a set of tools and technologies that streamline the connecting to and displaying of data in Office 2000 applications.

Data Connectivity Tools
Possible Uses for the Data Connectivity Tools
For More Information about Data Connectivity

Data Connectivity Tools

Today's Office solutions need to deliver data directly to the desktop from a variety of data sources. Data resides in a variety of formats and in a multitude of databases ranging from desktop to the enterprise. Developers need tools that provide high-performance access to all types of information (including relational and non-relational data) across organizations. Office 2000 Developer delivers tools and components that make it easy to integrate data into Office solutions and publish to the Web.

Feature	Description
Data Environment Designer	Creates connections to external databases in an easy to use interface that can easily be used within VBA to bind to data bound controls
ADO Data Control	Creates connections to external databases that can easily be used within VBA to bind to data bound controls.
Data-Aware Microsoft ActiveX^® Controls	Controls, such as the Hierarchical FlexGrid and DataCombo controls, that can be bound to a data source to view or edit data.
Microsoft Data Binding Collection	Manages the interaction between data consumers and data sources.
Data Report Designer	Quickly build sophisticated reports by dragging elements from the Data Environment without writing any code.

Possible Uses for the Data Connectivity Tools

Multiple data sources on Access forms and reports Using the Data Environment and/or multiple ADO Data Controls and the BindingCollection object, you can view multiple sources of data on a Microsoft^® Access form or report. For more information, see Adding Multiple Data Sources to an Access Form.
Importing and processing data sources into Excel sheets Programmatically import data into a Microsoft^® Excel worksheet using an add-in. For example, replace figures in an existing column of a report. For more information, see Displaying Data from a Recordset in an Excel Worksheet.
Dynamic data slides in PowerPoint Use an ADO Data control connected to a DataGrid control, and show the most current data available. Or use a Microsoft^® Chart control bound to a numeric field to show a chart of current figures. For more information, see Displaying a Data-bound Chart Control on a PowerPoint Slide.
Data entry forms Use the Microsoft^®Visual Basic^® UserForm to create an application that updates a database with selected data found in a Microsoft^®Word document. For more information, see Displaying a Hierarchical FlexGrid on an Access Form.
Dynamic data display On a Visual Basic UserForm, display data in a DataGrid based on data in a document. For example, display a customer's history by selecting a name found in a document. For more information, see Displaying Data from a Data Source.

For More Information about Data Connectivity

This documentation provides information about how to use these tools in the Visual Basic for Applications (VBA) 6.0 environment. For more information about the tools and controls themselves, see the Visual Basic documentation.

To learn about	See
How data is accessed using Office 2000 Developer	Accessing Data Using Office 2000 Developer Tools
What a data source is and how they are created in Office 2000 Developer	Creating a Data Source Using Data Connectivity Tools
How to display data in Office 2000 Developer applications, including example code for Office 2000 applications	Displaying Data from a Data Source

A Note on the Documentation

The documentation for the data connectivity tools was originally created for use in Visual Basic 6.0. However because of slight differences between the VBA programming environment (Visual Basic Editor) and Visual Basic 6.0, there are some (consistent) differences. While consulting the documentation, please keep the following differences in mind.

Setting the DataSource property

Visual Basic Editor	Visual Basic 6.0
The property is not available on the Properties sheet. Instead you must set it at run time using the following code: `Set Datagrid1.DataSource = DataEnvironment1`	You can set the property at design time using the Properties sheet.

Adding a DataEnvironment or DataReport designer to a project

Visual Basic Editor Visual Basic 6.0

The designers can only be added to a new project. You can add a designer to any project.
Switching from run mode to design-time mode

Visual Basic Editor Visual Basic 6.0

Click the Design Mode button on the toolbar to stop the project. Click the Stop button on the toolbar.

Visual Basic Editor	Visual Basic 6.0
The designers can only be added to a new project.	You can add a designer to any project.

Visual Basic Editor	Visual Basic 6.0
Click the Design Mode button on the toolbar to stop the project.	Click the Stop button on the toolbar.