Possible To Tab Form Itself (Not Tabbed Control)?

[Soule]

Hey, Everyone,

I'm trying to simplify my bosses .mdb database which has 10 tables and many forms that feed them. I want to build her more than one version to pick from. I've built a version using tabbed controls to allow all of the column/fields of the tables to be data-entered on one form. Now, I want to build a version that actually has tabbed forms when you open one form. Sort of like a master view with multiple forms on tabs.

Is this even possible in Access 2007? I can't seem to find any literature about it online.

Any insight or help would be appreciated by me (and by my boss in the long run!).



Thank you in advance,

FJ

[RuralGuy]

Add a TabControl to your MainForm and put each form on its own tab as a SubForm.

[KrisDdb]

If you have already tried tabbed control, you could try 'Navigation Forms'. Each navigation form comes with navigation buttons (horizontal/vertical tabs) to which u can assign a form. You simply drag and drop the objects onto the buttons.

HTH.

[boblarson]

If you have already tried tabbed control, you could try 'Navigation Forms'. Each navigation form comes with navigation buttons (horizontal/vertical tabs) to which u can assign a form. You simply drag and drop the objects onto the buttons.

HTH.

KrisDdb - Navigation Forms are not available in Access 2007 (which I believe the user is using) but only in 2010.

[KrisDdb]

Bob

I apologize I was not aware of that. I started my career with Access 2010. But thanks for letting me know.

[RuralGuy]

I guess I need to ask the OP what is wrong with a TabControl?

[boblarson]

Bob

I apologize I was not aware of that. I started my career with Access 2010. But thanks for letting me know.

Not a problem. It can be a challenge sometimes for those of us who have been using lots of different versions to remember which version introduced what. I've been using Access since Access 2.0, so that's a lot to keep track of

I guess I need to ask the OP what is wrong with a TabControl?

Yep, good question.

[KrisDdb]

Am kinda new to the lingo.. but what is OP?

[boblarson]

Am kinda new to the lingo.. but what is OP?

OP = "Original Poster"

[KrisDdb]

oh ok! thanks fr the tip

Am sure you would know this, but from what I understand, I wouldnt say there is anything wrong with tabbed controls.. but there is definitely an advantage in using navigation controls, when compared to each other. The tabbed control loads all the objects when it is accessed, where as the navigation control loads the object on demand only. This surely increases the efficiency of the app (considering that there are more than one objects under a tab). However, in this case, it shouldnt make much of a difference.

[RuralGuy]

The tabbed control loads all the objects when it is accessed, where as the navigation control loads the object on demand only. This surely increases the efficiency of the app (considering that there are more than one objects under a tab). However, in this case, it shouldnt make much of a difference.

The same can be done with a TabControl but it is not automatic. You would need to use a bit of VBA code.

[Soule]

Hi, guys - I decided to just to tabbed controls (columns for tabs on each tab group for tables) on one regular form. I didn't want to get into sub-forms for this project, as I just found out my boss simply wants records duplicated for each table with only her "Year" field changed. Thanks for thinking about the problem.

[boblarson]

I just found out my boss simply wants records duplicated for each table with only her "Year" field changed.

Pardon me for saying this, but your boss is "database challenged." (read that to say - "an idiot.") The data should not be stored that way and will be a pain in the butt to use whenever you need to get it back out in a meaningful way. Normalization is the way to cure that, but it would appear that your hands may be tied.