|
|
PivotTables and PivotCharts are two powerful elements for expanding the interface options that you can offer in your custom applications. Microsoft is obviously favoring PivotTables and PivotCharts in Access database files (.mdb) and Access projects (.adp) by making them view objects for all row-returning objects, such as tables, in Access database files (.mdb) and Access projects (.adp). The trick to programmatically creating and formatting PivotTables and PivotCharts in Access 2003 is to learn the Office 2003 Web Components object model. The owc11.dll file implements Office 2003 Web Components, and you can create a reference to the owc11.dll file from a VBA project in your Access database files and Access projects. Because owc11.dll is also used for Web modeling, you have the advantage of one model for work within Access 2003 forms on a LAN as well as within Microsoft FrontPage 2003 Web pages on a Web site. Chapter 14 provides more detail on Office Web Components and FrontPage 2003.
This chapter introduces you to the basics of the object model for PivotTables and PivotCharts through a collection of PivotTable and PivotChart code samples. The PivotTable samples demonstrate techniques for creating a PivotTable, formatting it, controlling how users can edit it, and filtering it. The PivotChart samples illustrate how to create bar charts and line charts, as well as how to reformat base versions of either chart type. In addition, the commentary on the samples equips you for working with other kinds of charts by conveying a basic understanding of the key properties and methods for the PivotChart object and its nested objects.
|
|