Hide Database Window All the Time (VBA and Set Up Config groups)

  • Thread starter Thread starter Katrina
  • Start date Start date
K

Katrina

I have my database set up with a startup form that I want
users to use for navigating through the database.

I have it set up so that the form shows up in the
begining and that the database window is hidden upon
startup.

My problem comes in when users make a new query. I have
the database set up to open the query wizard on a button
click with the command
DoCmd.RunCommand acCmdNewObjectQuery

When the new query is created, the database window
becomes visible. Is there a way around this?
(Maybe a visible property of the DB Window)
Katrina
 
Hi Katrina,

Here is some code that you may want to try


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

To Hide the database window, run
Docmd.SelectObject acTable, , True
Docmd.RunCommand acCmdWindowHide
 
Thanks, that worked great.
-----Original Message-----
Hi Katrina,

Here is some code that you may want to try


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

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


.
Click to expand...
 
Back
Top