Controlling the Database Window

[K Dales]

I have my project startup options set to hide the database
window. I would like (from VBA code) to be able to show
it. I know there is a StartupShowDBWindow property to
change the option on startup, but I have searched the
documentation (Access 2000) all over for a way to
programmatically unhide the database window during my
Access session. Anyone out there know how to do this?

 

[MikeC]

Here's one way to programatically display the database window.

SendKeys "{F11}"

I have read a number of posts where people have stated that SendKeys is
buggy and may not always do what you expect. This I can certainly believe.

I suppose another option could be to use an API call that programatically
presses the F11 key. The above has worked fine for me, so I have not yet
needed to develop another method.

You should also be able to use the "Unhide..." a menu option that activates
under the Windows menu if the the database window is hidden.

DoCmd.RunCommand acCmdWindowUnhide

This method displays a dialog box where the user then clicks on the OK
button to display the hidden window displayed as a list item in the dialog
box.

 

[Allen Browne]

SelectObject will show the database window if set the 3rd argument to Yes,
e.g.:

DoCmd.SelectObject acTable, ,True

 

[Guest]

Thanks Allen - works perfectly.

-----Original Message-----
SelectObject will show the database window if set the 3rd argument to Yes,
e.g.:

DoCmd.SelectObject acTable, ,True

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.




.