Tabbed navigation menu - possible ??

[Lukael]

Hello,

I will have to create Access DB that should have a "tabbed navigation" look when It opens, like web solutions.

Is this even possible in Access, or any simmilar solutions that might be almost same (custom ribbon, navigation forms, some add-ins etc...) ?

Check attached sample picture, that is appearance I'm looking for (notice that tabs have submenu, I need that too) !


Thanks for help in advance !!

[CJ_London]

yes it is possible

make your tabs text boxes and the dropdowns hidden list boxes

then in the textbox click event have code which unhides the relevant listbox

you'll probably need additional code to hide the listbox again once a selection has been made or another tab has been clicked - this will depend how you want the form to work.

If you don't like the look of the listboxes, use a continuous subform instead - coding a bit more complex, but perfectly doable.

Also consider using the mousemove event which can be used to unhide a listbox just by hovering over the tab with the mouse

[CJ_London]

one other thought, consider using buttons rather than textboxes for the tabs, they are highly configurable and you can get the rounded corner effect if required.

[Lukael]

thanks for response Ajax,

do you have any sample, I don't quite follow ?

[CJ_London]

I don't have an example, sorry.

but it is a fairly common requirement so you should find some examples - try googling 'access vba hide control' and variations therof

[Lukael]

No problem, thanks for help. I tried your suggestion and designed It on my own. A little bit of coding though...

Are there any add-ins for Access that have this kind of navigations ?