Where did my error messages and properties window go?

[nickthompson]

Hi folks

I've been coding with Access for years, but recently think I must have changed a setting somewhere and can't figure out what I've done. Whenever my code experiences an error it just stops processing code - no error messages or anything.

I used to get a standard dialog box pop up with the error message, and options to debug or end the code. I now never see that dialog box. The code just stops processing, and I have to try and work out what line it went wrong on!

Further strangeness (related?) is I've now lost my Properties window as well and even selecting 'Property Sheet' from the ribbon doesn't help (I'm in Access 2010)

I do have multiple monitors but have closed all apps to make sure these missing elements aren't appearing somewhere on the other screen.

Both problems are now common to all databases I work on.

Recently before this happened I was fiddling with code to hide the navigation pane and minimise the ribbon. Probably unrelated but thought I'd mention it.

Thanks for any help... this is really slowing my work down!!

Nick

 

[JHB]

Recently before this happened I was fiddling with code to hide the navigation pane and minimise the ribbon. Probably unrelated but thought I'd mention it.

I think it is properly the cause why you get the problems.
Maybe the link could give you some hint.
http://www.access-programmers.co.uk/forums/showthread.php?t=136432
Else try Googling "lost my Properties window+ms-access"

 

[nickthompson]

Thanks JHB. The 'safe mode' trick has brought back my Properties window. I thinkit was indeed related to the Properties window being considered part of the CommandBars collection. I'd been using 'DoCmd.RunCommand acCmdWindowHide' to hide the navigation pane.

Regarding my other problem, I still can't get the error messages up or find any articles that describe this problem. I should have mentioned that these two problems crept in a few days apart, so are probably different causes.

I have tried explicitly setting SetWarnings to True.

Any other suggestions?

 

[JHB]

Try to run some code with the above code line in it:

DoCmd.SetWarnings True

 

[nickthompson]

Yep, that was the first thing I did!

So for example, I can put the following in a Form Load event:

    DoCmd.SetWarnings True
    TriggerError

'TriggerError' is not defined, so should force an error box to pop up. I don't have any On Error line in the function. Yet I don't get an error box.

This is not just for one database - I can restart Access and open a different database and still have the issue. So it seems to be saved in the environment, not the database.

 

[JHB]

Y

    DoCmd.SetWarnings True
    TriggerError

'TriggerError' is not defined, so should force an error box to pop up. I don't have any On Error line in the function. Yet I don't get an error box.

It will only trigger an error if you have "Option Explicit statement" set, else not.