How do I Recover/ Repair a "Messed Up" Main Switchboard

I renamed my main (default) switchboard and it wouldn't work. I then created a new switchboard and made it the default.

However, when I go to Access Options to have it automatically load the switchboard form, it doesn't list the swichboard. It doesn't list it under forms in the navigation pane either. I can only see it from the Switchboard manager.
RexQuality LeaderAsked:
Who is Participating?
 
andreyman3d2kCommented:
Trying to figure this out.. I think the issue might have to do with the macros that come with a switchboard. Try making a new DB and make a switchboard in it. When you go to design view on it, and go to the events tab, it has premade procedures, as well as other settings. I think that it might be possible to create a new form based on the "switchboard items" table, input the right properties, and have it behave like a switchboard. That's sort of a hunch though.
0
 
andreyman3d2kCommented:
Did you try closing/opening the DB (and Access)?
0
 
RexQuality LeaderAuthor Commented:
Several times
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
andreyman3d2kCommented:
I simulated your situation on my DB -- same result. Switchboard not showing up on the list. Fascinating.
0
 
RexQuality LeaderAuthor Commented:
I am at a loss....
0
 
andreyman3d2kCommented:
No wait, figured it out I think. Just choose Switchboard from the drop-down. it will automatically make the switchboard that is default come up when you close/open the db. In other words, the switchboard label will still be the only one there, but it will apply to the switchboard that you made the default.
0
 
RexQuality LeaderAuthor Commented:
Are you talking about the drop-down under Access options?
0
 
andreyman3d2kCommented:
Access options --> current Database --> Display form --> switchboard

that "Switchboard" is referring to whatever switchboard is set as the default.
0
 
RexQuality LeaderAuthor Commented:
That's the problem...It doesn't show up in that list. It only exists in the Switchboard Manager.
0
 
andreyman3d2kCommented:
do you have the option "Switchboard" on that list?
0
 
RexQuality LeaderAuthor Commented:
No. just all the other forms I created, but no Switchboard or Main Switchboard, or anything with the word switchboard in it.
0
 
andreyman3d2kCommented:
Oh I hear you. Okay I recreated the problem as well (renamed the switchboard, it didn't work, made a new one). Indeed the switchboard option was not on the list. Here's what it did for me -- It made a form called form1 which it for some reason minimized to the bottom of the window. I just saved it with the name switchboard, so now it shows up as that in the drop-down.
0
 
RexQuality LeaderAuthor Commented:
It made a form called form1 which it for some reason minimized to the bottom of the window

How did you do that? Just created a form?
0
 
andreyman3d2kCommented:
Okay, I think I really re-created what is going on now (3rd time's the charm). previously I renamed the switchboard in the switchboard manager, which gave me the Form1. Now I renamed it in the actual navigation pane.

Same situation now -- the form exists in the switchboard manager, but not anywhere else. Really bizzare.
0
 
andreyman3d2kCommented:
Do you have a table called switchboard items?
0
 
RexQuality LeaderAuthor Commented:
Yes. I created a form called switchboard from the previous switchboard table, and was able to make it load automatically, but no swichboards, even new ones, from the switchboard manager will load.
0
 
andreyman3d2kCommented:
Seems to be really complicated -- (probably because I have no idea what I'm doing). Have you considered just making a new DB, copying all of your objects into it (except the switchboard items table), and making a switchboard there?
0
 
RexQuality LeaderAuthor Commented:
Sorry. I was out today. Per your last comment...I am going to try that. I tried with importing the Switchboard table, and that didn't work....
0
 
RexQuality LeaderAuthor Commented:
Created a New DB on a different PC. Imported all Tables except the Switchboard. Then created a new switchboard. Thanks for your help.
0
 
andreyman3d2kCommented:
Excellent, glad it worked out.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.