Tabs in Form View

B

Backwards Man

I have Access 2000(and I am new to Access all together, please bear with me).
I want to have multiple tabs at the top of each record in form view, to view
additional information about each record. How do I do this????
 
J

John Vinson

I have Access 2000(and I am new to Access all together, please bear with me).
I want to have multiple tabs at the top of each record in form view, to view
additional information about each record. How do I do this????
Click to expand...

Step back a bit.

If you have so many fields in your table that you need multiple tab
pages to see them all - your table is probably not correctly
structured! What "additional information" are you looking at? Multiple
fields? Subforms bound to related tables (better)? or what?

That said - there is a Tab Control tool on the Toolbar. You can use it
to create a "file folder" on your form; you can then put textboxes,
subforms, etc. on each page of this Tab Control.

John W. Vinson[MVP]
 
B

Backwards Man

John Vinson said:
Step back a bit.

If you have so many fields in your table that you need multiple tab
pages to see them all - your table is probably not correctly
structured! What "additional information" are you looking at? Multiple
fields? Subforms bound to related tables (better)? or what?

That said - there is a Tab Control tool on the Toolbar. You can use it
to create a "file folder" on your form; you can then put textboxes,
subforms, etc. on each page of this Tab Control.

John W. Vinson[MVP]
Click to expand...
I would like to have a large amount of information, and some of that
information is pictures. So, I would like a tab for information, tab for
pictures, and a tab for alternate pictures.
I tried using the tab control tool, but could not get it to do what I want.
I want the first tab to show the information, click on the second tab(the
info disappears) and the pictures appear, click on the third tab(the pictures
disappear) and the alternate pics show up. I hope I described what I am
after. Thanks for your help!
 
J

John Vinson

I would like to have a large amount of information, and some of that
information is pictures. So, I would like a tab for information, tab for
pictures, and a tab for alternate pictures.
I tried using the tab control tool, but could not get it to do what I want.
I want the first tab to show the information, click on the second tab(the
info disappears) and the pictures appear, click on the third tab(the pictures
disappear) and the alternate pics show up. I hope I described what I am
after. Thanks for your help!
Click to expand...

Access is VERY BAD at storing picture data: the database bloats
enormously with even a few pictures. Adding a 25k jpg image can bloat
the database by a megabyte. You really should consider storing the
pictures as external files, and storing only the file names or
hyperlinks in your Access tables.

It can be tricky to put controls (Image controls, textboxes, subforms,
anything) onto a tab control. If you just drag the control on, it's
actually put *in front of* the tab control; the effect is that you see
the image no matter which tab you select.

The solution is to:
- Select the control or controls you want on the tab page
- Type Ctrl-X to cut them to the clipboard
- Select the *tab* (not the surface) of the desired tab page; the
surface will darken to indicate it's been selected
- Type Ctrl-V to paste the controls onto the page

Repeat for each page. Or, select the tab page and *then* use the
toolbox to insert your control.

John W. Vinson[MVP]
 
Top