Index_R

R

raised text boxes, 47

random number generation, 17

ranges, Excel, 503–504

read-only forms, 18, 72

ReadStat property, 322

read/write functionality, 241

REC button, Word status bar, 372

Recipients button (Access Menu Wizard), 210

recording macros, 372–373, 504

records

filtered, 454, 525

in forms, locating, 54

in linked tables, adding, 332

listbox records, creating letters for, 95–99

mail merge documents, 391

skipped, 445–446, 463

in tables, deleting, 340

tmakMatchingRecords variable, 459

RecordsetClone method, 54

RecordSource property, 212

Rectangle button (Toolbox), 80

rectangle control, forms, 111

Redemption Library (Outlook), 493

redundant data, eliminating, 31–32

references

automation problems, avoiding, 420–421

Menu Manager add-in, 206–208

missing reference errors, 256

objects, 288, 431–432

References button, adding to Standard toolbar, 365

References dialog box

accessing, 255

Browse button, 258–259

discussed, 207, 365

SafeOutlook Library option, 493

WinFax Automation Server option, 550

referential integrity, 34

Refresh button

PivotChart toolbar, 172

PivotTable toolbar, 165

Refresh Lookup Tables option (Add-In Manager dialog box), 206

relationships

clients, 260–261

discussed, 32

many-to-many

discussed, 32, 37

forms, 76–77

one-to-many, 34–36

one-to-one, 36

referential integrity, 34

in Table Wizard, setting, 12

Relationships button (Table Wizard), 14–15

removing totals, PivotTables, 162

Rename Database Objects add-in, 295–296

Rename Form Controls add-in, 295–296

Rename Report Controls add-in, 295–296

renaming

form controls, 299–300

forms, 298

objects, 296–298

queries, 298–299

table fields, 12

tables, 150

repeating data, eliminating, 31

reports

address book, 190

backgrounds controls, 327

captions, 195

columnar, 189–192

conditional formatting, 198–201

design principles, 175–176

expressions, 183

filtering, 195–196

fonts, 180

footers, 176, 184

Force New Page property, 184

forms and, 176, 193

grids, 179

grouped, 179, 183–186

headers, 176, 184

hidden mode, 196

hiding, 212

labels, 187–188

landscape orientation, 179

named constants, 199

New Report dialog box, 176

one-line event procedures, 196

page totals, 185

plain text, 177

portrait orientation, 179

print formats, 190–191

printing, 194

queries, 177

Report Wizard, 176–179

resizing, 181

shaded, 201

single order, 195–196

sorting, 322

subreports, 192–193, 323

summary, 197

sums, 185

tabular, 181–182

tags, 292–293

templates, 179–181

text, wrapping, 183

tlkpReports variable, 210

visibility controls, 327

watermarks, 201–204

Reports button (Access Menu Wizard), 210

resizing

datasheet columns, 64

reports, 181

RickWorld Web site, 295

right outer joins, 33

rotation, images, 203

Row Source property, 55, 58

rows

comboboxes, table/query row source, 85–86

field list row source, 86–90

headings, PivotTables, 158–159

value list row source, comboboxes, 86

rpt tag (report), 292–293

rstNew function, 342

rstOld function, 342

rsub tag (report, subreport), 292

Run button (Query Design toolbar), 143

RunningSum property, 186