Microsoft Access 2010 Bible

Chapter 22: Integrating Access with Other Applications 813 FIGURE 22.13 Select the fields to add to the e-mail form; then set th ...

Part III: More-Advanced Access Techniques 814 FIGURE 22.14 Customize the e-mail message you’re sending. FIGURE 22.15 The resulti ...

Chapter 22: Integrating Access with Other Applications 815 Note These steps will vary if you make different choices from the one ...

Part III: More-Advanced Access Techniques 816 The Message Details section at the bottom of the form displays information about t ...

Chapter 22: Integrating Access with Other Applications 817 The Discard Replies from Those to Whom You Did Not Send the Message c ...

Part III: More-Advanced Access Techniques 818 To manually process each reply, you have to use Outlook 2007 or 2010. The replies ...

819 CHAPTER Handling Errors and Exceptions IN THIS CHAPTER Addressing logical and runtime errors Identifying which errors to tra ...

Part III: More-Advanced Access Techniques 820 Dealing with Errors We all have to deal with the errors that occur in our applicat ...

Chapter 23: Handling Errors and Exceptions .............................................................................. 821 Ru ...

Part III: More-Advanced Access Techniques 822 Other runtime errors may be less obvious and more difficult to deal with. For exam ...

Chapter 23: Handling Errors and Exceptions 823 FIGURE 23.2 Built-in error messages usually are not helpful. The error in Figure ...

Part III: More-Advanced Access Techniques 824 happens. The problem is that the code is doing the wrong thing, even though it’s e ...

Chapter 23: Handling Errors and Exceptions 825 Almost all error-handling routines in VBA programs require a three-step process: ...

Part III: More-Advanced Access Techniques 826 Note A VBA label is nothing more than an identifier (such as HandleError) followed ...

Chapter 23: Handling Errors and Exceptions 827 Caution The worst type of situation occurs when the values returned by the progra ...

Part III: More-Advanced Access Techniques 828 The Err object also has two methods: Clear, to clear information from the Err obje ...

Chapter 23: Handling Errors and Exceptions 829 Obviously, the Select Case construct is not the only way to handle multiple error ...

Part III: More-Advanced Access Techniques 830 Msgbox Err.Description Resume ExitHere End Function The On Error statement enables ...

Chapter 23: Handling Errors and Exceptions 831 here — HandleError and ExitHere — were chosen simply because of the obvious purpo ...

Part III: More-Advanced Access Techniques 832 In this example, the Kill statement is used to delete a temporary file that may or ...