Bug? Hidden Database Window won't stay Hidden...

[TinaS]

Hey all - this is a cross post - sorry -

Just trying to find out why the database window will not stay hidden in my application and if it's a bug that someone knows about.

I've disabled bypass keys, hidden the db window, and it doesn't show up until I hit an error of some kind - basically a good example is when the user goes to print a report - on no data I cancel the event and handle the error - but the hidden db window appears. It appears with every error that occurs even when handled. I can't figure out why it stays hidden until this happens and was hoping someone could provide some insight. It's been a couple of years since I programmed heavily in access - so I may just be missing a simple setting somewhere. Any thoughts?

Thank you!

Tina

 

[TinaS]

found a work around:

Select any object in the database window and hide the DB window from there:

DoCmd.SelectObject acForm,"MyForm",True
DoCmd.RunCommand acCmdWindowHide

This takes care of the problem in a slightly messy way - the database window still flashes as it displays for that split second before being hidden again - I just wish I knew why it was doing this and could make it NOT happen, rather than clean up when it does... sigh...

thanks!

Tina

 

[Hap007]

Dear Tina,

Not sure why you are seeing this, but

If you have split your application into a FrontEnd and Backend, then...

Create an 'mde' file for your users. If you set the database window to not show, then any error will not bring up a code window since code is not available in an mde.

Hope This Helps,
Hap...

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Add-on Solutions
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121

 

[TinaS]

Hap -

Thanks !! I found that it is happening with ANY error I get - and I'm stuck trying to decide if I want to add code to each and every error event to hide the DB window - what a pain.

I was avoiding making an MDE but I might just do it - there's only a handful of people using it - but an MDE might be the best bet..

Thank you so much!

Tina