If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access template and Switchboard
Hello to everybody,
I am creating a new database using the template supplied with Access 97. How may I edit more the 8 items per switchboard page. If possible I need something like 13 items per page. Many thanks for your help. Regards John |
#2
|
|||
|
|||
Access template and Switchboard
It is possible to modify the Access default Switchboard form to add
more buttons, but this modification is not supported by the Wizard, so you end up having to add and modify switchboard pages by manually adding records to the Table that controls them. It is probably not worth the effort unless you just have one or two pages that need extra items. If you really need more than the 8 standard choices for multiple pages, you are probably better advised to create your own switchboard Forms from scratch. On Sun, 04 Jul 2004 06:49:11 GMT, "John B" wrote: Hello to everybody, I am creating a new database using the template supplied with Access 97. How may I edit more the 8 items per switchboard page. If possible I need something like 13 items per page. Many thanks for your help. Regards John Please respond to the Newsgroup, so that others may benefit from the exchange. Peter R. Fletcher ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- |
#3
|
|||
|
|||
Access template and Switchboard
[cut..]
It is possible to modify the Access default Switchboard form to add more buttons, but this modification is not supported by the Wizard, so you end up having to add and modify switchboard pages by manually adding records to the Table that controls them. It is probably not worth the effort unless you just have one or two pages that need extra items. If you really need more than the 8 standard choices for multiple pages, you are probably better advised to create your own switchboard Forms from scratch. Thanks for your suggestions John |
#4
|
|||
|
|||
Access template and Switchboard
Hi,
Follow these steps to add more than 8 items to the Switchboard Form: 1. You need to create additional command buttons and labels to match the number of items you want. Easiest way to do this is to highlight the last command button and label and select Copy. Then Paste them onto your form to create additional ones. Now make sure you change the name of the NEW command button(s) to Option9, Option10, etc. Also change the name of the NEW labels to OptionLabel9, OptionLabel10, etc. 2. Now go to the properties area of each new command button. In the click event, enter the following: =HandleButtonClick(9), =HandleButtonClick(10), etc. to match up with your selection. Do exactly the same thing for the Click event of the labels (unless you turned those off). 3. Now go to the code behind the Switchboard form. Scroll down until you come to this line in the FillOptions Sub: Const conNumButtons = 8 Change that number to 9, 10 or whatever you need. 4. Compile the code, save and close the form. Now if you use the Switchboard Manager interface you are still restricted to 8 items. To add more you have to add the entries manually into the Switchboard Items Table. Shouldn't be hard to do if you take a few minutes and see how the records are entered. You can EDIT more than 8 entries from the Wizard, but cannot ADD more than 8. -- Jeff Conrad Access Junkie Bend, Oregon "John B" wrote in message ... Hello to everybody, I am creating a new database using the template supplied with Access 97. How may I edit more the 8 items per switchboard page. If possible I need something like 13 items per page. Many thanks for your help. Regards John |
#5
|
|||
|
|||
Access template and Switchboard
On Sun, 04 Jul 2004 06:49:11 GMT, John B wrote:
Hello to everybody, I am creating a new database using the template supplied with Access 97. How may I edit more the 8 items per switchboard page. If possible I need something like 13 items per page. Many thanks for your help. Regards John The simplest method a 1) Use one of the 8 buttons to open a second switchboard. Use one of the 8 buttons on the second switchboard to return to the first (or open a third) switchboard. This can be done easily using the built-in Switchboard manager add-in. 2) Create you're own unbound form using command buttons to navigate your database. If you use the Command button wizard to create the buttons, Access will do most of the work for you. Add as many command buttons as you need. This is what most professionals do. Adding more buttons to the existing switchboard can be done, but it's not supported by the switchboard manager. It's just not worth the effort. -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
Thread Tools | |
Display Modes | |
|
|