1286
Index
TableDef object, 502–503
transaction tracking, 501
Workspace object, 501
dash. See hyphen.
data. See also datasheets; normalization.
back-end data files, 32
definition, 6
designing, 16–18
in local tables, 32
rows, SharePoint maximum, 1143
data access with VBA, filtering data in forms
with code, 888–889
interactive filter dialog boxes, 892–894
With keyword, 895
linking dialog boxes, 894
with queries, 889–895
wildcards, 890–891
data access with VBA, finding data in forms
bookmarks, 885–888
FindRecord method, 883–885
unbound combo boxes, 881–883
data actions, 560–562
data aggregation, 247–248
Data Blocks actions, 557–560
data entry, datasheets
* (asterisk), new record indicator, 221–222
adding new records, 220–223
automatic data-type validation, 224–225
Currency data, 226
Date/Time data, 225
input masks, 225
Memo data, 226–227
Number data, 226
OLE Object data, 226
text data, 225
data entry, forms
controls, 22. See also specific controls.
creating, 11–12
designing, 22
graphical objects, 22
labels, 22
overview, 11–12
text-box data-entry fields, 22
Data Entry property, 310
data events, 452
Data Execution Prevent (DEP) mode, 937
data integrity. See referential integrity.customizing the ribbon defaults (continued)
renaming groups, 1020–1022
resetting to original, 1022
tabs, 1020–1022
with Visual Web Developer, 1042–1044
customizing ribbons
building XML, 1026
controls, 1025–1026
creating a ribbon, 1023
custom property, specifying, 1032–1033
designing ribbons, 1026
error reporting, enabling, 1024
getLabel attribute, 1028
groups, 1025–1026
hierarchical structure, 1025–1026
OnAction attribute, 1024
tabs, 1025–1026
USysRibbons table, adding XML, 1030–1032
USysRibbons table, creating, 1029–1030
VBA callbacks, overview, 1023–1025
VBA callbacks, writing, 1027–1029
customizing SharePoint pages, 1143
Cut command
Datasheet ribbon, 220
Form ribbon, 292
cutting/copying/pasting. See also copying.
data in datasheets, 220, 231–233
macro items, 569–571
Cycle property, 311D
d:, formatting day of the month, 63
DAO (Data Access Objects)
versus ADO, 486, 507
linking tables, 600–606
methods, 486–487
overview, 485–488, 499–500
pessimistic locking, 770–771
properties, 486–487
DAO object model
Database object, 502
DBEngine object, 501
diagram, 500
Field objects, 506
QueryDef object, 503–505
Recordset object, 505–506
security, 50152_475348-bindex.indd 128652_475348-bindex.indd 1286 4/1/10 2:01 PM4/1/10 2:01 PM