1283
Index
control totals, reports, 344–345
control variables, absolute speed, 864–865
controls. See also specific controls.
aligning, 275–277, 314
background color, 682
bound, 266, 285
categorizing, 264–265
copying, 281
custom ribbons, 1017
customizing ribbons, 1025–1026
data-entry forms, 22
definition, 264
deleting, 281
deleting groups, 279
deselecting, 272
disabling, 682
event procedures, modifying, 390–391
foreground color, 682
formatting, 462–463
forms, unsupported, 1175
graying out, 682
grouping, 278–279
hiding/showing, 463
labeling, 279–280
list of, 265. See also specific controls.
morphing, 695–696
moving, 271–272, 274–275
naming conventions, 285–286
overview, 264
positioning, 683
RecordSource property, 271
resizing, 273–274, 683
selecting, 271–272
SharePoint deployment issues, 1176
sizing handles, 271–272
snapping to the grid, 276–277
type, modifying, 270, 280–281
unbound, 266, 285
VBA event procedures, 459–460, 462–463
visibility, hiding/showing, 682, 684
controls, adding to forms
with the Controls group, 267–268
with the Field List, 268–271
overview, 266–267
controls, calculated
creating, 316
description, 266
editing, 296
updating tables, with VBA code, 513–516If...Then...Endif statements, 401–403
overview, 401
Select Case...End Select statements, 403–404
conditions for macro error handling, getting, 1073
conditions for macro execution
mcrReportMenu macro, example, 1062–1063
multiple actions, 1064
opening reports with, 1061–1064
confirming deletions
AfterDelConfirm event, 458–459
BeforeDelConfirm event, 458–459
MsgBox function, 470–471
Connect event, 464
Connect property, 600–606
connecting data. See join tables; table relationships.
connecting to data sources. See also binding.
ADO Connection object, 489–492
ConnectionString property, 491–492
connecting to SQL Server
from Access, 1203–1214
connection strings, 1201–1203
creating a data source, 1204
DSN, setting up, 1205–1211
File DSN, 1204
linking to tables, 1211–1214
ODBC configuration options, 1204
System DSN, 1204
User DSN, 1204
Connection object, 489–492
connection pooling, 1191–1192
connection strings, 1201–1203
ConnectionString property, discovering, 491–492
#Const compiler directive, 413–414
#Const directive, 535–537
Control Box property, 307
control menu
displaying on forms, 307
removing, 706
control properties
defaults, customizing, 681
GetProperty function, 685–686
getting, 685–686
control properties, setting
dynamically at runtime, 682–685
in Layout view, 312
overview, 284–285, 679–681
SetProperty function, 683–685
Control Source property, 284
control tip help, 69752_475348-bindex.indd 128352_475348-bindex.indd 1283 4/1/10 2:01 PM4/1/10 2:01 PM