Hide Database Window on Startup

[Allan Skyner]

I have unchecked the "Display Database Window" checkbox on the
Options/Startup menu, however the database still shows and immediately
minimises when I startup my database.

Any suggestions would be very welcome as I want to really hide this window
and maybe only have it shown if I press F11.

Best regards

 

[Ofer]

Check this link on hiding the database using VBA

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

 

[Dirk Goldgar]

I have unchecked the "Display Database Window" checkbox on the
Options/Startup menu, however the database still shows and immediately
minimises when I startup my database.

Any suggestions would be very welcome as I want to really hide this
window and maybe only have it shown if I press F11.

Do you have a switchboard form? You may have code in this form's Open
or Load event that selects the database window and minimizes it. That
will make it visible, even if it was previously hidden.

If that's the problem, just remove that code.

 

[David]

Did you by any chance create the database by using one of the templates that
came with Access?

If so, what's probably happening is that some of the code built into the
Switchboard form of the template is in effect overriding your unchecking of
the "Display Database Window".

Most likely, you'll need to go into the VBA code behind the form, and find
in the form's Open event the following code:

' Minimize the database window.
DoCmd.SelectObject acForm, "Switchboard", True
DoCmd.Minimize

Comment out the DoCmd actions by putting a single quote at the beginning of
the line, so that it looks like:

' Minimize the database window.
' DoCmd.SelectObject acForm, "Switchboard", True
' DoCmd.Minimize

Hope that helps!

David

 

[Allan Skyner]

Cheers David, this was spot on.

Did you by any chance create the database by using one of the templates that
came with Access?

If so, what's probably happening is that some of the code built into the
Switchboard form of the template is in effect overriding your unchecking of
the "Display Database Window".

Most likely, you'll need to go into the VBA code behind the form, and find
in the form's Open event the following code:

' Minimize the database window.
DoCmd.SelectObject acForm, "Switchboard", True
DoCmd.Minimize

Comment out the DoCmd actions by putting a single quote at the beginning of
the line, so that it looks like:

' Minimize the database window.
' DoCmd.SelectObject acForm, "Switchboard", True
' DoCmd.Minimize

Hope that helps!

David