TAb forms in Access 2007

[Barry lee]

I am new to using Access 2007 and I would like to be able to split a large
table across many forms using tabs as a way of doing it - like a normal
filing system. E.g. tab for name, then contact details, training
information, etc.

I would be extremely grateful if someone could help me out, as I do not see
a method in 2007.

 

[Mark A. Sam]

Barry,

With you form open in design view, click on the Design Tab in the ribbon.
One of the control selection buttons looks like a tab control. It should be
on the right of the Check mark, but the tool tip will tell you. Click on it
then click on your form.

To add pages, right click over the tabs and select Insert Page.

God Bless,

Mark A. Sam

 

[Linq Adams via AccessMonster.com]

"I am new to using Access 2007 and I would like to be able to split a large
table across many forms using tabs as a way of doing it - like a normal
filing system. E.g. tab for name, then contact details, training
information, etc."

If you're talking one tab for the name, a second tab to hold contact details,
a third to hold training info and so forth, this is what Tabbed Pages where
designed for and will serve you well.

Your phrase "like a normal filing system" concerns me, though. If you're
talking about having one tab for one person, with their name, contact details,
training
information, etc. then having another tab for the next person, and so forth,
you're heading down the wrong path; records can't really be displayed like
that.

Here's a short little primer I keep on file outlining the basics of working
with tabbed pages. It may be of use to you.


First thing to remember is that the Tabbed Pages are all part of a single
form; think of it as a really long form turned on its side. Because it is all
one form, all referencing to any control on it is done in the same manner as
if they were all on one single screen. Create a form in Design View. Goto the
toolbox and click on the Tabbed Control icon; it actually looks like several
manila file folders. Place it on your form and adjust the size to your liking.
If you need more than the two tabbed pages it initially gives you, click on
the tabbed control to select it. Goto Insert and click on Tabbed Control Page
and another tabbed page will be added. Do this as many times as necessary.

This is the really important part: when you go to add a control to a tabbed
page, you must first click to select one of the pages, then add the control.
Otherwise, the control will be added to the form itself, and will show thru
on all tabbed pages!

Once you have the form's Control Source (your table or a query) set up, you
simple add controls as you normally would, heeding the above paragraph.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com