No matter what I do the database window opens

G

Guest

I've unchecked the box show database window, I've hidden all the objects
except the switchboard but the database window still opens when access
opens...how can I make only the switch board available to view and use?
 
J

Jeff Conrad

I'll take a swing at this and see if I can get a hit.

I'm guessing you are using the built-in Switchboard Manager.
The Switchboard Form's Open event probably has some code similar to this:

DoCmd.SelectObject acForm, "Switchboard", True
DoCmd.Minimize

This code will minimize the Database Window, however, it will override any
setting you have in the Startup Properties to hide the window.
So find those two lines of code in the form's code module and delete them.
Everything should be just peachy then.
 
J

Jeff Conrad

Well just as we cut to commercial I tripped rounding second base and did a face plant. Then I was
tagged out.
Drat!!

;-)
 
J

Jeff Conrad

LOL!!
Well thanks Gunny!
A very nice crowd we have around here.
(At least there is no chair throwing)

:)
 
6

'69 Camaro

(At least there is no chair throwing)

That was last night. You missed it!

(Requires speakers)


http://makeashorterlink.com/?W25A223E9



http://makeashorterlink.com/?V26A423E9



http://makeashorterlink.com/?G6CA323E9



http://makeashorterlink.com/?U5DA123E9



http://makeashorterlink.com/?V18A533E9



http://makeashorterlink.com/?U1AA263E9


Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
G

Guest

Jeff,

Pardon me for disturbing the celebrations, but I had the same problem and
searched all through my code for lines similar to the ones you mentioned. I
found none; in fact I don't use the switchboard manager. I continue to get
the database window showing up in the background even after following all the
instructions.

I tried creating a new blank database and importing all my tables, forms,
queries and codes into that but to no avail.

Could there be something else I'm missing?
 
G

Guest

Jeff,

Not quite there yet. I tried unchecking the "Windows in Tasbar" checkbox as
directed with no effect. I'm hooped I guess since I have Access 2000
(9.0.6926 SP-3), and no Office XP. So obtaining the latest Office XP
service pack doesn't apply to me. Mabe there's a service pack for my
installation; I am checking.

For some soothing sounds, you might enjoy http://www.boohbah.com/zone.html
 
J

Jeff Conrad

Hi Stan,

If you have Service Pack 3 for Office 2000 you *should*
be up to date. However, there is no harm in going to Office
Update and checking.

The only thing I can suggest is to open a code module and
search the entire database (Edit | Find) for the following
string:

DoCmd.SelectObject

We're looking for code *similar*, but not exact to this:
DoCmd.SelectObject acForm, "Switchboard", True

Does the Database Window appear immediately upon
opening the database or only after opening a certain form,
running a macro, running some code, etc?

I should probably state the obvious. You did uncheck
the option under Tools | Startup, correct?
 
G

Guest

Ran Office Update and got notification on 6 security updates only. Nothing
in terms of new functionality related to what I am after; but I will chase
our IS dept. to bring the Office CD's and download these anyway.

I have entered the keyword "switchboard" in a text search command on the
whole project and nothing was found. I even searche in Object browser but I
don't think that's what you meant.

I have user and group security in place which means I see the database
window in background and the user login and password as soon as I
double-click the database file. The deployed database works off of a desktop
icon; maybe I should simulate that too. But yes the database window appears
immediately.

I have reviewed my settings repeatedly in Tools - Startup and am going to
pull a Howard Hughes (saw the Aviator last night). Tools - startup, tools -
startup, tools -startup... Excuse my frustration..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide Database Window 5
hiding database window 3
How to Enable the Database Window 4
Hide Database window via code 1
Need to get Database Window visible again... 3
No exclusive access 4
How do I lock the unhide database window menu option? 11
Automatically minimize the Database window when Switchboard opens 2

Top