display database window command button

[eilime55]

I have created a switchboard for my database and would like one of the
command button options to be "Display Database Window." There is an example
of this in the sample database. The DW will be hidden, but I would like an
option to click on that button and enter an administrator's code or something
to access the database window. Could I do this with a macro? I am a beginner.

 

[Ed Robichaud]

A macro of "SendKeys" - F11 will display the database window.

 

[chris.nebinger]

Or:

http://www.mvps.org/access/general/gen0031.htm

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

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