• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 706
  • Last Modified:

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.
0
Rex85
Asked:
Rex85
  • 11
  • 9
1 Solution
 
andreyman3d2kCommented:
Did you try closing/opening the DB (and Access)?
0
 
Rex85Author Commented:
Several times
0
 
andreyman3d2kCommented:
I simulated your situation on my DB -- same result. Switchboard not showing up on the list. Fascinating.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Rex85Author 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
 
Rex85Author 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
 
Rex85Author 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
 
Rex85Author 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
 
Rex85Author 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
 
Rex85Author 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:
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:
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
 
Rex85Author 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
 
Rex85Author 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

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

  • 11
  • 9
Tackle projects and never again get stuck behind a technical roadblock.
Join Now