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

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Colin (anonymous_at_discussions.microsoft.com)
Date: 07/02/04 

Date: Fri, 2 Jul 2004 06:03:49 -0700

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

>-----Original Message-----
>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
>.
>

Quantcast