1281
Index
Compact on Close check box, 1084, 1087
compacting databases
absolute speed, 855–856
on closing, 1087
with Compact and Repair button, 874–875
comparison operators
> (greater than), 177, 188
>= (greater-than, equal), 177
= (equal sign), equal, 176, 188
< (less-than sign), less-than, 177, 188
<= (less-than, equal), less-than-or-equal-to, 177
< > (angle brackets), not-equal, 176, 188, 198–199
list of, 176
precedence, 186
Compatibility Checker
See also bugs
See also debugging
See also error handling
See also testing
See also troubleshooting
Backstage area, 1158
data integrity, enforcing, 1162–1163
enabling Publish to Access Service button,
1139–1140
online help, 1160
running, 1157–1158
successful completion, 1163–1164
Compatibility Checker, SharePoint deployment
attachment field limitations, 1178
AutoNumber data type problems, 1179
Backstage area, 1158
calculated field issues, 1178
control issues, 1176
data integrity, enforcing, 1162–1163
field data type issues, 1178
form errors, 1175–1176
form event problems, 1175
general errors, 1174
incompatible custom field formats, 1179
incompatible fields, 1174
incompatible macro actions, 1177–1178
invalid expression errors, 1177
invalid query names, 1177
issues, displaying, 1158–1159
lookup errors, 1174–1175
lookup field issues, 1175, 1178
macro errors, 1177–1178
object name violations, 1176
online help, 1160Multiple Items, 253
Navigation Form, 252
Pivot Table, 253
PivotChart, 253
Print Preview, 249
Remove Sort, 243
on the ribbon, customizing defaults, 1020–1022
Select, 220
Selection, 243–244
Snap to Grid, 276–277
Split Form, 253
commands, Align Center
Datasheet ribbon, 220
Form ribbon, 293
commands, Align Left
Datasheet ribbon, 220
Form ribbon, 293
commands, Align Right
Datasheet ribbon, 220
Form ribbon, 293
commands, Copy
Datasheet ribbon, 220
Form ribbon, 292
commands, Cut
Datasheet ribbon, 220
Form ribbon, 292
commands, Gridlines
Datasheet ribbon, 220
Form ribbon, 293
commands, Paste
Datasheet ribbon, 220
description, 233
Form ribbon, 292
commands, Paste Append
Datasheet ribbon, 220
description, 233
Form ribbon, 292
commands, Paste Special
Datasheet ribbon, 220
description, 233
Form ribbon, 292
comma-separated values (CSV)
importing text files, 618–623
linking to, 596–597
comments
color coding, 419–420
forms, 311
common code base, 941
Compact and Repair button, 874–87552_475348-bindex.indd 128152_475348-bindex.indd 1281 4/1/10 2:01 PM4/1/10 2:01 PM