PDA

View Full Version : No Debug Option



James Webb
08-07-2009, 07:19 AM
I'm currently writing some code for Access and when VBA errors are occuring I get a standard windows message box with only an 'OK' option rather than the 'Debug' or 'End' message box. This means that I can't jump to where the error is occurring in my code.

I can only assume this is related to a setting I've chnaged or code i've written but I've no idea what. Can anyone help?

Oorang
08-07-2009, 01:24 PM
Is it possible you are working with a database in the MDE file format? If an exception is thrown in an MDE it will exhibit that behavior. (If that is indeed the case and you are modifying the database you need the original mdb anyway.)

CreganTur
08-10-2009, 05:12 AM
Are you using the "On Error GoTo..." error handler method? If you are, and if you have a universal error handler setup, then this could cause what you're experiencing.