Show/Hide DB window

[martiros]

Is there a way in code to show DB window which is set to be hidden on Startup?

Thanks

 

[BillPower]

I try to avoid SendKeys, but I can't find a Method or Constant to show the DB window:

SendKeys "{F11}"

Bill

 

[Norris68]

The best you can do is:
RunCommand acCmdWindowUnhide
...which will bring up the unhide dialog. You could probably add a SendKeys " " if the database window is the only hidden window. You will get a RTE if no windows are hidden.

 

[martiros]

thank you,
SendKeys "{F11}" does the job.
Is there a way to hide it again with SendKeys ?

 

[BillPower]

Hi again,

Not in code, it would have to be done manually during the current session. Window>> Hide.

Don't worry though, it will be hidden the next time you open the DB.

Bill

 

[d4446]

To show the database window
Docmd.SelectObject acTable, , True

To Hide the database window
Docmd.SelectObject acTable, , True
Docmd.RunCommand acCmdWindowHide