Access Data Analysis Cookbook (Cookbooks)
| [SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] page breaks Page property (reports) 2nd page ranges page totals PageHeader property (reports) 2nd pages different headers/footers displaying multiple Painting property (forms) 2nd 3rd paper sources, controlling PaperBin property (Printer object) 2nd 3rd PaperSize property (Printer object) 2nd 3rd ParamArray keyword 2nd parameter queries creating recordsets based on printing values specifying criteria at runtime using form-based prompts parameterized constructors calling .NET components containing parameters controls as named parameters passed to procedures passing arrays as passing variable number of printing values square brackets and using across multiple DAPs using optional Parent property (labels) parentheses ( ) Partition function 2nd 3rd pass-through queries 2nd passwords for new accounts retrieving all blank security model and Paste Special dialog pattern matching Performance Analyzer (Access) performance considerations accelerating load time caching algorithms and calculating median and comparing techniques forms execution linked tables and supplying input parameters 2nd TimeInterval property and tracking user changes VBA code permissions assigning attaching linked tables and granted to Users group inheriting through groups recommendations for assigning 2nd 3rd Security Wizard and updating data with views persistence, user-defined properties and Person Name smart tag Person smart tag adding or editing contact information in Outlook allowable actions using with Date smart tag Personal Identifier (PID) 2nd 3rd 4th pessimistic locking setting maximum locking interval for record PgDn key PgUp key PHP Picture Builder Wizard (Access) Picture property (buttons) animated buttons 2nd Build button and Picture property (forms) communicating without email 2nd removing form watermarks PictureAlignment property (forms) PictureData property (buttons) 2nd PictureData property (controls) PictureSizeMode property (forms) PictureTiling property (forms) PictureType property (forms) pipes (|) pixels 2nd plus sign (+) 2nd points, compared with twips pop-up forms accepting new entries creating creating generic calendar hWnd property and improving performance initializing 2nd PopUp property (forms) creating dialog forms creating pop-up calendars creating status meters window placement and Port property (Printer object) 2nd PostMessage function 2nd PowerPoint 2nd PowerPoint 10.0 Object Library PowerPoint 2002 Presentations collection presentations, creating 2nd 3rd Preserve keyword primary interop assembly (PIA) primary keys Print event 2nd PrintArtistReport form Printer objects Access 2002 feature ColumnSpacing property DataOnly property information in ItemLayout property 2nd output ports and paper source and Printer property and Printer property (Application object) 2nd Printer property (forms/reports) 2nd 3rd printing adding/canceling connections based on conditions changes in Access 2002 changing options choosing output device at runtime documents margin and column settings matching records only obtaining list of installed printers paper sources, controlling retrieving information about selected printer setting default printer suppressing PrintOut method (DoCmd object) PrintQuality property (Printer object) procedure stacks creating global profiler and procedures class modules and creating to react to events exit point recommendations passing parameters to 2nd property procedures stored procedures 2nd 3rd Product function (Excel) profile stack profilers, creating execution time PROGMAN program 2nd Program Manager Project Properties Pages dialog box Proper function (Excel) properties calling functions directly from changing based on security level converting databases to replicated documenting example storing for dialog forms group membership and handling hidden naming conventions obtaining list of purpose of query restrictions retrieving for reports steps in assigning viewing across objects viewing for queries Properties collection 2nd 3rd 4th properties sheets animated buttons Build button and customizing images displaying limitations of retrieving report information and Property Get procedure Property Let procedure property names |