I have a strange error that I hope someone here can help with. I have been programming in VBA for quite some time and have not seen this one.
The scenario is this:
1. Access 2007 (SP1) database w/switchboard
2. Bring up a form that I can filter
3. Print the filtered list
Sounds simple. When the database is in development mode (accdb) the printing works fine. As soon as I put it into runtime mode (rename to accdr) the filtered list prints and the the generic error message comes up.
Execution of this application has stopped due to a run-time error.
The database then closes itself.
I am unable to capture because it doesn't happen in development mode.
Few questions.
1. How can I log the actual error into say Event Viewer
2. What could be different between development and runtime mode?
3. What else can I do to trap the actual error.
Typically I get an error in development mode and runtime mode. Then I just throw a breakpoint in figure out where I made my mistake.
Any help would be apprecitated.