Index

calling a procedure with hard-coded, 58

preserving after a procedure ends, 45

returning from function procedures, 44

using variables and constants to store, 49–56

declaring and using, 51–53

declaring in functions, 44

defined, 33

evaluating multiple times, 59

making visible in any module, 54–55

naming conventions for, 55–56

scope and lifetime of, 54–55

standardized way of naming, 55

storing the number of loop iterations, 62

types of, 49–51

adding a password for, 328–329

basics of writing and testing, 27–78

handling data validation from, 196

linking to another database, 319

optimizing to improve performance, 323–324

responding to events, 84

sending an e-mail from, 210–211

using to link, import, and export, 199–211

working with controls, 187–195

working with reports from, 235–248

writing behind report events, 247

writing for the business logic and database access logic, 18

calling from another procedure, 35–36

creating, 33–35

Activity Diagram for, 8, 10

prototype for, 11, 12

Use Case Diagram for, 5, 7

displaying a customer record on, 515, 516

opening independently of the Customer Search screen, 517

prototype for, 464–465

advantages of, 271

creating, 273–274

hiding and redisplaying forms, 325

of the objExcel object, 295

setting to False, 186

setting to True, 291

creating Activity Diagrams, 8

generating prototype screens, 336

for Access 2007, 2

display of, 19, 20

opening, 37, 38

opening with a new empty procedure, 85

running and debugging code in, 24–25

sample module displayed, 27–28

writing VBA code in, 18–23