Hiding the database window

M

magmike

How would I code in the hiding of the database window upon a forms
loading. Although the database starts up without it, there is a button
available to unhide it using a macro to send the F11 key. However, if
there is an Access Special Key to re-hide it, I am not aware of it.

Thanks in advance for your help!
 
M

magmike

Select an object in the database window, then hide the window.  You don't
need the name of the object.  Put the code in the form's load or open event
procedure.

DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide

Chris
Microsoft MVP

How would I incorporate that into an IIf statement to only do it if
the database window is actually open?

My database is set to open with out it, but using that code, it now
unhides the database window so it can select a table in order to hide
it and the user sees it happen and I would rather them not if the
window isn't already open.

Is that possible?

Thanks!
magmike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top