Switchboard errors

G

Guest

I have created a switchboard, and when I try it out there is only one button,
and I get a message box stating: "There was an error reading the Switchboard
Items table". The heading for the button on the switchboard reads: "There
are no items for this switchboard page." I have put a few items on the
switchboard, and I was trying to test along the way, so I don't make any
mistakes populating the form.

Here is the table of the switchboard:

SwitchboardID ItemNumber ItemText Command Argument
1 0 Main Switchboard Default
2 0 Data Entry Items 0
2 1 SOP Change Form 2 F_SOP Change Log
3 0 View/Print Reports 0
3 1 SOP Master List 4 R_SOP Master List


Also, here is the software info from the help dialog box:

Access 2003(11.6566.6568) SP2

There are also other databases on the network with Custom Switchboards,
could any code interfere with the new database I have created?
 
J

Jeff Conrad

Hi BadBoyTim,

Per this question:
There are also other databases on the network with Custom Switchboards,
could any code interfere with the new database I have created?

No, they are not interfering at all.

Your entries so far look fine, you have just missed a key step.
So far you have a main page and two sub menus, each with one
entry. However, your main page has no entries at all hence the message.
What you need to do is add some entries to the main menu to
open the sub menus. It will all make sense in a minute.

Follow these steps.
1. Launch the SBM wizard again.
2. Main Switchboard should be highlighted - Press the Edit button.
3. Now you will see all the entries for this main switchboard page,
but as you can see you have nothing here.
4. Click the new Button.
5. A small dialog box will open.
6. Enter these in the appropriate places:
Text: Go to Data Entry Items
Command: Go to Switchboard
Switchboard: Data Entry Items
7. Hit Ok to save
8. You will see the first entry now here. What we have done is entered
a command to open the sub menu.
9. Click the new Button again.
10. A small dialog box will open again.
11. Enter these in the appropriate places:
Text: Go to Reports Menu
Command: Go to Switchboard
Switchboard: View/Print Reports
12. Hit Ok to save
13. Now we have two entries here.
14. Let's add an exit application now to the main page.
15. Click the new Button again.
16. A small dialog box will open again.
17. Enter these in the appropriate places:
Text: Exit Application
Command: Exit Application
18. Hit Ok to save
19. Now we have three entries here.
20. Now close the SBM all together.

Open the form now and observe the fruits of our labor.
Test the buttons to see how we are opening the sub
menus now.

But wait, do you see the problem now? When you go to
the sub menus, how do you get back to the main one and
then exit the application?

Time for lesson two.
Let's take a short break for intermission now, OK? Help yourself
to some refreshments in the lounge area.
Go ahead, I'll wait.....the bagels are fabulous by the way...
How is your day going? Excellent....<<more small talk here>>

All right, back to work now.

21. Fire up the SBM wizard again.
22. On the first page highlight the Data Entry Items page.
23. Now click the Edit button.
24. Right now we only have one option on this page.
25. Click the New button.
26. A small dialog box will open again.
27. Enter these in the appropriate places:
Text: Exit Out To Main Menu
Command: Go to Switchboard
Switchboard: Main Switchboard
28. Hit Ok to save
29. Now we have two entries here. The second one will
return us back to the main menu.
30. Now close this particular switchboard page.
31. We are back on the first page of the wizard again.
32. Highlight the View/Print Reports page.
33. Now click the Edit button.
34. Right now we only have one option on this page.
35. Click the New button.
36. A small dialog box will open again.
37. Enter these in the appropriate places:
Text: Exit Out To Main Menu
Command: Go to Switchboard
Switchboard: Main Switchboard
38. Hit Ok to save
39. Now we have two entries here. The second one will
return us back to the main menu.
40. Now close this particular switchboard page.
41. Now close the wizard all together.

Open the Switchboard form now and see what happens.
we can make our way to the sub menus and then back
out to the main page with ease. The last option on the
main page will close the application.

For any and all other SBM questions, see this page on my site:

http://home.bendbroadband.com/conradsystems/accessjunkie/switchboardfaq.html

Now get up from the desk and do a little victory dance.
Carry on.
--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:
 
G

Guest

Thanks for pointing that out to me.
Thats what I get for rushing to finish something. . .
 
J

Jeff Conrad

in message:
Thanks for pointing that out to me.
That's what I get for rushing to finish something. . .

No problem, glad to help.
Good luck with your project.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top