switchboard problems

[Alistair]

I am having a problem creating an additional switchboard. I know how to
create and edit switchboards but when I try to add a switchboard (there are 4
already created) it appears to work but does not appear on the main
switchboard yet is in the switchboard items manager. Never had this problem
before..please help
Alistair

 

[Jeff Conrad]

This may seem obvious, but did you create an entry on the *main* Switchboard Page to go to this new
page?

 

[Alistair]

I have and it shows up under database utilities Switchboard manager as a new
switchboard page but when I reopen the switchboard nothing has changed and
the new page is not there. It is mentioned in the Table Switchboard items. On
the Main switchboard page I have 5 items already but just cannot make another
visible, yet I can go to this invisible board from another switchboard via
add new item and tell it to go to the contents of that switchboard. I can add
to the contents of the new board it just will not appear on the main
menu..any ideas It is Office 2003

 

[Jeff Conrad]

Hummm...that's odd.
Can you post the records for the *main* switchboard page here so I can see them?
They will most likely have 1 as the SwitchboardID, but not necessarily.
Look for the Argument "Default" and list each record that has SwitchboardID as the same number.

Something like this:
SwitchboardID ItemNumber ItemText Command Argument
1 0 Main Switchboard 0 Default
1 1 Go To Second Page 1 2
1 2 Go To Third Page 1 3
Etc....

 

[Alistair]

not sure how this will look, item 6 (1) looks like it is on the main page but
this would say different
SwitchboardID ItemNumber ItemText Command Argument
1 0 Main Menu Mitchell Library & Real Learning Centre 2004-2005 Default
1 1 Go to Update Forms and Tables 1 2
1 2 Go to Administrative Page 1 4
1 3 View Tables 3 FRM-Search Page
1 5 Exit and Save Access Database 7 Exit Access
2 0 Update Forms and Tables 0
2 1 Update Mitchell Learners Form 3 FRM-Mitchell Learners
2 2 View and Update Mitchell Library Courses 7 View all Mitchell Library
courses
2 3 Return to Main Menu 1 1
2 4 Exit and Save Access Database 7 Exit Access
4 0 Administration 0
4 1 Preview invite to CDWriting course 7 Preview Invite learners to
CDWriting course
4 2 Preview invite to Internet and Email course 7 Preview invite learners to
Internet and Email course
4 3 Preview invite to Introduction to Computing course 7 Preview Invite
learners to Computing course
4 4 Preview invite to Keyboard and Mouse Skills Course 7 Preview invite
learners to Keyboard and Mouse Skills course
4 5 Preview invite to Scanning course 7 Preview invite learners to Scanning
course
4 6 Preview invite to Word Processing Course 7 Preview invite learners to
Word Processing course
4 7 Go to Learner Waiting List Reports 1 6
4 8 Return to Main Menu 1 1
5 0 View Tables 0
5 1 Open Mitchell Learners Table 7 Open the Mitchell Learners Table
5 2 View all Mitchell Library Courses 7 View all Mitchell Library courses
5 3 Return to Main Menu 1 1
5 4 Exit and Save Access Database 7 Exit Access
6 0 All Waiting List Report
s 0
6 1 View CDWriting waiting list report 4 RPT-CDWriting waiting list
6 2 View Introduction to Computer waiting list report 4 RPT-Computing
Waiting List
6 3 View Internet and Email waiting list report 4 RPT-Internet and Email
Waiting List
6 4 View Keyboard and Mouse waiting list report 4 RPT-Keyboard and mouse
waiting list
6 5 View Scanning Techniques waiting list report 4 RPT-Scanning waiting list
6 6 View Word Processing waiting list report 4 RPT-Word Waiting List
6 7 Return to Main Menu 1 1
6 8 Exit and Save Access database 7 Exit Access

 

[Alistair]

Don't know if you managed to read the last post but I said item 6(1) was the
item I attempted to place on the main page, actually it was item 6 (0) All
Waiting List Reports. As I say it looks like it is on the main page but it's
not

 

[Alistair]

Jeff, I'm really sorry for having wasted your time, I took a coffee break and
when I started again, I saw that I had in actual fact made some stupid
mistakes. I have found what I was doing wrong and fixed it. Thought I had put
new entry on main page but had created a new switboard page and forgotten to
put subsequent sntry on the main page, although I had filled the new page
with all required data. Now more awake I can see clearly again. Thanks for
your time, not normally so daft, guess just too tired to see the obvious

 

[Jeff Conrad]

Hi,

No problem.
I had just entered some of the records into a test database and immediately saw an issue. I came
back to the NG and just saw you found the problem.

Yes, it would appear you need to have an item on the main page. All the items on the *main* page
will have 1 in the SwitchboardID column.

Glad you got it fixed.

 

[Alistair]

Hi Jeff when you say you entered some of the records into a test database
what do you mean? How do you use what I gave you to create records and solve
issues? I've never tried that

 

[Jeff Conrad]

Hi Alistair,

I just did these steps:
1. Created a new blank database
2. Ran the *old* SBM (inside joke <g>)
3. Took your information and just entered it directly into the Switchboard Items table
4. Opening the Switchboard Form would show everything, but I would get an error of course anytime I
clicked an option other than to open another page. This is because I do not have the forms, reports,
macros, etc.

Problem was easy to spot then.