1292
Index
declaring VBA variables
declarations section, 394, 427
explicitly, 424, 430
forcing explicit declaration, 394, 411, 431
implicitly, 423, 430
importance of, 424
overview, 421–425
decompile option, 876
decomposition, 99
Decrease Horizontal command, 277
Decrease Vertical command, 277
default data type, VBA, 426, 430
Default Open Mode option, 766
Default Record Locking option, 766
Default View property, 306, 651
DefaultValue property, 59
defragmenting hard drives, 856
Delete event, 458–459
Delete Page method, 701
Delete Query action queries, 671, 673–675
Delete Rows button, 46
DeleteRecord action, 560
deleting. See also removing.
controls, 281
dialog box pages, 701
fields, 41, 56
groups of controls, 279
records, 46
records with data macros, 560
table relationships, 126
tables, 86
text boxes from reports, 354–355
deleting records
across multiple tables, 518–521
checking deletion status, 515–516
Datasheet view, 234–235
Delete method, 517–518
Delete Rows button, 46
enabling, 310
with VBA code, 517–521
deletion anomalies, 103
deletion confirmation
AfterDelConfirm event, 458–459
BeforeDelConfirm event, 458–459
Design tab, 46
with event procedures, 458–459, 470–471
status, checking, 458–459
denormalization, 102–104debugging, macros
debug window, 1074
error information, displaying, 1074
MessageBox action, 1074
Single Step dialog box, 1074
stepping through code, 1074
StopMacro action, 1074
stopping macro execution, 1074
debugging, tools and techniques
Add Watch dialog box, 546–548
breakpoints, 539–544. See also Stop statements.
Call Stack window, 548–549
color coding, 539
compiler directives, 535–537
conditional compilation, 535–537
#Const directive, 535–537
#Else directive, 535–537
#End If directive, 535–537
error messages, 534–535
help for syntax, 528–529
help for variables, 543–544
#If directive, 535–537
Immediate window, 399–401, 538–539, 541
Locals window, 544–545
MsgBox statement, 534–535
Print method, 537–538
printing messages, 537–538
stepping through code, 543–544
Stop statements, 542. See also breakpoints.
tracing execution path, 549
variables in scope, displaying, 544–545
watches, setting, 545–547
Watches window, 545–548
Decimal data type, VBA, 428
decimal places, formatting, 62
Decimal size numeric fields, 52
DecimalPlaces property, 59
declarations section, VBA, 394, 427
Declare statement
ArgumentList parameter, 947–949
arguments, passing ByVal versus ByRef, 948
As DataType parameter, 949
FunctionName parameter, 946
functions versus subroutines, 946
LibraryName parameter, 947
purpose, 946
strings, maximum length, 949
syntax, 94652_475348-bindex.indd 129252_475348-bindex.indd 1292 4/1/10 2:01 PM4/1/10 2:01 PM