1333
Index
# (pound sign), wildcard character, 181
? (question mark), wildcard character, 181
[ ] (square brackets), pattern indicator, 181
Like (similar strings), 179–180, 181, 188
[list], wildcard character, 181
[!list], wildcard character, 181
list of, 178
Not Like (dissimilar strings), 179–180, 188
wildcards, 181
strings, concatenating
& (ampersand), concatenation operator, 173, 178–179,
188, 422
+ (plus sign), addition operator, 173, 179
strings, maximum length, 429, 949
Structure and Data button, 86
Structure Only button, 86
Structured Query Language (SQL). See SQL (Structured
Query Language).
Style property, 702
Sub-Address property, 66
Subdatasheet Expanded property, 308, 653
Subdatasheet Height property, 308, 653
Subdatasheet Name property, 652
subforms. See also forms.
embedding, 258–259
linking to parent forms, 686–687
overview, 686–688
properties, setting, 687
within subforms, 688
submacros
Data Mode argument, 1061
expanding/collapsing, 1059
Filter Name argument, 1060
Form Name argument, 1060
implementing, 1060
for mcrMainMenu macro, 1058
OpenContacts, 1058
OpenForm action, 1060–1061
OpenProducts, 1058
OpenSales, 1058
overview, 1057–1058
View argument, 1060
Where Condition argument, 1061
Window Mode argument, 1061
subprocedures, VBA, 388
subqueries, 134, 1177
subroutines
versus functions, Windows API, 946
VBA, 380SQL Server objects
stored procedures, 1219–1221
tables, 1215–1217
triggers, 1221
views, 1217–1219
SQL statements
; (semicolon), end-of-statement indicator, 484
maximum length, 484
problems, 1176
spanning multiple lines, 476
viewing, 474–475
square brackets ([ ])
around field names, 476–477
pattern indicator, 181
referencing fields, 192–193
table and field name notation, 174
ss:, formatting seconds, 64
standard deviation, calculating, 657
Standard format, 61
standard modules, 389–390
start-up bypass, disabling, 924–927
Startup dialog box. See Current Database options.
start-up option properties, 924
start-up options, 909–912, 923–924
start-up screen, 26
statement continuation, VBA, 418–419
static linking, 940. See also early binding.
status bar, displaying, 1086
StDev option, 657
Step Into button, 543
Step Out button, 543
Step Over button, 543
stepping through code, 543–544, 1074
Stop statements, 542. See also breakpoints.
StopMacro action, 561, 1074
stopping for errors, 411, 529
stopping macro execution, 1074
stored procedures
server database engines, 1188
SQL Server, 1219–1221
storing code, 851–853
String data type, VBA, 428
string operators
& (ampersand), concatenation operator, 173, 178–179,
188
* (asterisk), wildcard character, 181
“...” (double quotes), around returned strings, 178- (hyphen), range indicator, 181
52_475348-bindex.indd 133352_475348-bindex.indd 1333 4/1/10 2:02 PM4/1/10 2:02 PM