473,387 Members | 1,453 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Switchboard Limitations

Is there any way to by-pass the limitation of only 8 items on the
switchboard menus?

Thanks!
Nov 9 '07 #1
4 2885
On Fri, 09 Nov 2007 04:21:03 GMT, David Grist wrote:
Is there any way to by-pass the limitation of only 8 items on the
switchboard menus?

Thanks!
Yes you can, however, the switchboard manager will still only
recognize 8 buttons. Maintenance will be difficult.

A better solution would be to use one of the 8 buttons to open a 2nd
switchboard page (and a 3rd, etc.). All of this can be done using the
manager.

The best solution would be to discard the current switchboard system
and simply create a new one, using an unbound form with command
buttons. You are not limited to 8 button,s and if you use the Command
Button wizard when adding the buttons, Access will even write most of
the code for you. You will actually have more control over the form
layout and functionality, and maintenance will be easier.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Nov 9 '07 #2
On line 24 of the Switchboard form's module you'll see the line

Const conNumButtons = 8

Change the value in that line - the manager will still only work for eight
options but it's not hard to do manually


David Grist wrote:
>Is there any way to by-pass the limitation of only 8 items on the
switchboard menus?

Thanks!
--
Message posted via http://www.accessmonster.com

Nov 9 '07 #3
On Nov 9, 2:41 am, "alecwood via AccessMonster.com" <u32921@uwe>
wrote:
On line 24 of the Switchboard form's module you'll see the line

Const conNumButtons = 8

Change the value in that line - the manager will still only work for eight
Also if you use this approach, you will need to create the buttons and
lbls for the buttons to correspond with the numbuttons value that you
just entered.

The maintain switchboard wizard will NOT operate properly beyond the 8
original entries - as everyone has commented.

Ron
Nov 13 '07 #4
Yes, but as long as you follow the naming conventions already used for the
buttons and labels, the table which drives it is pretty self-explanatory.

I'd encourage the original questioner to go for it, make the mod and if it
doesn't work, post on here for more guidance.

Try stuff, if it works be proud, if it doesn't be humble and ask for help,
then go fix it and be proud. Thus we learn.

Alec

>The maintain switchboard wizard will NOT operate properly beyond the 8
original entries - as everyone has commented.

Ron
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200711/1

Nov 14 '07 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

13
by: Mark | last post by:
I am looking for a switchboard creator alternative for my MDB. Can anyone help me? Thanks for your help, Mark
2
by: Dannic | last post by:
Here is the application. Its a simple application really. I have a db created in Access 2000 which opens to a switchboard created by the switchboard manager. Now the problem. This only works...
2
by: Terry | last post by:
I have created a switchboard, created using Access 2000. If I put the mouse anywhere on the form, outside of the checkboxes and scroll the wheel backwards, I get the following error. Run-Time...
4
by: Rampar | last post by:
I did some customizing on my switchboard (changing colors and adding graphics) to make it more appealing. I tried to add another item, and it told me that 8 was the limit. Fine. I deleted one...
5
by: Michael Keene | last post by:
I have a query that I'd like to add to my switchboard, but when I use the switchboard manager I only get the option to run a report, a macro or open a form. Is there a way to add a query without...
2
by: Neil Greenough | last post by:
I am trying to create a Switchboard using the Switchboard Manager in MS Access 2000. I have managed to get the table created for the switchboard, however it hasn't actually created the form. ...
1
by: jimwlee | last post by:
Hi all, I mistakenly deleted my switchboard on the Object Forms view. I recreated it again with the database utility, but the switchboard isn't showing up in the forms view. Any ideas? Thanks in...
1
by: mplus_2000 | last post by:
I have recently inherited a database. The switchboard (and other forms) displays the name of the database on it (top, center). Currently the name that appears is Reviews. There are plans to roll...
2
by: Earl Anderson | last post by:
In Acc2003, I have a situation in which I have a main switchboard and upon pressing one of its buttons , takes the user to another sub hierarchical switchboard. Pressing one of these buttons could...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.