Pivot TablePivot Chart Events

Beginning with Access 2002, table and query data can be presented in an Access form in a PivotTable or PivotChart view, allowing users to perform interactive data analysis. PivotTable and PivotChart views can be built pro-grammatically in a Microsoft Access form by using the Office Web Components Object Model. To give programmers enhanced control over PivotTable and PivotChart views, Access forms offer a number of events that are available when the form is displayed in one of these views. These events are organized in five categories, as shown in Table 24-2.

Table 24-2: PivotTable/PivotChart events

Category Name

Event Name

PivotTable Event

PivotChart Event

Data Source

OnConnect

Yes

No

Events

OnDisconnect

Yes

No

BeforeQuery

Yes

No

Query

Yes

No

Display Events

BeforeScreenTip

Yes

Yes

AfterLayout

No

Yes

BeforeRender

No

Yes

AfterRender

No

Yes

AfterFinalRender

No

Yes

Change Events

DataChange

Yes

No

DataSetChange

No

Yes

PivotTableChange

Yes

No

SelectionChange

Yes

Yes

ViewChange

Yes

Yes

Command Events

CommandEnabled

Yes

Yes

CommandChecked

Yes

Yes

CommandBeforeExecute

Yes

Yes

CommandExecute

Yes

Yes

Keyboard and

KeyDown

Yes

Yes

Mouse Events

KeyPress

Yes

Yes

KeyUp

Yes

Yes

MouseDown

Yes

Yes

MouseMove

Yes

Yes

MouseUp

Yes

Yes

MouseWheel

Yes

Yes

Click

Yes

Yes

DblClick

Yes

Yes

Event Programming in Forms and Reports o

0 0

Post a comment