GENERAL. I upgraded to Access 2010 a few weeks ago and am trying (unsuccessfully so far) to create a switchboard menu system, i.e., a ‘main switchboard’ with several secondary switchboards. This is my first use of the Switchboard Manager in Access 2010, although I have created many others in Access 2003 and earlier versions. The database I’m working with right now is named Weblog Analysis Mar-Apr 2012 -3-28 1pm. The extension is accdb (all my previous work has been with mdb files.)
BACKGROUND: --- Using the Switchboard Manager, I created a Main Switchboard and added two secondary switchboards to the Switchboard Pages dialog box. On each of the secondary pages, I added one item so far: Return to Main Menu.
PROBLEM: When I open the Main Switchboard from the Navigation Pane (‘Forms’ section), it opens OK but does not display any ‘switchboard items.’ It’s just a blank ‘shell’ with a main title.
WHAT I’VE DONE AND SEEN SO FAR. I can see the switchboard OK in all views, and I can see its ‘Properties” OK in design view, etc. I can also see all the proper records in the table “Switchboard Items” and they ‘look’ OK (see attachment). To the best of my knowledge, except for the invisible items, everything ‘looks’ OK, but then I’m not a programmer and may be missing something. I also tried tinkering with some of the properties, i.e., Data Source, Filtering, Locks, etc. but nothing in the display changed. Thinking my copy of Access might be corrupted somehow, I reinstalled the program and nothing changed. I also deleted the switchboard I had created and recreated it from scratch using the Switchboard Manager and got the same results. I have also checked to be sure I have “exclusive access” (the default).
DATA SOURCE IN 'PROPERTIES': SELECT * FROM [Switchboard Items] WHERE [ItemNumber]>0 And [SwitchboardID]=TempVars!S
ID ORDER BY [ItemNumber];
Any thoughts or suggestion will be greatly appreciated. Wally Tee.