open file to switchboard

  • Thread starter Thread starter Guest
  • Start date Start date
G

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 :-)
 
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
 
Thanks for your reply. However, where do I find the switchboard form's Open
event procedure? Sorry, I'm kinda new to Access.
 
Back
Top