Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / December 2007

Tip: Looking for answers? Try searching our database.

Access 2003   Switchboard   maximim items?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sue - 28 Dec 2007 20:04 GMT
I cannot add beyond 8 items on my Switchboard. Each item runs a small report.

The error I get is:
"Run-time error '2465'
Microsoft Office Access can't find the filed 'Option9' referred to in your
expression"

I even tried skipping 9 and going to 10, but then it refers to Option10.
Is there a limit?

Thank you
Sue
Beetle - 28 Dec 2007 20:34 GMT
The Access switchboard has a built in limit of 8. You can get around it, but
it requires some coding. It may be better to create your own form to use as a
switchboard using command buttons programmed to open the forms/reports that
you want. This will give you more flexibility in the future to add more items
if needed.

Signature

_________

Sean Bailey

> I cannot add beyond 8 items on my Switchboard. Each item runs a small report.
>
[quoted text clipped - 8 lines]
> Thank you
> Sue
Sue - 28 Dec 2007 20:44 GMT
Thank you Beetle -

You are much more help than the Access "help" files. I will create a form.

Happy New Year to you.

Sue

> I cannot add beyond 8 items on my Switchboard. Each item runs a small report.
>
[quoted text clipped - 8 lines]
> Thank you
> Sue
Pat Hartman - 28 Dec 2007 21:10 GMT
The switchboard form is relatively easy to modify to allow for more than 8
items.  You need to copy the existing control and use the same naming
pattern.  Then I think only two lines of code need to be changed.  But once
you do that, you are relegated to making item changes to the Switchboard
Items table rather than using the wizard because the wizard only recognizes
8 items per switchboard page.

You can however, create an unlimited number of switchboard pages so you
actually have to limit as to the choices the switchboard will present.  You
only have to organize them into chunks of 8 or actually 7 since you always
want to leave item 8 as the exit or return to previous menu option.

>I cannot add beyond 8 items on my Switchboard. Each item runs a small
>report.
[quoted text clipped - 9 lines]
> Thank you
> Sue
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.