Hide Database window via code

12 Jan 2006 6:37 PM

NewUserToAccess

Hi,

I am a new user to Access 2003. I was wondering if it possible to hide the
database window when one opens up Access. I have 3 forms in my Access
database. 1 is a Main swithboard that gives direction to the other 2 forms.
I know there is a way of doing this by the unchecking the box in the Tools,
but I was trying to see if there is a way to do it by code. What I mean is
when the Application opens up, I would like it to run the code that Hides the
database window. Please let me know if this can be done and if so what
"Event" would I use? Thanks in advance.

16 Jan 2006 11:28 PM

david epsom dot com dot au

To hide the database window at startup, go to Tools, StartUp,
and clear the 'display database window' check mark.

To hide the database window at some other time, select
an object in the window, then hide the selected window:

Docmd.SelectObject acTable, , True
Docmd.RunCommand acCmdWindowHide

(david)

Show quoteHide quote

"NewUserToAccess" <NewUserToAcc***@discussions.microsoft.com> wrote in
message news:1ECB84A7-FC67-4653-B423-A9F2A5F2AFE7@microsoft.com...
> Hi,
>
> I am a new user to Access 2003. I was wondering if it possible to hide
> the
> database window when one opens up Access. I have 3 forms in my Access
> database. 1 is a Main swithboard that gives direction to the other 2
> forms.
> I know there is a way of doing this by the unchecking the box in the
> Tools,
> but I was trying to see if there is a way to do it by code. What I mean
> is
> when the Application opens up, I would like it to run the code that Hides
> the
> database window. Please let me know if this can be done and if so what
> "Event" would I use? Thanks in advance.