Hide main access window

I have done this before but forgot how I did it.  I want my MDE file to open up only to a switchboard.  I do not want the access window opening up as well.

 By access window, I mean the window that you can view all your forms, queries, tables, reports, pages, macros, modules from.  
Lasers07Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
before you create the MDE, set the following from the mdb
from Access window
Tools>Startup
in the startup dialog window
select the Switchboard form from the Display Form/page drop down
uncheck Display database window

you can uncheck also the menus, toolbars that you don't want to show
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rey Obrero (Capricorn1)Commented:
you can also set the startup option in your MDE
0
ldunscombeCommented:
There may be a bit of confusion in terms here. The database window is the window that displays your forms, tables etc and can be hidden as capricorn suggests. If however it is the "Application Window" that you are referring to then that is not so simple.

Refer this EE post.
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10315183.html

Leigh
0
Lasers07Author Commented:
capricorn.. your first suggestion solved the problem.  

This is the code to do it programically incase anyone is interested.

On Error Resume Next
'to show the database window, run
    DoCmd.SelectObject acTable, , True
        DoCmd.ShowToolbar "Database", acToolbarYes
        DoCmd.RunCommand acCmdToolbarsCustomize
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.