Index

E

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