Hide Access Window

[andrewneal]

I noticed that there were several threads about hiding the Access Window and have read through them all... It seems like it would be something that I could use, but I can only get it to "grey out" the access window. It will not allow me to click on anything but the form itself (which is good), but the access window is still visible. The form is floatable between my dual monitors and everything else works properly , but the Access window is still visible. Any suggestions?

 

[mhartman]

Hello:

As far as I know, you can hide the database window within Access but not the Access window itself.

Regards
Mark

 

[vbaDev]

No, you can also actually hide the Access window, you have to search for apiShowWindow function. I'm not going to describe it, it's available on MSDN and on the Access Web.

For the method to work the calling form must be in both MODAL and POPUP mode.

The only drawback: once hidden, none of the Access objects appear in the taskbar (but can be closed from the Task Manager by ending the Access process). So they suggest having strong Error Handlers, all of which also restore the Access window so it doesn't stay hidden.

On my form I have a check box (hide/show Access).

I did notice an interesting feature, though: When I first change the form from nonModal and nonPopup to Modal and Popup (in design view) and then run it, when I click to hide the Access Window, both Access and the Form appear in the Windows Task bar. I am now trying to come up with code that would force that "event" every time. That way it would be a very classy way of designing applications - user's don't even see Access, only the App screen and they can switch to other programs and back.

I also have a Quit App button on my form (obviously) so that the users can close application (and Access).

I wonder if this is an undocumented, unintended feature in Access 2000 and maybe it could become a real feature. It sure is useful.

 

[sapala]

I have problem with hiding access window. Hiding will work great and everything works great but when i want to open my database normal, altought i press CTRL during opening , it doesnt work... does anybody know, what i have done wrong and what i can do next?

 

[boblarson]

Open it while holding Ctrl + F11 and it should open regular for you.

 

[sapala]

Doesn't work anything other combinations?

 

[sapala]

Right key was SHIFT

 

[boblarson]

ah thanks, sometimes I forget which one as I don't typically need to use it. Thanks for posting back with your success.