Microsoft Access 2010 Bible

Chapter 13: Accessing Data with VBA Code 513 The rsCustomers.Close statement near the end of the Form_AfterUpdate procedure clos ...

Part II: Programming Microsoft Access 514 A single event can handle recalculating the tax amount when new line items are added o ...

Chapter 13: Accessing Data with VBA Code 515 At the end of the procedure, txtTaxAmount is set to the curTaxAmount value. When th ...

Part II: Programming Microsoft Access 516 FIGURE 13.19 Recalculating a control after a record is deleted The AfterDelConfirm eve ...

Chapter 13: Accessing Data with VBA Code 517 Adding a new record You can use ADO to add a record to a table just as easily as up ...

Part II: Programming Microsoft Access 518 Note Notice that you don’t follow the Delete method with Update. As soon as the Delete ...

Chapter 13: Accessing Data with VBA Code 519 In a one-to-many relationship each child record (in tblSalesLineItems) must be rela ...

Part II: Programming Microsoft Access 520 strSQL holds a SQL statement for locating and deleting records in tblSalesPayments wit ...

Chapter 13: Accessing Data with VBA Code 521 intAnswer = MsgBox(“Are you sure you “ _ & “ want to delete this invoice?”, _ v ...

Part II: Programming Microsoft Access 522 You’ll see many other examples that use ADO and DAO to manipulate data in Access table ...

523 CHAPTER Debugging Your Access Applications IN THIS CHAPTER Verifying an application’s features Identifying where errors come ...

Part II: Programming Microsoft Access 524 Cross-Reference Chapter 23 contains valuable information about adding error handling t ...

Chapter 14: Debugging Your Access Applications ....................................................................... 525 Maybe ...

Part II: Programming Microsoft Access 526 FIGURE 14.1 The Editor tab of the Options dialog box contains a number of important VB ...

Chapter 14: Debugging Your Access Applications 527 FIGURE 14.2 Automatic syntax checking can save you from simple bugs. Fixing s ...

Part II: Programming Microsoft Access 528 A common bug in applications with poor control over variables occurs when a variable i ...

Chapter 14: Debugging Your Access Applications 529 FIGURE 14.4 Auto Quick Info provides syntax reminders in the module window. A ...

Part II: Programming Microsoft Access 530 FIGURE 14.6 The Options dialog box’s General tab contains some valuable options. Remem ...

Chapter 14: Debugging Your Access Applications 531 FIGURE 14.7 Putting multiple declarations on one line makes finding a variabl ...

Part II: Programming Microsoft Access 532 FIGURE 14.8 Single-variable Dim statements are easier to work with than several variab ...