1282
Index
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
compatibility with older databases
converting old files, 32–33
Database Enhancement dialog box, 32–33
enabling obsolete databases, 32
overview, 31
Compile on Demand option
checking status of, 843
compiled state, 848–854
Options dialog box, 411, 530
overview, 843–844
turning off, 843
compiled state
creating, 849–850
distributing applications, 851–854
library databases, 851–853
library references, 851–853
losing, 850–851
overview, 848–854
storing code, 851–853
compiler directives, 413–414, 535–537
compiling
code, conditional compilation, 535–537
databases, 874–875
VBA code, 532–534
VBA procedures, 397
composite primary keys, 77, 118
compound controls, in reports, 356–358
compound object names, naming conventions, 40
concatenating strings
& (ampersand), concatenation operator, 173, 178–179,
188, 422
+ (plus sign), addition operator, 173, 179
Condition property, 1073
conditional compilation, 535–537
Conditional Compilation Arguments option,
413–414
conditional processing
Case Else clause, 404
definition, 401
Else statements, 402
ElseIf clause, 402–403
If...Then...Else...Endif statements, 401–403Compatibility Checker, SharePoint deployment (continued)
primary key constraints, 1175
query errors, 1176–1177
query join issues, 1177
relationship errors, 1174–1175
relationship issues, 1160–1161
report errors, 1175–1176
reports do not support events, 1176
reserved word collisions, 1177
running, 1157–1158
schema errors, 1178–1179
SQL statement problems, 1176
subqueries in queries, 1177
successful completion, 1163–1164
table field issues, 1179
table name issues, 1179
table relationships, 1174
Unique property problems, 1179
unsupported form controls, 1175
unsupported report controls, 1176
Compatibility Checker problems
attachment field limitations, 1178
AutoNumber data type problems, 1179
calculated field issues, 1178
control issues, 1176
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
primary key constraints, 1175
query errors, 1176–1177
query join issues, 1177
relationship errors, 1174–1175
relationship issues, 1160–1161
report errors, 1175–1176
reports do not support events, 1176
reserved word collisions, 1177
schema errors, 1178–1179
SQL statement problems, 117652_475348-bindex.indd 128252_475348-bindex.indd 1282 4/1/10 2:01 PM4/1/10 2:01 PM