Tab Strip

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I notice there is a TAB Strip facility on Access. I would like to
incorporate this in my database i.e have a seperate tabe for each company so
that when it is open it shows the items held for that supplier. I do not
know wether I should do a form or a report or HOW to do it?? Any sggestions
 
John

.... "a separate tab for each company" doesn't sound like a relational
database, it sounds like a spreadsheet.

You have described what sounds like a potential design for a form. I can't
visualize your underlying data structure, which it would greatly help to
know in offering suggestions.

By the way, a more common approach to accomplishing displaying a company and
it's items would be to use a combo box to select one company from a list of
companies, then, on a sub-form, list all the items related to the selected
company. Change the company selected, get a refreshed list of items. (If
the number of items is very small, say, less than 10, you could get away
with using a listbox instead of a subform.)
 
Thanks for that

However at the bottom of the tool box there is the "More Controls" list and
on it is Tab Strip. If you click it and then drag to the Form/report, in
design view, it produces file type sperators. As in Alphabetical/Numeric
seperators you have in manual files. does this not produce on screen what
you would see if you opened a filing cabinet and saw all the tabs seprating
the different files?? or I am confused as I am new to access and its
limitations
 
The tab strip, while more flexible than the tab control in your main
toolbox, is also more demanding to use, because you have to write code to
tell it what to do each time a tab is selected.

For a beginner, I would suggest starting with the tab control. However, I
also agree with the MVP who posted the suggestion that you consider using a
different design. The tab control is designed to be used with a fixed set
of items, not to add tabs dynamically (e.g. when you add another company).
 
Back
Top