Index

R

records

finding, 147–149

locking, 352–355, 355–357

updating, 150

validating, 150–151

recordsets, 157

assigning dynamically, 222–224

ReDim keyword, 107–108, 110

references, 127

creating references to Microsoft Office products, 307–313

referential integrity, 4, 218–219, 340

refresh interval, setting, 351

regression testing, 23

Relationship Wizard, 325, 326

relationships, 19, 32

many-to-many, 33

one-to-many, 33

one-to-one, 33

Rename, 414–415

RepaintObject, 415

repetition structures, 92

reports, 233–236

adding charts to, 240–244

adding controls to, 249–252

AutoReport, 234

calling from VBA, 246–247

CreateControlReport method, 249–252

CreateReport method, 247–249, 250

creating programmatically, 247–252

in Design View, 233–236

empty, 247–249, 250

mailing labels, 244–246

Report Wizard, 236–240

specialized, 240–246

Requery, 415

Require Variable Declaration, 129

Restore, 416

RunCommand, 416

RunMacro, 416–417

RunSQL, 417–418

runtime errors, 109–110, 182–187