1273
Index ........................................................................................................................................
adding fields to
forms, 315–316
queries, 138–140, 156
tables, 41
adding page numbers to
forms, 694
reports, 353
adding records to
datasheets, 220–223, 231, 234
forms, 231
adding records to tables
with data macros, 558–559
in Datasheet view, 88
external linked tables, 599
with forms, 88
primary keys, 119
with VBA code, 517
add-ins, trusted, 937
AddNew method, 517
Address property, 66
adLockBatchOptimistic constant, 769
adLockOptimistic constant, 769
adLockPessimistic constant, 769
adLockReadOnly constant, 769
adLockUnspecified constant, 769
ADO (ActiveX Data Objects)
versus DAO, 486, 507
data access errors, 837–838
methods, 486–487
optimistic locking, 773–774
overview, 485–488
pessimistic locking, 769–771
properties, 486–487
ADO object model
clearing from memory, 491
Command object, 492–494
Connection object, 489–492
ConnectionString property, discovering, 491–492
diagram, 488
ADO object model, Recordset object. See also recordsets.
ActiveConnection parameter, 510–512
adOpenDynamic cursor, 497
adOpenForwardOnly cursor, 497
adOpenKeyset cursor, 497
adOpenStatic cursor, 497
BOF (beginning-of-file indicator), 497–498
CancelUpdate method, 512
counting records, 498–499record-locked fields in multiuser environments, 676
running, 675–676
troubleshooting, 676
truncating text data, 676
types of, 671
updating records, 672–673
ActionName property, 1073
actions, macro
cursor, changing to hourglass, 1054–1055
Echo, 1055, 1056
hiding/showing macro results, 1055, 1056
Hourglass, 1054–1055
for mcrBackupContactsAndProducts macro,
1054–1057
MessageBox, 1055
messages, displaying, 1055
opening a query, 1055, 1056
OpenQuery, 1055, 1056
SetWarnings, 1054–1055, 1056
system messages, enabling/disabling, 1054–1055, 1056
Activate event, 457, 461
ActiveConnection parameter, 510–512
ActiveX Data Objects (ADO). See ADO (ActiveX Data
Objects).
ActiveX settings, 937
Add Watch dialog box, 546–548
adding
class modules to databases, 974–975
commands to Quick Access Toolbar, 1018–1019
data macros to tables, 554
data to reports, 737–738
descriptions to fields, 54–55
dialog box pages, 701
logos to forms, 695
macro items to data macros, 566–569
QBE grid to fields, 156
queries, 137
tables to queries, 136, 160
text boxes to reports, 352–359
user names to reports, 738
adding controls to forms
buttons, 385–386
with the Controls group, 267–268
with the Field List, 268–271
overview, 266–267
adding date/time to
forms, 694
reports, 37252_475348-bindex.indd 127352_475348-bindex.indd 1273 4/1/10 2:01 PM4/1/10 2:01 PM