Select case statements, 39–40
See alsoconditional statements
Select query, 154–156
See alsoSQL queries
semaphore files, 340–341
SendKeys command, 62–66
Series Collection object, 236–237
SetFocus method, 204
SetWarnings method, 217–218
shadowing, 17
single stepping, 85
SQL queries
Append query, 159–161
Delete query, 157–158
Make Table query, 158–159
overview, 149
pass-through queries, 246–248
Select query, 154–156
Union query, 156–157
Update query, 161–163
updating, 294–295
using custom functions within,
163–164
using the Query Design window,
150–154
See alsoqueries
Sqr function, 50
Static keyword, 17
Static statements, and local variables, 15–16
statistics, 305–306
stepping through code, 84–86
Stop statements, 84
strict variables, 17
string data types, 21–22
See alsodata types
strings
changing the appearance of, 47–48
concatenation, 46
overview, 45
searching, 48–49
splitting strings, 46–47
subforms, 102–104
See alsoforms
subroutines
vs. functions, 28–29
public or private, 32
writing a simple subroutine, 29–30
SysCmd object, 200T
Tab Control, 110
table macros
creating, 165–171
overview, 165
Table Macro window, 167
TableDef objects, 176, 189–190
TableDefs collection, 207
tables
communicating with, 186–190
creating a simple table, 313–314
creating indexes, 315–316
deleting, 298–299, 314
monitoring statistics, 305–306
See alsofields
temp, 17
TempVal, 14, 15
text files, large, 307–311
Time function, 57
transactions, 188–189
TransferSpreadsheet method, 180–181, 218
TransferText method, 218–219
Type keyword, 24–25
Type Mismatch errors, 73U
UCase, 47–48
Undo method, 204–205
Union query, 156–157
See alsoSQL queries
Update method, 211
Update query, 161–163
See alsoSQL queries
user names, identifying, 289–290
See alsoauthorized users
user security levels, 355–357
user-defined formats, 54
user-defined types
See alsodata typesV
Val function, 52
variables
explicit declaration, 14–15
global variables, 15, 17
implicit declaration, 14372 Microsoft Access 2010 VBA Macro Programming