How to Unhide database window using code 2

[mikemck7]

Hello,

I've unchecked Tools > Startup > Display Database Window to hide the database window when my form is opened. Now I would like to unhide the database window immediately as the form is closed or just prior. I use [tt]DoCmd.Close[/tt] in a command button to close the form. What code can I preceed this with to unhide the database window just prior to closing the form.
Thanks,

Mike

 

[VBslammer]

SendKeys "{F11}"

VBSlammer

"You just have to know which screws to turn." - Professor Bob

 

[VBslammer]

You can also select a known object in the database window to make it unhide itself:

[tt]DoCmd.SelectObject acTable, "MyTable", True[/tt]

The last argument forces it to show in the database window.

VBSlammer

"You just have to know which screws to turn." - Professor Bob

 

[VBslammer]

Just to be thorough, you can use an empty string as the object name and the window will open to the type of object specified without having to know the actual name of an existing object:

[tt]DoCmd.SelectObject acForm, "", True[/tt]

VBSlammer

"You just have to know which screws to turn." - Professor Bob