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.
Listing 7.12 shows the declarations section of the modErrorHandling module.
Option Compare Database Option Explicit '-- Constants for how to handle the error. Public Const apTryAgain = 1 Public Const apExitApplication ...