Microsoft Access 2010 Bible

Chapter 14: Debugging Your Access Applications 533 FIGURE 14.9 The Debug menu in the VBA code editor window contains valuable de ...

Part II: Programming Microsoft Access 534 you specify the correct number of options and in the right order. The VBA compiler can ...

Chapter 14: Debugging Your Access Applications 535 There are also some problems associated with MsgBox statements: l There is no ...

Part II: Programming Microsoft Access 536 continued The #Const directive you see in the preceding figure can appear anywhere in ...

Chapter 14: Debugging Your Access Applications 537 Using Debug.Print The second commonly used debugging statement is using Debug ...

Part II: Programming Microsoft Access 538 Unlike the MsgBox statement, you don’t have to do anything special to suppress the Deb ...

Chapter 14: Debugging Your Access Applications 539 One of the most basic uses of the Immediate window is to run code, such as bu ...

Part II: Programming Microsoft Access 540 Removing a breakpoint involves nothing more than clicking on the breakpoint indicator ...

Chapter 14: Debugging Your Access Applications 541 FIGURE 14.17 The Immediate window contains a lot of valuable information. Cod ...

Part II: Programming Microsoft Access 542 FIGURE 14.18 Insert a breakpoint near the location of the code you want to step throug ...

Chapter 14: Debugging Your Access Applications 543 In Figure 14.19, the break has occurred and I’ve clicked on the Step Into but ...

Part II: Programming Microsoft Access 544 FIGURE 14.20 Auto Data Tips are a powerful tool for debugging. The Auto Data Tips disp ...

Chapter 14: Debugging Your Access Applications 545 examine the results of the rs assignment statement. Unfolding the rs entry in ...

Part II: Programming Microsoft Access 546 Setting a watch is more complicated than using the Locals window or setting a breakpoi ...

Chapter 14: Debugging Your Access Applications 547 Figure 14.23 shows the Watches window in action. The sSQL variable is display ...

Part II: Programming Microsoft Access 548 FIGURE 14.24 A conditional watch halts execution when the expression CustomerID=99 is ...

Chapter 14: Debugging Your Access Applications 549 you’ll put the function into a single module, declare it with the Public keyw ...

Part II: Programming Microsoft Access 550 This chapter ends the section on VBA programming in Microsoft Access. You’ll see many ...

551 CHAPTER Using Access Data Macros IN THIS CHAPTER Creating data macros Understanding table events Building macros Understandi ...

Part II: Programming Microsoft Access 552 were equivalent in their capabilities, macros have always been considered inferior to ...