1319
Index
properties, adding, 994–995
retrieving product details, 992
ProductID property, 993–994
progress meters, 869–872, 918–919
Project Description option, 413
Project Name option, 413
Project Properties dialog box, 412–414
properties. See also control properties; fields (columns),
properties.
ActionName, 1073
Address, 66
Allow Additions, 310
Allow Datasheet View, 306
Allow Deletions, 310
Allow Edits, 310
Allow Filters, 310
Allow From View, 306
Allow Layout View, 306
Allow PivotTable View, 306
AllowBypassKey, 925
AllowZeroLength, 60, 70–71
Arguments, 1073
Auto Center, 307
Auto Resize, 307
BackColor, 682
Border Style, 307, 360
BorderStyle, 704
of a class, creating, 975–976
Close Button, 307
collections, 407
Column Headings, 653
Condition, 1073
Connect, 600–606
Control Box, 307
Control Source, 284
ControlSource, 691–693
Count, 407
CursorType, 496–497
Custom Ribbon ID, 311
Cycle, 311
DAO, 486–487
Data Entry, 310
Day, 362
DecimalPlaces, 59
Default View, 306, 651
DefaultValue, 59
definition, 282
Description, 651, 1073
Dest Connect Str, 653importing text files, 621
indexed tables, 117
matching foreign keys, 114
natural, 77, 118–119
null values, 113
setting, 76–77
single, 118
specifying, 46
surrogate, 77, 118–119
Print event, 462–463
print events, 452
Print method, 537–538
Print Preview, 249, 335–340, 741
Print Preview command, 249
Print Preview window, 335–337
printer fonts, versus screen fonts, 308
printing. See also reports.
datasheets, 248–249
forms, 300–301, 311
messages, 537–538
recordsets, 153
reports, 338–340
table design, 84–85
privacy settings, 937–938
Private keyword, 427
private scope, 427, 432–434
problems. See error handling; troubleshooting.
procedures, VBA. See also VBA, event procedures; VBA
functions; VBA subroutines.
Call statement, 437
calling, 437
calling from data macros, 576
compiling, 397
creating, 395, 397–399, 436
definition, 380
editing, 399
versus modules, 380
naming conventions, 435–436
scope, 432–434
testing in Immediate window, 399–401
Product class. See also class modules; OOP (object-oriented
programming).
creating, 972–974
methods, 974
methods, adding, 995–996
modifying, 991–996
ProductID property, 993–994
properties, 97352_475348-bindex.indd 131952_475348-bindex.indd 1319 4/1/10 2:02 PM4/1/10 2:02 PM