C
Cloud Strife
Hi, can I know my switchboard can put more than 8 items???
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
W
Wayne-I-M
Yes !
to get a more detailed answer you need to give more details of the problem
to get a more detailed answer you need to give more details of the problem
C
Cloud Strife
Actually, I've inserted 8 items that run with macro, now I like to add 2 more
and it came out an error message, Sorry, only eight items are allowed per
switchboard page. Is there any way to insert more items in it???
and it came out an error message, Sorry, only eight items are allowed per
switchboard page. Is there any way to insert more items in it???
J
Jeff Conrad [MSFT]
What version of Access are you using?
If it's any version before 2007, see this page on my site:
http://www.accessmvp.com/JConrad/accessjunkie/switchboardfaq.html#eight
--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation
Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com
If it's any version before 2007, see this page on my site:
http://www.accessmvp.com/JConrad/accessjunkie/switchboardfaq.html#eight
--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation
Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com
C
Cloud Strife
I'm using Access 2007, I've followed the guide, but I not quite understand
it. I've tried the guides as well, but it doesn't appear the extra option. Is
there any easier guides?
it. I've tried the guides as well, but it doesn't appear the extra option. Is
there any easier guides?
F
fredg
I'm using Access 2007, I've followed the guide, but I not quite understand
it. I've tried the guides as well, but it doesn't appear the extra option. Is
there any easier guides?
Why bother with the built in Switchboard manager.
While it's possible to have more than 8 buttons, it's still a clunky
method to navigate around your database.
Use an unbound form with command buttons. If you use the Command
Button wizard to add the buttons, Access will write most of the code
for you.
You are not limited to 8 buttons and you'll have more control over the
appearance and functionality of the switchboard. Best of all,
maintenance will be easier. This is how most of us do it.
J
Jeff Conrad [MSFT]
For Access 2007, it's even easier than previous versions. You don't have to make any code, macro, or
form changes.
See this page on my site:
http://accessjunkie.com/faq_58.aspx
--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation
Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com
form changes.
See this page on my site:
http://accessjunkie.com/faq_58.aspx
--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation
Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com
C
Cloud Strife
But, I like to do something extra, so that I can score higher for my
assignment.
assignment.
J
Jeff Conrad [MSFT]
I'm not following you Cloud.
What do you mean by "something extra"?
My page describes exactly what you want - how to add more than eight items in a Switchboard Page in
2007:
http://accessjunkie.com/faq_58.aspx
Are you confused about how to do that?
--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation
Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com
What do you mean by "something extra"?
My page describes exactly what you want - how to add more than eight items in a Switchboard Page in
2007:
http://accessjunkie.com/faq_58.aspx
Are you confused about how to do that?
--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation
Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com
C
Cloud Strife
My Extra is something out of syllabus, like the switchboard, my lecturer just
taught me how to use the switchboard function, so I would like to do
something that the original switchboard can't do.
taught me how to use the switchboard function, so I would like to do
something that the original switchboard can't do.
P
Peter Hibbs
Well have a look at :-
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=511
then.
Peter Hibbs.
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=511
then.
Peter Hibbs.
C
Cloud Strife
Wow, that is way too advance for me, actually I don't need too extra, I mean
is just a bit advance, don't need too advance... Actually I still like to
know how to use the visual basic to add the switchboard item.
is just a bit advance, don't need too advance... Actually I still like to
know how to use the visual basic to add the switchboard item.
P
Peter Hibbs
Oh well, never mind.
Peter Hibbs.
Peter Hibbs.
C
Cloud Strife
Sorry about that.
C
Cloud Strife
Anyone can help me as fast as possible, I'm run out of time.
J
Jeff Conrad [MSFT]
Cloud,
You haven't been very clear what exactly you want. We can't do your homework
for you.
You initially asked how to add more than eight items onto a Switchboard page
in Access 2007. I've pointed you to a page on my web site that answers your
exact question:
http://accessjunkie.com/faq_58.aspx
I don't know what else we can do to help with your question.
--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation
Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com
You haven't been very clear what exactly you want. We can't do your homework
for you.
You initially asked how to add more than eight items onto a Switchboard page
in Access 2007. I've pointed you to a page on my web site that answers your
exact question:
http://accessjunkie.com/faq_58.aspx
I don't know what else we can do to help with your question.
--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation
Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com
C
Cloud Strife
Can I know how to do this? Easiest way to do this is to highlight the last
command button and label and select Copy.
command button and label and select Copy.
J
Jeff Conrad [MSFT]
in message:
In Access 2007, you do **not** need to make any modifications to the Switchboard form in order to
display more than eight items on a page.
Let me try this a different way...
1. Don't change anything about the Switchboard form. Meaning, don't add any more controls to the
form and don't try and modify any of the embedded macros attached to the form. Leave the form alone.
2. If you want to use the Switchboard Manager to **add** more than eight items, you can't. The
wizard is hard coded to reject more than eight. There's no way to change that. You can, however, use
the wizard to edit more than eight if you manually put in more records into the Switchboard Items
table.
3. To have more than eight items, you **must** close the wizard and add the records you need
manually to the Switchboard Items table.
I think you're confused on the third point, so let me explain further. The Wizard simply is a tool
for adding, editing, and deleting records from the Switchboard Items table. Close any objects you
have open and then open the Switchboard Items table in the Navigation Pane in datasheet view.
Now take a close look at the records. What do you see?
You'll see these five fields:
SwitchboardID - This is the ID for each menu or page in your switcboard
ItemNumber - This is the display order of each item on a specific page
ItemText - This is the text displayed on the menu for each item
Command - A specific number that Access uses to do "something"
Argument - This is used by some commands to know what object Access needs to work with.
The Switchboard Wizard simply helps you organize these records. The Switchboard form reads the
information from this table and displays it on the form.
So to have more than eight items on a menu page you have to do this manually. You'll need to take a
few minutes and study the records in your table. Trust me, after you look at the records for a
little bit, it will all make sense.
Here's a quick example.
Say you have these records in that table for the first menu page:
1 0 Main Switchboard Null Default - This is the name of a menu page
1 1 Open a form 3 Form1 - This will open Form1 in Edit mode
1 2 Open Form2 3 Form2 - This will open Form2 in Edit mode
Etc.
Etc.
Follow me so far?
To make a nineth option for this page just create a new record like so:
1 9 Open Form9 3 Form9 - This will open Form9 in Edit mode
That's all you have to do.
When you open the Switchboard form and navigate to that menu page, you'll now see nine options
instead of just eight.
Make sense?
Now if you open the Switchboard Wizard you'll see this nineth option listed. You can shuffle the
order with the Move Up and Move Down buttons, you can edit the command, and even delete it. However,
if you press New on that page, the Wizard will still prevent you from adding more than eight.
Does that help explain it better?
--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation
Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com
Can I know how to do this? Easiest way to do this is to highlight the last
command button and label and select Copy.
In Access 2007, you do **not** need to make any modifications to the Switchboard form in order to
display more than eight items on a page.
Let me try this a different way...
1. Don't change anything about the Switchboard form. Meaning, don't add any more controls to the
form and don't try and modify any of the embedded macros attached to the form. Leave the form alone.
2. If you want to use the Switchboard Manager to **add** more than eight items, you can't. The
wizard is hard coded to reject more than eight. There's no way to change that. You can, however, use
the wizard to edit more than eight if you manually put in more records into the Switchboard Items
table.
3. To have more than eight items, you **must** close the wizard and add the records you need
manually to the Switchboard Items table.
I think you're confused on the third point, so let me explain further. The Wizard simply is a tool
for adding, editing, and deleting records from the Switchboard Items table. Close any objects you
have open and then open the Switchboard Items table in the Navigation Pane in datasheet view.
Now take a close look at the records. What do you see?
You'll see these five fields:
SwitchboardID - This is the ID for each menu or page in your switcboard
ItemNumber - This is the display order of each item on a specific page
ItemText - This is the text displayed on the menu for each item
Command - A specific number that Access uses to do "something"
Argument - This is used by some commands to know what object Access needs to work with.
The Switchboard Wizard simply helps you organize these records. The Switchboard form reads the
information from this table and displays it on the form.
So to have more than eight items on a menu page you have to do this manually. You'll need to take a
few minutes and study the records in your table. Trust me, after you look at the records for a
little bit, it will all make sense.
Here's a quick example.
Say you have these records in that table for the first menu page:
1 0 Main Switchboard Null Default - This is the name of a menu page
1 1 Open a form 3 Form1 - This will open Form1 in Edit mode
1 2 Open Form2 3 Form2 - This will open Form2 in Edit mode
Etc.
Etc.
Follow me so far?
To make a nineth option for this page just create a new record like so:
1 9 Open Form9 3 Form9 - This will open Form9 in Edit mode
That's all you have to do.
When you open the Switchboard form and navigate to that menu page, you'll now see nine options
instead of just eight.
Make sense?
Now if you open the Switchboard Wizard you'll see this nineth option listed. You can shuffle the
order with the Move Up and Move Down buttons, you can edit the command, and even delete it. However,
if you press New on that page, the Wizard will still prevent you from adding more than eight.
Does that help explain it better?
--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation
Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com
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.