O'Reilly logo

F. Scott Barker's Microsoft® Access 2000 Power Programming by F. Scott Barker

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

TRACKING ERRORS BY USING A CUSTOM ERROR LOG

One thing that users have a hard time doing is remembering what they were doing when an error occurred. By creating an error log, you can track errors as they happen and program to deal with them the next time around.

Before creating an error log, you need to set up a few constants and variables. Both the constants and the error log routine, ap_ErrorLog, are found in the modErrorHandling module.

The Declarations Section for Error Log Routines

Listing 7.12 shows the declarations section of the modErrorHandling module.

Listing 7.12. VideoApp.mdb: Error Log Routine Declarations
 Option Compare Database Option Explicit '-- Constants for how to handle the error. Public Const apTryAgain = 1 Public Const apExitApplication ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required