1324
Index
CancelUpdate method, 512
counting records, 498–499
current record pointer, 495
cursor type, specifying, 496–497
CursorType parameter, 510–512
CursorType property, 496–497
Edit method, 512
EOF (end-of-file indicator), 497–498
LockType parameter, 510–512
MoveNext method, 497–498
MovePrevious method, 497–498
navigating recordsets, 495
Open method, 510–512
opening a table, 510
overview, 494–495
RecordCount property, 498–499
RecordsetNavigation procedure, 495
Source parameter, 510–512
Update method, 512
Recordset object, DAO object model, 505–506
Recordset Type property, 310, 652
RecordsetNavigation procedure, 495
recordsets. See also Recordset object.
beginning-of-file indicator, 497–498
closing, 513
counting records, 498–499, 642–644
current database connection, 510–512
current record pointer, 495
cursor type, specifying, 496–497, 510–512
data source, specifying, 510–512
definition, 131
displaying, 140–141
empty, runtime error, 512
end-of-file indicator, 497–498
hiding fields, 647
locking, 510–512
navigating, 495, 497–498
opening, 510–512
overview, 134–135
printing, 153
saving updates, 512
sort order precedence, 148
sorting, 147–149
specifying for unbound forms, 782
updates, canceling, 512
updating fields, 512
view contents of, 493, 511–512
RecordSource property, 271
recycle bin, SharePoint, 1138records (rows) (continued)
highlighting, 220, 239–241
inserting, 46
locking, 296, 310
navigating among, 294
selecting, 220
unique identifiers, 20–21
values, definition, 8
records (rows), adding
AddNew method, 517
in datasheets, 231
to external linked tables, 599
in forms, 231
to tables, with data macros, 558–559
records (rows), deleting
in datasheets, 231
Delete Rows button, 46
enabling deletion, 310
in forms, 231
records (rows), displaying
display width, modifying, 238
hiding/showing records, 237
record display width, modifying, 238
resizing record height, 238
records (rows), in datasheets
* (asterisk), new record indicator, 221–222
adding, 220–223
automatic data-type validation, 224–225
deleting, 220
filtering, 220, 242–246
hiding, 220, 238
saving, 220, 223
sorting, 220, 242–243
records (rows), saving
in datasheets, 231
in forms, 231, 300
layout changes, 242
Records group
Access 2010 ribbon, 36
Datasheet ribbon, 220
Form ribbon, 293
RecordSelectors property, 704
Recordset object, ADO object model
ActiveConnection parameter, 510–512
adOpenDynamic cursor, 497
adOpenForwardOnly cursor, 497
adOpenKeyset cursor, 497
adOpenStatic cursor, 497
BOF (beginning-of-file indicator), 497–49852_475348-bindex.indd 132452_475348-bindex.indd 1324 4/1/10 2:02 PM4/1/10 2:02 PM