• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 7. HANDLING YOUR ERRORS IN ACCES... > A LAST LOOK AT ERROR-HANDLING ISSUES

A LAST LOOK AT ERROR-HANDLING ISSUES

The following sections cover some of the issues to watch for when creating error handlers for your routine. Watching for issues such as environment switches and knowing how to handle transactions correctly can save you from many hassles later.

Watching for Environment Switches

When setting Echo off, HourGlass on, and SetWarnings off in your routines, be sure to toggle them back to the way you want them in your error handler. These environment settings affect what happens in the application's environment. This is a good reason for using a label to exit your routine and placing these commands in the code to toggle the settings as necessary. Listing 7.18 shows an example.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint