Can't get Access to display any error messages?

[raggajunglist]

Hi all,

Im running Access 2003 and for the life of me i cant find out how to get error messages back.
To be honest i dont remember ever turning them off, and if i ever use DoCmd.SetWarnings it for turning off SQL append/insert statements..
Is there somewhere (or is there some code) to turn them back on?
Does anyone know what i did so i dont do it again?

Thanks in advance..

M

 

[Guus2005]

perhaps if you have code you must remove the line:

on error resume next

In your code window (IDE) choose menu item Tools | Options tab General. Set the error trapping to "Break on unhandled errors".
To test it put in your code somewhere:

debug.print 1/0

if you didn't create an MDE, you can't get past this statement without getting an error message.
(When you create an MDE all debug.print statements are removed.)

HTH

 

[raggajunglist]

hmm strange.
i dont have the on error resume next in any bits of code.
i have the options in vba set properly also.
debug.print 1/0 gives the normal error.

Say for example there is a bit of code with an if statement but no end if. (or any obvious error that vba always traps)
the command button clicks, but no error pops up, nothing at all to suggest it didnt work except it does nothing. I rarely get any errors at all anymore.
Its really annoying as im trying to build complex code but have no kind of error trapping going on whatsoever.

thanks.

mike

 

[RuralGuy]

Try importing your db into a new, fresh, empty db and see if you still have the same problem.