Switch Board manipulation

[Tinky]

Hi all
I know that i was discussed a lot but now it's about accexx2010.
I need to have more than 8 items on my switchboard but can't find any code for that in VBA. please please help me find that.
i'd rather not use the option of building a regular form as switchboard
thank you thank you
tinky

 

[JHB]

Is it the "old" Switchboard, used in MS-Access 2000?

 

[Tinky]

Hi
actually the other posts didn't help me, that is why i'm still searching for help.
thanks.

 

[JHB]

Øhhh - what?

 

[Tinky]

ok i'll ask again:
I need to have more than 8 items on my switchboard ,in access 2010 , but can't find any code for that in VBA. please please help me find that
thanks
tinky

 

[namliam]

as far as I know, as long as your screen can show the options its a simple matter of adding the options to the switchboard table

The form itself is simply a continues form that will add as many options as you have available in the table.

 

[Tinky]

it won't allow more than 8

 

[JHB]

Show a printscreeen of the switchboard form in design view, so we can see if you are using the "old" switchboard or the "newer" on, (zip it because you haven't post 10 post yet).!

What happen if there are more as 8 options, any error message?

 

[Tinky]

well...there is just no option for more than 8.
also there is no option for me to upload any image or even paste one,
though i prepared a nice censored image for my secret database...

 

[JHB]

Okay it's your choice, so I'll move on, good luck!

 

[Tinky]

it's not so much of my choice, i really cant see how to upload an image. you can also help with that if you like

 

[namliam]

if you are using the quick reply, click the "Go Advanced" button or "post Reply" button

Once in advanced "mode" you should be able to find "Attach Files" and a "Manage Attachments" button... That will allow you to create attachments.... There may be some restrictions in place since you are a new member.... I am not sure about what is restricted when.

Failing that, upload the picture to Photo bucket or some simular website and post the link here.

 

[Solo712]

well...there is just no option for more than 8.
also there is no option for me to upload any image or even paste one,
though i prepared a nice censored image for my secret database...

I believe the eight options is a hard limit. I have tinkered with it in the past but could not get past the 8 except by cascading switchboards. Eventually, I built a custom-made switchboard template. There is no rocket science in it. Basically you just have buttons opening forms, and then some additional code to display or hide the forms that are open when eg you hit a report button that goes into preview. I also added code to manage user level access to the forms and a dashboard displaying statuses, filters, stats and events. I have found it a useful investment. The built-in switchboard is a bit of a fool's science if you ask me.

Best,
J.

 

[David R]

The built-in switchboard is a bit of a fool's science if you ask me.

I absolutely agree. It's like using macros... seems easier at first, but you end up hamstringing yourself with the built-in limitations.

 

[Tinky]

Thank you guys
that's just what i did
but since i'm an expert in VBA yet, I just have the form with buttons. it works just fine.
i'll be happy for some sample code that can teach me how to play with the display and stuff as you described

tinky

 

[Poppa Smurf]

8 is the token, but you can increase the number of menu items to a reasonable number. I have increased the number to 20 switchboard items for access 2003 I have not tried this for 2007, 2010.

Here is a link that maybe useful http://www.techonthenet.com/access/switchboard/increase.php

 

[Tinky]

Hi
saw that before and it's irrelevant to 2010.
i find no VBA code behind the switchboard...
sorry
but thanks again
tinky

 

[namliam]

as far as I know, as long as your screen can show the options its a simple matter of adding the options to the switchboard table

The form itself is simply a continues form that will add as many options as you have available in the table.

Please see attached database... I have no trouble creating 14 items to a switchboard form