Accidentally disabled all error messages

[charle525]

I think, while writing VBA code for error handling (or doing other work on my forms), I disabled all Access error messages. I am now trying to write a SQL query and no error messages pop up when there are errors in my syntax. Now, I can't figure out what exactly I did to cause this. Can anyone point me in the right direction as far as what to look for in fixing this?

 

[GoDawgs]

Open up the debug window and type in DoCmd.SetWarnings=true

That should solve it...hope that helps.

Kevin

 

[charle525]

Thanks, but I don't think that helped. The problem is taking place throughout the database, not just in my forms. Would your solution solve that? I tried, but no luck.

If I cause an error while writing a query in the query window (for example invalid SQL syntax), or with a table (for example using an invalid foreign key), no Access error message pops up like normal. I'm just left in that view, unable to save or change views until I fix the error. Any other ideas? Thanks.

 

[charle525]

Well, things are working now. I closed and re-opened the database. Still not sure what caused it.