Microsoft Access 2010 Bible

(Rick Simeone) #1

1321


Index


data types, 990–991
getting, 986, 988–989
naming conventions, 990
Property Get, 986, 989
Property Let, 986, 988
Property Set, 986, 988
property value persistence, 989–990
read-only access, 987
read/write access, 987
rules, 990–991
setting, 986
write-only access, 987
Property Set, 986, 988
Property Sheet
Data properties, 283
displaying, 282–283
Event properties, 283
form properties, 302–311
Format properties, 283
Other properties, 283
setting properties, 283
tables, 46–47
Property Sheet button, 46–47
property values
getting, 927
persistence, 989–990
setting, 926–927
protected fields, 231
pruning the call tree, 842–844
Public keyword, 426
public scope, 426, 432–434
public-facing Web sites, 1141–1143
Publish to Access Service button, enabling,
1139–1140
publishers, trusted, 937
publishing to the Web
new features, 1258
SharePoint deployment, 1156–1157, 1164–1173

Q
q:, formatting quarter of the year, 63
QBE (Query by Example) grid
columns, resizing, 143–144
description, 137
Or operations, 202–203
resizing columns, 143
table names, viewing, 155–156

Split Form Printing, 309
Split Form Size, 309
Split Form Splitter Bar, 309
Style, 702
Sub-Address, 66
Subdatasheet Expanded, 308, 653
Subdatasheet Height, 308, 653
Subdatasheet Name, 652
Tab Index, 314
Tab Stop, 314
TabFixedHeight, 702
TabFixedWidth, 702
tables, specifying, 46–47
TabStop, 22
Tag, 311, 782
for the tblCustomers field, 73–76
Toolbar, 311
Top, 683
Top Values, 651
UnicodeCompression, 60
Unique Records, 651
Unique Values, 651
Use Default Paper Size, 311
Use Transaction, 653
Validation Rule, 60, 69
Validation Text, 60, 69
Value, 702
viewing linked tables, setting, 598
Visible, 682, 684
Week, 362
Width, 307, 683
Year, 362
properties, Caption
dynamic setting, 682
for form title bars, 306
naming conventions, 285
setting at runtime, 682
tab labels, setting, 702
properties, Each Value
Currency data types, 363
Date/Time data types, 362
Number data types, 363
Text data types, 362
Property Get, 986, 989
Property Let, 986, 988
property procedures. See also OOP (object-oriented
programming).
assigning values to, 986, 988
bulletproofing, 980–981

52_475348-bindex.indd 132152_475348-bindex.indd 1321 4/1/10 2:02 PM4/1/10 2:02 PM

Free download pdf