Switchboard disappears

[Lori F.]

Hi, can you help?

I created a Switchboard (SB) with Switchboard Manager (SM), made it my
default and told Access to open it when the database was opened. I went into
its Design mode and adjusted the size of one box (trying to change the font
size). The box disappeared. Then, the whole SB disappeared from the database
window. But, it's still listed in SM (I can edit it and everything). I've
tried to rename it, but that didn't work. I tried to create a new one and
make it the default and autoopen, but it also won't show in the database
window and when I open the database, it says the SB doesn't exist. So,
basically, SM says I have a SB, but I can't find it anywhere.

Any suggestions?

 

[Clifford Bass]

Hi Lori,

A Switchboard consists of both a form (Switchboard) and a table
(Switchboard Items). Is it possible that you hid the Switchboard form? In
Access 2003 or earlier go to Tools, then Options. Choose the View tab and
make sure Hidden objects is checked. If it has been deleted you could try
renaming the table to something different. Then see if the Switchboard
Manager will recreate both the form and table. Do no editing in the manager.
Delete the new Switchboard Items table and rename the old one back to
Switchboard Items.

Hopefully it will be functional.

Clifford Bass

 

[Lori F.]

Hi, Clifford,

Thanks so much for your help. The Hidden feature was not enabled, so I
enabled it and the Switchboard still doesn't show up in the Database window
(although I didn't know about the Switchboard table and, yes, that does show
up there). I had 2 Switchboards in Switchboard Manager (they are identical
except for the names) and I made the other one default (and went back to the
Switchboard Items table and, yes, the correct table was also now the default).

Next, I deleted the Switchboard Items table as suggested. I tried to open
Switchboard Manager and it asked to create a table, which I said yes, to. I
then created a new switchboard, had it open at Startup and, voila! It worked!

Thank you so much for your help!

Another quick question: How do I ask it to open the Switchboard as a
maximized window?

Lori

 

[Clifford Bass]

Hi Lori,

Glad to help.

Add a DoCmd.Maximize line to your switchboard's Form_Open code. That
should do the trick.

Clifford Bass

 

[Lori F.]

Thanks, Clifford! I'll try it on Monday.

Lori

Hi Lori,

Glad to help.

Add a DoCmd.Maximize line to your switchboard's Form_Open code. That
should do the trick.

Clifford Bass

Hi, Clifford,
[snip]

Another quick question: How do I ask it to open the Switchboard as a
maximized window?

Lori