open file to switchboard

[Guest]

I'd like to have my Access file open automatically to the switchboard. When I
go to Tools, Startup on the menu bar it allows me to set the start up to
switchboard, but the main database page opens as well. Do I have to create a
macro to open the file to the switchboard; then minimize any other windows?
And, if so, how do I do this? Any help/suggestions offered are greatly
appreciated. Thanks

 

[Guest]

You can either hide the database window by unchecking the 'Display Database
Window' checkbox in the start-up dialogue, or you can minimize it at start-up
by putting the following in the switchboard form's Open event procedure:

DoCmd.SelectObject,acForm,Me.Name,True
DCmd.Minimize

The first line selects the form in the database window. The second then
minimizes the window.

Ken Sheridan
Stafford, England

 

[Jeff Conrad]

See this section of my SBM page:

http://home.bendbroadband.com/conradsystems/accessjunkie/switchboardfaq.html#window

Try the "Second possibility" first.
--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:

 

[Guest]

Thanks for your reply. However, where do I find the switchboard form's Open
event procedure? Sorry, I'm kinda new to Access.