MS Access: Switchboard form will not open when db is opened

James Coats
James Coats used Ask the Experts™
on
I have created a switchboard but I can't seem to get it to open. I have tagged it as the default but still no luck.
Instruments5-11-11.mdb
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016

Commented:
did you set switchboard as the display form from

tools > startup
Top Expert 2016

Commented:
what is the name of the form?
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
You have a Switchboard table, but no Switchboard form

mx
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Most Valuable Expert 2014

Commented:
Your form got lost.
No Biggie
Go to your tables
Rename 'Switchboard Items' to 'Switchboard Items Old'
Go to tools|switchboard manager.
Create a new switchboard.
Close out, don't bother editing anything
Go back to tables
delete switchboard items, and rename the 'Switchboard Items Old' back again.

Voila! Your switchboard is back.
Hopefully you hadn'r customized the crap out its appearance :)
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
I added the Swithboard form from another database ... so, it opens now.  BUT ... but the menu items don't work because I think your Switchboard table is not configured correctly. So ... try using the Switchboard manager to straighten that out.

mx
Instruments5-11-11-MX01.mdb
James CoatsComputer Info. Sys. Student

Author

Commented:
I made the switchboard from the tools, database untilites, switchboard manager. I did not make a switchboard form with the form design or wizard.

I know how to make a "form" of my choosing open upon starting the db by right clicking on the objects panel on the left side in design view and then setting that form to open.

problem is I don't see a "switchboard" I thought this was made when you used the switchboard manager?? Do I make a form called switchboard first then use the switchboard manager??
Top Expert 2016

Commented:
here try this one


Instruments5-11-11.mdb
Most Valuable Expert 2014

Commented:
Nope.

See my earlier post.
Somehow, in export/importing/rev'ing your switchboard form got lost.
The easiest repair is to rename that table and have a go.
The wizard creates a form and table
Deep-six that new table, and rename the old table back again, and you're in business
James CoatsComputer Info. Sys. Student

Author

Commented:
If you go to tools. database utilities, switchboard manager you can see the switchboard. I don't get why it won't start up
Top Expert 2016

Commented:
the Switchboard form can be set to startup from
tools > startup

or from an AutoExec macro..


Top Expert 2016
Commented:
here, i changed the default page from the swithcboard manager


Instruments5-11-11rev.mdb
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007
Commented:
"I don't get why it won't start up"

Because there is no actual Access Switchboard form in your original database.

mx
Most Valuable Expert 2014
Commented:
The switchboard manager looks at the TABLE, which does exist.
the manager is a method of making entries to that table.

Your FORM is AWOL, but the manager doesn't detect that!
James CoatsComputer Info. Sys. Student

Author

Commented:
Really strange thing. Parts of the switchboard is like the old switchboard of the old db. I never imported that table or form but it is partly (parts of the old switchboard) in the new switchboard. I did not notice that before.

Top Expert 2016

Commented:
SamuelClemm…

are you checking the uploaded db?
Most Valuable Expert 2014

Commented:
Here it is, from your sample
Instruments5-11-11.mdb
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
Nick ... that does not appear to work in this case.  The original SB table apparently has issues.

mx
Top Expert 2016

Commented:

SamuelClemmons


test the db from my post at http:#a35756212
James CoatsComputer Info. Sys. Student

Author

Commented:
Thanks to all of you. You guys came on so fast It was hard to keep up.

I understand why the switchboard wasn't working now.
Most Valuable Expert 2014

Commented:
<Nick ... that does not appear to work in this case.  The original SB table apparently has issues.>

My bad.
The board opens, but the table has entries that don't make sense in the db anymore.
The switchboard is an interesting beast.
It's built entirely from VBA code and unbound controls.

The syntax gives me skull-cramps, but it's aneat bit of code.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
"The switchboard is an interesting beast."
You've Got That Right .... :-)

mx
James CoatsComputer Info. Sys. Student

Author

Commented:
OK, OK... I know the switchboard is bad... I've figured that out... I am working on it right now... I will post it back up and you'll see it's just my inexperience...

Can I get an aviatar with a hood?
Most Valuable Expert 2014

Commented:
No Biggie!

Looking at your profile, it seems you're already wearing a brown hoodie
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
LOL!
Say GoodBye to the Access Switchboard (and hood) ... and easily create real Windows menus, toolbars and Right Click menus:


Everything you need is here (for <= A2003 environment and MDB only) - no code ... see this link:

http://www.jamiessoftware.tk/articles/menubars.html
       
Not sure it that article mentions it, but ... when you are in the Customize mode (dialog) ... if you hold down the Control key, you can drop and drag (ie, copy) menu items from one place to another ... handy for making a new menu that is similar another one.

mx
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
Clarification:

This works in the A2003 (and prior) environment and MDB format.  And they will port (with MDB) into A2007/10 environment and show up on the Add-Ins Ribbon.

mx
James CoatsComputer Info. Sys. Student

Author

Commented:
MX,

Thanks for the link and the drag and drop info. I did not know that. I will also try out the link. Right now I have to make a QC run for some inspection samples. I'll try to post the updated db prior to leaving.
Most Valuable Expert 2014

Commented:
I'm hood confused?!?
<Can I get an aviatar with a hood? >
<Say GoodBye to the Access Switchboard (and hood)>
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
"I did not know that. "
I've built 100's of menus, tool bars and right click menus using the Access built in Customize tool. VERY easy ... and a 1000 times more flexible than the Access Switchboard.

Sadly, that customize tool was removed in A2007.

mx
James CoatsComputer Info. Sys. Student

Author

Commented:
Well this is much better... now that you guys are not kicking pixels in my eyes... ;)


James CoatsComputer Info. Sys. Student

Author

Commented:
Well guys I'm cutting out of here 1 hr early today. I've uploaded the most recent copy of the db. I want to thank all of you for the help the last two weeks or so. I hope you all have a good weekend that is if you get the weekend off.

I am learning the Access with your help and I have been made to look better than I really am. Thanks again. I will see you next week.

Sam
Instruments5-11-11rev.mdb
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
You are welcome ...

mx
Most Valuable Expert 2014

Commented:
If you learn best practices, comment your code, use a decent naming convention, and know how to Google, you'll be better than you look :)
Have a good one!
James CoatsComputer Info. Sys. Student

Author

Commented:
Latest version of this db which works very well.
Instruments6-01-11rev.zip
James CoatsComputer Info. Sys. Student

Author

Commented:
Minor Revisions just made use this one.
Instruments6-01-11rev.zip

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial