Index

R

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