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

did you set switchboard as the display form from

tools > startup

what is the name of the form?

You have a Switchboard table, but no Switchboard form

mx

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

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

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??

here try this one


Instruments5-11-11.mdb

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

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

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

or from an AutoExec macro..

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.

SamuelClemm…

are you checking the uploaded db?

Here it is, from your sample
Instruments5-11-11.mdb

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

mx

SamuelClemmons


test the db from my post at http:#a35756212

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.

<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.

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

mx

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?

No Biggie!

Looking at your profile, it seems you're already wearing a brown hoodie

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

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

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.

I'm hood confused?!?
<Can I get an aviatar with a hood? >
<Say GoodBye to the Access Switchboard (and hood)>

"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

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

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

You are welcome ...

mx

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!

Latest version of this db which works very well.
Instruments6-01-11rev.zip

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