Raise method of the Err object, 74–75
RaiseEvent statement, 114
raising events, 113
Range parameter, 205
Rapid Application Design (RAD), 3
read-only locks, 317
read-only properties, 107
record count, 434
record locking
on bound forms, 316–317
on unbound forms, 317–318
record navigation methods, 141
Record Selectors property, 142, 149
Recordcount property, 140–141
records
adding to a table, 242
counting in a recordset, 140–141
deleting current from the recordset, 142
deleting from cross-reference tables, 397–398, 409
event procedures for navigating, 444–445, 450
inserting into cross-reference tables, 398–399, 409
navigating to particular, 157–158
procedures for saving displayed, 425–426, 439
sorting for the unbound contacts form, 156–157
updating the current in a recordset, 142
recordset navigation procedures, 386–388, 402
Recordset object
adding code for, 142, 150
creating, 133–140
declaring a new, 138
instantiating a new, 138
navigation methods, 141
properties and methods of, 83, 156–159
retrieving a set of records from a data source, 132
setting properties of, 143, 151
Recordset property, 138–139
recordsets
adding, editing, and deleting records in, 141–156
counting records in, 140–141
declaring in frmProjects, 428
filtering to smaller subsets, 158–159
navigating through, 141
populating controls on a form, 143, 151
procedures for navigating through, 144, 152
reconnecting to underlying data sources, 147, 155
repopulating values in, 405
repopulating with the most current values, 169, 175
sorting, finding, and filtering records in, 156–159
storing in local memory, 143, 151
using SQL and ADO to populate, 162–164
RecordSource property
of CreateReport, 245
of a report, 236
specifying a SQL statement as, 160
ReDim statement, 52
references
adding to the ADOX library, 177
adding to web services, 215–218
References dialog box, 288
RefreshContacts procedure, 426–427, 439–440
RefreshHistory procedure, 511
registering add-ins, 313
repairing Access databases, 331
replication, removed for ACCDB files, 2
report events, 247–248
Report object, 96–97
report properties, changing, 236
reports
adding controls to, 238–241
creating programmatically, 237–248
designating printing options for, 246–247
manipulating from VBA code, 235–248
opening in preview mode, 245, 246
setting the data source for, 236–237
Reports collection, 96–97
Requery method, 167, 173
RequeryRecordset procedure, 391, 405–406
Require Variable Declaration option, 31
Requirement Number for a Use Case, 5
Resume Next statement, 72
Resume statement, 72
Retrieve method, 112, 113
RetrieveAttachments function, 363, 368
RetrieveComments function, 362, 367–368
RetrieveContacts function, 362–363, 368, 375–376, 380
RetrieveCustomers function, 485–486
RetrieveProjects function, 361–367
reusable modules, writing, 322
ribbons, 2
rich client, 16
Rich Text data type, 222
rich text in memo fields, 2
right join, 161
roadmap for building a system, 4–5
RollbackTrans method, 313, 314
row-level security, 271
RowSourceType property, 95
rpt (Report) prefix, 56
rsub (Subreport) prefix, 56
RunSearch procedure, 512
runtime, 330
runtime errors, 64, 66, 74
/runtime switch, 330