early binding, 295, 324
Edited Record option, 317
elements
of applications, 11–12
running on different computers, 15
e-mails
generating empty, 415–416, 431
integrating into applications, 453, 454
sending from VBA code, 210–211
sending through Outlook from Access, 302–305
embedded macros, 2
empty forms for a user interface, 344, 475–481
empty record, adding to a recordset, 141–142
Enable this Content option, 34
Encode Database, 329
Encoding parameter
for the ExportXML method, 209
for the OutputTo method, 249
Encrypt with Password option, 327
encrypting a database, 329
end users, interviewing, 3–4
Ending Points in Activity Diagrams, 8
Enhanced Rich Text data type, 222
enumerated types, 122–123
EOF property of a recordset, 141
error handler, 73–74
error messages, 72, 77–78
ErrorHandlerLibrary database, 308, 311
error-handling code, writing, 71–78
error-handling procedure, 308
errors
debugging, 64–71
raising in code, 75
types of, 64–66
Errors collection, 75
event(s)
calling functions from, 45
calling sub procedures from, 36
common to objects, 84
creating, 113–115
declaring and raising, 114
defined, 79
described, 84–86
example using, 86–91
initializing and terminating, 115
as a SharePoint list, 221
event handlers. See event procedures
Event Procedure option, 85
event procedures
adding to a form, 143, 151
adding to handle recordset navigation, 144, 152
creating, 90
navigating through records, 444–445, 450
event sub procedures, 114–115
Event tab
from the cmdRun Properties window, 37
of the Properties dialog box, 84, 95
Excel
controlling from Access, 295–298
creating a new instance of, 295
Execute method, 132, 269, 517
execute-only applications, 331
ExecuteSPRetrieveRS function, 495–496
ExecuteSQLCommand procedure, 389–390, 404–405
ExecuteStoredProcedure procedure, 497
ExecuteStoreProcedure procedure, 517–518
Exit event, 86–87
Exit event procedure, 90
exporting
data using OutputTo, 211
defined, 200
ExportXML method, 208–209
Express Edition. See SQL Server 2005 Express Edition
Expression Builder, 84
eXtensible Markup Language. See XML
external applications, automating, 294–295
external data sources, 199–211
External Data tab, 200, 222, 223
external DLLS, 291–294
external function calls, 456–458
external functions
calling, 293
declarations to, 400
external library, 293
Extreme Programming, 3