Hiding Database Window

[gold007eye]

I have my startup options set to not show the database window on startup, but what seems to be happening is when people click off of my pop-up forms and click on the database icon in the task bar the database window is re-appearing to where they can access all report, forms, tables, etc. Is there any code I can use to turn it off when someone closes a form or on a timer event?

 

[maxmangion]

check here Credits should go to ghudson.

 

[gold007eye]

Thanks a million. That's just what I needed

 

[krberube]

I have a quick question about GHudson's post for hiding the toolbars and DB window.

I wonder if GHudson could explain this statement a little bit before I start to fool around with this?
"Ensure that you have a way to unhide the menu bars and tool bars before you hide them!"

Do I have to setup something to do this??
Thanks
Kevin

 

[Argonak]

well, consider, you have an on open command on your starting form that locks you out of access's controls.

so, you won't be able to manually remove that code anymore. so you need to have a button that would let you turn it off.

 

[krberube]

ok, so just create a button with the code to enable them and thats all that would be needed?
I'll start fooling with it in a test DB.
Thanks!

 

[ghudson]

I have a quick question about GHudson's post for hiding the toolbars and DB window.

I wonder if GHudson could explain this statement a little bit before I start to fool around with this?
"Ensure that you have a way to unhide the menu bars and tool bars before you hide them!"

Do I have to setup something to do this??
Thanks
Kevin

Too many posters have found that code and used it to hide their toolbars then realized that they were stuck because they could not unhide them since they could not create a new control to assign the code to nor could they get back to the db window if they had disabled that option. Some of us learn these things the hard way.

 

[gold007eye]

What I did was created 2 modules.. 1 for toolbars on and 1 for toolbars off. That way I can control which ones turn on/off; and also I set up a shortcut key so that when you press (example: ctrl+z) it will run the code toolbars on so that you can then access your menus; I found that doing it this way makes it like a secret developers shortcut and then there is no need to create buttons to turn the toolbars on or off. Let the code do the work for you. I have the code set so that when my "main menu" loads it turns all toolbars off.