Microsoft Office 2000 Developer

Using Data-Aware Controls in Office Applications

See Also

The Microsoft Office 2000 Developer includes several data-aware controls, which can be used to display data either when inserted into Office application documents or when used on a VBA UserForm.

Once you have decided which control to use, insert it into an appropriate container form. For details on inserting controls, see Activating and Inserting Controls.

For examples of data-aware controls in Office 2000 applications, see:

• Displaying a Hierarchical FlexGrid on an Access Form
  
  
• Displaying a Data-bound Chart Control on a PowerPoint Slide

Data-Aware Controls in Office 2000 Developer

Complete documentation for each of the controls, including reference and overview material, can be found in the MSDN Library in the Visual Basic Programmer's Guide, the Data Access Guide, and the Component Tools Guide.

Available Data Access Controls

• ADO Data Control   A graphic control that provides easy connection and navigation of ADO data sources such as SQL Server, Oracle, Access, and ODBC databases.
  
  
• DataGrid Control   View and edit data in a grid format.
  
  
• Hierarchical FlexGrid Control   View hierarchical recordsets constructed with the Data Environment designer.
  
  
• DataCombo Control   A combo control specifically designed to be bound to data sources.
  
  
• DataList Control   A list control also designed to work with data sources.
  
  
• Microsoft Chart Control   A data-aware control that charts numbers when bound to an appropriate field in a recordset. Several chart types are available, including 3-D types.
  
  
• Microsoft MonthView Control   A graphic representation of a calendar that can be bound to a date field. Use to display dates or as input interface for users.
  
  
• Microsoft DateTimePicker Control   Similar to the MonthView control, except the calendar drops down from a textbox for date entry saving space in a user interface layout.