Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Office and SharePoint development
Office client development
Office 2013
Access 2013
Welcome to the Access 2013 developer reference
Access 2013 desktop database reference
Access object model reference (Access 2013 developer reference)
Form Object (Access)
Form Properties (Access)
Form.ActiveControl Property (Access)
Form.AfterDelConfirm Property (Access)
Form.AfterFinalRender Property (Access)
Form.AfterInsert Property (Access)
Form.AfterLayout Property (Access)
Form.AfterRender Property (Access)
Form.AfterUpdate Property (Access)
Form.AllowAdditions Property (Access)
Form.AllowDatasheetView Property (Access)
Form.AllowDeletions Property (Access)
Form.AllowEdits Property (Access)
Form.AllowFilters Property (Access)
Form.AllowFormView Property (Access)
Form.AllowLayoutView Property (Access)
Form.AllowPivotChartView Property (Access)
Form.AllowPivotTableView Property (Access)
Form.Application Property (Access)
Form.AutoCenter Property (Access)
Form.AutoResize Property (Access)
Form.BeforeDelConfirm Property (Access)
Form.BeforeInsert Property (Access)
Form.BeforeQuery Property (Access)
Form.BeforeRender Property (Access)
Form.BeforeScreenTip Property (Access)
Form.BeforeUpdate Property (Access)
Form.Bookmark Property (Access)
Form.BorderStyle Property (Access)
Form.Caption Property (Access)
Form.ChartSpace Property (Access)
Form.CloseButton Property (Access)
Form.CommandBeforeExecute Property (Access)
Form.CommandChecked Property (Access)
Form.CommandEnabled Property (Access)
Form.CommandExecute Property (Access)
Form.ControlBox Property (Access)
Form.Controls Property (Access)
Form.Count Property (Access)
Form.CurrentRecord Property (Access)
Form.CurrentSectionLeft Property (Access)
Form.CurrentSectionTop Property (Access)
Form.CurrentView Property (Access)
Form.Cycle Property (Access)
Form.DataChange Property (Access)
Form.DataEntry Property (Access)
Form.DataSetChange Property (Access)
Form.DatasheetAlternateBackColor Property (Access)
Form.DatasheetBackColor Property (Access)
Form.DatasheetBorderLineStyle Property (Access)
Form.DatasheetCellsEffect Property (Access)
Form.DatasheetColumnHeaderUnderlineStyle Property (Access)
Form.DatasheetFontHeight Property (Access)
Form.DatasheetFontItalic Property (Access)
Form.DatasheetFontName Property (Access)
Form.DatasheetFontUnderline Property (Access)
Form.DatasheetFontWeight Property (Access)
Form.DatasheetForeColor Property (Access)
Form.DatasheetGridlinesBehavior Property (Access)
Form.DatasheetGridlinesColor Property (Access)
Form.DefaultControl Property (Access)
Form.DefaultView Property (Access)
Form.Dirty Property (Access)
Form.DisplayOnSharePointSite Property (Access)
Form.DividingLines Property (Access)
Form.FastLaserPrinting Property (Access)
Form.FetchDefaults Property (Access)
Form.Filter Property (Access)
Form.FilterOn Property (Access)
Form.FilterOnLoad Property (Access)
Form.FitToScreen Property (Access)
Form.Form Property (Access)
Form.FrozenColumns Property (Access)
Form.GridX Property (Access)
Form.GridY Property (Access)
Form.HasModule Property (Access)
Form.HelpContextId Property (Access)
Form.HelpFile Property (Access)
Form.HorizontalDatasheetGridlineStyle Property (Access)
Form.Hwnd Property (Access)
Form.InputParameters Property (Access)
Form.InsideHeight Property (Access)
Form.InsideWidth Property (Access)
Form.KeyPreview Property (Access)
Form.LayoutForPrint Property (Access)
Form.MaxRecButton Property (Access)
Form.MaxRecords Property (Access)
Form.MenuBar Property (Access)
Form.MinMaxButtons Property (Access)
Form.Modal Property (Access)
Form.Module Property (Access)
Form.MouseWheel Property (Access)
Form.Moveable Property (Access)
Form.Name Property (Access)
Form.NavigationButtons Property (Access)
Form.NavigationCaption Property (Access)
Form.NewRecord Property (Access)
Form.OnActivate Property (Access)
Form.OnApplyFilter Property (Access)
Form.OnClick Property (Access)
Form.OnClose Property (Access)
Form.OnConnect Property (Access)
Form.OnCurrent Property (Access)
Form.OnDblClick Property (Access)
Form.OnDeactivate Property (Access)
Form.OnDelete Property (Access)
Form.OnDirty Property (Access)
Form.OnDisconnect Property (Access)
Form.OnError Property (Access)
Form.OnFilter Property (Access)
Form.OnGotFocus Property (Access)
Form.OnInsert Property (Access)
Form.OnKeyDown Property (Access)
Form.OnKeyPress Property (Access)
Form.OnKeyUp Property (Access)
Form.OnLoad Property (Access)
Form.OnLostFocus Property (Access)
Form.OnMouseDown Property (Access)
Form.OnMouseMove Property (Access)
Form.OnMouseUp Property (Access)
Form.OnOpen Property (Access)
Form.OnResize Property (Access)
Form.OnTimer Property (Access)
Form.OnUndo Property (Access)
Form.OnUnload Property (Access)
Form.OpenArgs Property (Access)
Form.OrderBy Property (Access)
Form.OrderByOn Property (Access)
Form.OrderByOnLoad Property (Access)
Form.Orientation Property (Access)
Form.Page Property (Access)
Form.Pages Property (Access)
Form.Painting Property (Access)
Form.PaintPalette Property (Access)
Form.PaletteSource Property (Access)
Form.Parent Property (Access)
Form.Picture Property (Access)
Form.PictureAlignment Property (Access)
Form.PictureData Property (Access)
Form.PicturePalette Property (Access)
Form.PictureSizeMode Property (Access)
Form.PictureTiling Property (Access)
Form.PictureType Property (Access)
Form.PivotTable Property (Access)
Form.PivotTableChange Property (Access)
Form.PopUp Property (Access)
Form.Printer Property (Access)
Form.Properties Property (Access)
Form.PrtDevMode Property (Access)
Form.PrtDevNames Property (Access)
Form.PrtMip Property (Access)
Form.Query Property (Access)
Form.RecordLocks Property (Access)
Form.RecordSelectors Property (Access)
Form.Recordset Property (Access)
Form.RecordsetClone Property (Access)
Form.RecordsetType Property (Access)
Form.RecordSource Property (Access)
Form.RecordSourceQualifier Property (Access)
Form.ResyncCommand Property (Access)
Form.RibbonName Property (Access)
Form.RowHeight Property (Access)
Form.ScrollBars Property (Access)
Form.Section Property (Access)
Form.SelectionChange Property (Access)
Form.SelHeight Property (Access)
Form.SelLeft Property (Access)
Form.SelTop Property (Access)
Form.SelWidth Property (Access)
Form.ServerFilter Property (Access)
Form.ServerFilterByForm Property (Access)
Form.ShortcutMenu Property (Access)
Form.ShortcutMenuBar Property (Access)
Form.SplitFormDatasheet Property (Access)
Form.SplitFormOrientation Property (Access)
Form.SplitFormPrinting Property (Access)
Form.SplitFormSize Property (Access)
Form.SplitFormSplitterBar Property (Access)
Form.SplitFormSplitterBarSave Property (Access)
Form.SubdatasheetExpanded Property (Access)
Form.SubdatasheetHeight Property (Access)
Form.Tag Property (Access)
Form.TimerInterval Property (Access)
Form.Toolbar Property (Access)
Form.UniqueTable Property (Access)
Form.UseDefaultPrinter Property (Access)
Form.VerticalDatasheetGridlineStyle Property (Access)
Form.ViewChange Property (Access)
Form.ViewsAllowed Property (Access)
Form.Visible Property (Access)
Form.Width Property (Access)
Form.WindowHeight Property (Access)
Form.WindowLeft Property (Access)
Form.WindowTop Property (Access)
Form.WindowWidth Property (Access)
Expand Minimize
This topic has not yet been rated - Rate this topic

Form.PivotTableChange Property (Access)

Office 2013

Published: July 16, 2012

Returns or sets a String indicating which macro, event procedure, or user-defined function runs when the PivotTableChange event occurs. Read/write.

expression .PivotTableChange

expression A variable that represents a Form object.

Valid values for this property are "macroname" where macroname is the name of macro, "[Event Procedure]" which indicates the event procedure associated with the BeforeInsert event for the specified object, or "=functionname()" where functionname is the name of a user-defined function.

The following example specifies that when the PivotTableChange event occurs on the first form of the current project, the associated event procedure should run.

VBA
Copy 
Forms(0).PivotTableChange = "[Event Procedure]"
Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.