only showing Switchboard on startup

[Kathryn]

I would like only the main switchboard to be visible on start-up but at the
moment a "Contacts list" form (inherited from the Contacts template in Access
2007) appears on a second tab (I'm not at ths stage of wanting it full-screen
yet - though that will come).

I have followed the instructions found on the boards:
Office button > Access Options > Current database but there isn't anything
that I can see related to startup.
In Display Form, I have selected "Switchboard" from the drop down list but
can't see any way of unselecting Contacts List.

Is there a way to "lose" the Contacts List" at startup? (Preferably nice and
simple!)

Many thanks

 

[Jeanette Cunningham]

Does your switchboard have tabs on it?
If yes, then make a copy of the switchboard for later use.

On the original switchboard delete the page of the tab control with the
Contacts List.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Kathryn]

Hi

The switchboard itself has checkboxes.

When I start Access two tabs appear - Switchboard and Contacts List. When I
then open, say, the Contacts Form that also appears as a tab... and so on as
I open/ close tables/forms/reports, etc.

I'd ideally like just the Switchboard to open at startup so that other users
have an easier interface to start trying things out as I set them up.
Eventually, I will have it so that the switchboard is maximised and that is
all they see. (I'm still very new so at the moment feel happier having all
the Navigation visible for myself)

Does that make sense?!

Many thanks

 

[Jeanette Cunningham]

You wrote "2 tabs appear".
I was thinking of a form with a tab control.
Now I am thinking that you mean 2 separate forms with their own tab at the
top as can be done in A2007.

The contacts list will open if some code or a macro calls it to open.
Check the auutoexec macro (if you have one) to see if that opens the contact
list.
Check the code on the switchboard to see if it has code that opens the
contact list.
Check the code on a startup form if you have one to see if it has code that
opens the contact list.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Kathryn]

Thanks Jeanette - yes it was 2 separate forms (sorry not have been clearer -
very much a new user!)

However, I found the AutoExec and it did open Contacts List. I deleted the
entry (making a note of what it said in case it all went horribly wrong!) and
reopened the database which now just opens with the switchboard tab - which
I'm happy with for the time being.

Many thanks again!

 

[Rita Julien]

You are on the right track...after clicking current database there is a drop down box next to display form Switchboard should be in that drop down list.