Tab Control inside Tab Control

[r.harrison]

Hi,

I'm trying to put a Tab control inside a page on another Tab Control but it won't work.

Is there a way around this without using a subform inside the page?

 

[gemma-the-husky]

if you can't do it, then there probably isn't a way. given the way a tab works, it's not surprising, can't you just add extra tab pages to the main tab.

 

[vbaInet]

To my knowledge you can't put a tab control inside another tab control container. It's just the way it was designed.

What's your main reason of wanting to do this? I suspect that you want multiple rows of tabs? If this is the case you can change the layout of your tabs in the property sheet.

 

[r.harrison]

I'm looking to use just 1 form to run my entire DB. Certain areas of the DB are only available to certain users so for ease of programming I thought using a tab for each userlevel then all their individual options inside their tab.

I think SubForms would be the way to go here?

 

[vbaInet]

Certain areas of the DB are only available to certain users so for ease of programming I thought using a tab for each userlevel then all their individual options inside their tab.

The more customised your requirements are, the more difficult it becomes

I think SubForms would be the way to go here?

Certainly. I remember doing something like this where I had one main form and several subform controls. The ribbon had all the menus whilst individual forms had their own buttons for that form's specific routines. A state of each subform was kept in a class, i.e. validation error messages, dirty, new, and lots of other properties. I then used a stack to manage the ordering of the Windows so that users can switch between windows (or forms). There were lots of other things but I can't remember exactly.

 

[gemma-the-husky]

i think to do what you want, the easiest way would be to design a full system as standard

then based on the user, just set the visible property to false for everything that you dont want them to see. you could probably use the tag property - or maybe design a control table to manage them.

 

[r.harrison]

Thanks for the suggestions both of you, will look in to the controls table. I'm assuming this is a table detailing the names of the controls , List of userlevels then simple yes/no fields to say whether that userlevel can see them?

Another idea I had was Subforms in each tab. Would this be following 'conformity'?

 

[vbaInet]

Another idea I had was Subforms in each tab. Would this be following 'conformity'?

Yes, lots of people tend to do this.