Multiple Switchboards to open in different tabs

[enquiries]

Hi there,

I have a main switchboard but because the limit on it is 8 objects I decided to have different switchboards (Main data-entry switchboard, Query switchboard, and Report/Printing switchboard). I can easily add an object on the MAIN switchboard to open the Query switchboard and then on that Query switchboard have a button to go back to the MAIN switchboard but what I would like to do is have each switchboard open in different tabs instead, maybe a macro or "onclick" event needed? Would it be easy to build and customize my own switchboard?

Any help much appreciated Thanks.

[June7]

Why is there a limit of 8 objects? You are using the Switchboard wizard? Access has deprecated the wizard. It will still work but finding it takes more effort.

I never used the Switchboard wizard. Didn't like the results. Too hard to understand and modify. From what I remember, it should be expandable from the initial 8 buttons the wizard establishes. Don't know if multiple 'switchboards' possible.

I build 'Menu' form with a regular form and command buttons and VBA code (I don't use macros).

What do you mean by 'tabs' - tabbed documents? I always set database for overlapping windows.

[enquiries]

I'm using the switchboard manager in Access 2007, it doesn't come up with a wizard. When I add on more than 8 items - It comes up with the error "Sorry, only eight items are allowed per switchboard page." I can't find a way to expand it But actually I did try using a form as a startup but it returned errors with my macros when I selected cancel on some of the buttons because my queries were dynamic and prompted for parameters. So need to, find a way to have multiple switchboards in tabs as in tabbed documents (like when opening a new form in a new window that opens in a tab) because when I click on it, I want the MAIN switchboard to still be there - it opens "in replace" of the MAIN switchboard or if not I'll just have the button to return to the MAIN switchboard. But I'm tight on time, so probably won't attempt customizing my own. Thanks for your help and time

[June7]

Wizard ... Manager, didn't like it.

Switchboard buttons can be added by manually creating record directly in the Switchboard Items table. Just tested that.

I don't use dynamic parameterized queries. I pass filter criteria to the form or report when opened.

DoCmd.OpenForm "form name", , , "some field = somevalue"

Main menu form will remain open and the second form will open as another tab.

Maybe you will find this interesting http://accessextra.blogspot.com/2010...converter.html

[enquiries]

That's Awesome!! Thanks Adding in the table let me add onto the switchboard and will follow the tutorial to show the wizard

And that filter/criteria sounds like a better solution - will test it when I have time. Thanks again!!

[June7]

Glad you have progress. Did some more testing. One switchboard only. Switchboard has pages. Pages have buttons.

The link I provided is not a tutorial for switchboard wizard. It is about a tool that can convert the switchboard to a custom ribbon.

[enquiries]

Sorry do you have any that is compatible with 2007 please. It's giving me an error to upgrade to a new version when I try and open the file. Thank you

[June7]

Do I have any what?

[enquiries]

switchboard to ribbon converter wizard for access 2007

[June7]

No, I found that one by accident on Bing search.

[enquiries]

Lol, thanks anyways - still searching for one on google.

[June7]

Is that an error or a prompt to acknowledge? What happens if you say 'yes'?