1331
Index
Size to Fit Form button
Datasheet ribbon, 220
Form ribbon, 293
SizeMode property, 297
sizing handles, controls, 271–272, 273–274. See also
resizing.
slash (/)
date delimiter, 625
division operator, 174, 188
input mask separator, 67
integer division operator, 175
in select queries, 188
separating time elements, 63
SmartTags property, 60
snaking report columns, 741–747
Snap to Grid command, 276–277
snapping to the grid, 276–277
Snapshot Viewer option, 636
Social Security numbers
data types, 50, 51
formatting, 66–68
Sort & Filter group
Datasheet ribbon, 220, 242–246
Form ribbon, 293
illustration, 36
sort order
precedence, recordsets, 148
selecting for reports, 327–328
sorting
data on forms, 309
data types, 50–51
fields, 142–143, 235–236
Memo fields, 50, 147
numbers, 51
object lists, 420
OLE object fields, 147
with QuickSort ribbon, 243
records, 134, 220, 242–243
recordsets, 147–149
report data, 361–366, 710–714
reverting to original order, 243
selected records, 475, 484. See also ORDER BY clause.
with Sort & Filter group, 36
sound, data type. See OLE Object data type.
Source Connect Str property, 652
Source Database property, 652
Source parameter, 510–512
SourceTableName property, 600–606relationship issues, 1160–1161
report errors, 1175–1176
reports do not support events, 1176
reserved word collisions, 1177
schema errors, 1178–1179
SQL statement problems, 1176
subqueries in queries, 1177
table field issues, 1179
table name issues, 1179
table relationships, 1174
Unique property problems, 1179
unsupported form controls, 1175
unsupported report controls, 1176
SharePoint lists
creating, 1112–1115
definition, 1105
editing list items, 1110–1111
wikis, creating, 1112–1115
working with, 1107–1108
SharePoint pages
customizing, 1143
examples, 1105, 1106
SharePoint Web sites
common examples, 1108–1111
definition, 1105
types of, 1106–1107
sharing over networks. See SharePoint.
Short Date format, 63
Short Time format, 63
Shortcut Menu Bar option, 1090–1091
Shortcut Menu Bar property, 311
Shortcut Menu property, 311
shortcut menus
defaults, specifying, 1090–1091
display, specifying, 1091
on forms, 311
ShortcutMenu property, 683, 704
ShortcutMenuBar property, 683
shortcuts, launching applications, 907–909
Show Table dialog box, 135–136, 138
Show Table Names option, 650
showing. See hiding/showing.
Single data type, VBA, 428
single primary keys, 118
single quotes (‘...’), criteria string indicator, 194
Single size numeric fields, 52
Single Step dialog box, 107452_475348-bindex.indd 133152_475348-bindex.indd 1331 4/1/10 2:02 PM4/1/10 2:02 PM