Index_P

P

p tag (public variables), 291

Page Break button (Toolbox), 80

page break control

forms, 112

tags, 294

Page Setup dialog box, 191

page tag (pge), 294

page totals, reports, 185

Paint Select tool (WordArt Gallery), 203

parameter value error messages, 207

Paste button (Expression Builder dialog box), 68–69

Paste Table As dialog box, 352

PDF file format, 481–482

pge tag (page), 294

Picture command (Insert menu), 202

Picture property, 110

pie charts, PivotCharts, 170

PivotCharts

column graphs, 169

creating, 167–168

embedded, 173

formatting options, 168

legends, 168

line graphs, 170

pie charts, 170

3D graphs, 170

toolbar buttons, 171–173

PivotTables

column headings, 158–159

customization, 160

data source queries, 156–157

drop zones, 157

Edit Pivot Table button, 157

filter values, 161

fonts, 162

overview, 155

properties sheet, 166–167

row headings, 158–159

summary display, 163

toolbar buttons, 164–166

totals, adding and removing, 162

placeholders, 170

plain text reports, 177

pop-up calendars, 117

pop-up menus

discussed, 210

security features, 492–494

portrait orientation, reports, 179

PowerQuest Web site, 251

prefixes, 290

Preview button

PivotChart toolbar, 172

PivotTable toolbar, 165

primary data types, 16–18

primary keys, 12, 33

primary tables, 34

Print button

PivotChart toolbar, 172

PivotTable toolbar, 165

print formats, reports, 190–191

printing

labels, 187

reports, 194

PrintOut method, 500

procedures, reviewing, 5

Products template (Table Wizard), 26–27

progress bar, sending faxes, 547

Project Explorer, 213

properties. See also functions; methods

ActiveInspector, 484

AllowAdditions, 232

AllowZeroLength, 340

BackStyle, 201

Class, 484

Columns Width, 94

Control Source, 86, 113

Data Entry, 232

DefaultItemType, 460

EndTime, 465–466

FieldSize, 16, 19

Filter, 155

Force New Page, 184

Format, 24

Group Footer, 190

Group Header, 190

Group On, 190

Input Mask, 12–13

IsLoaded, 54, 298

ItemsSelected, 95, 387

Keep Together, 190, 192

LetterText, 377

Limit To List, 90, 312

LinkChildFields, 62, 71

LinkMasterFields, 62, 71

MailItem, 432

MultiSelect, 93–94

Name, 52, 58, 189

OlItemType, 433

olMail, 433

Order By, 121

Picture, 110

Query Properties, 58

ReadStat, 322

RecordSource, 212

Row Source, 55, 58

RunningSum, 186

Selected, 109

StartTime, 465

Subject, 392–393

Tag, 52, 300

Type, 89

Unique Values, 58

Visible, 197

Properties button

Access Page Setup, 190

PivotChart toolbar, 172

PivotTable toolbar, 166

properties sheet

PivotTables, 166–167

VBA, 214

prps variable, 376

pstrDataType object, 401

pstrFilterField variable, 456

pstrForm object, LNC naming element, 295

pstrQuery variable, 456–457

public variables, 291