Multi Tab Form

[Pixie78]

I am building a db for our internal containment log that is currently in an
excel spreadsheet. The set up is actually good, it's just not automated like
it could be in Access. The spreadsheet has 10 different tabs, one for each
Cell we have producing product. I wanted to set up the db the same way so
the manager can view all problems per Cell but also have the ease of being
able to flip to whichever one needed to view or edit data.
Question 1 is, can I make the tabs at the bottom of the screen like Excel or
they are forced to stay at the top? I think it looks better at the bottom,
but that's a cosmetic issue and not a big deal if I can't change it.
Next, how do I go about creating a tab for each Cell?
I have all my tables of info and then one big table named tblICLOG that
contains the issue such as: date, time, defect, quantity, color, fix, etc.
That is the info I need to separate by Cell (cell is one of the fields as
well as a LogID)
I've seen that I can create a form based on a Cell query with criteria that
equals each cell, then use that query as the source of the form with one text
box and then add the ICLOG as a subform linking them by Cell number. Is that
the best way?
That'll be about the only form I need, everything else will just be a bunch
of reports and charts that I'm hoping Access will make easier which is why
they wanted to move it from Excel.
Thanks for any advice.

 

[Jeff Boyce]

You did say "any advice"...<g>

Why "bother" with multiple tabs? You'd need to create a query for each
"CELL" condition, and a form for each query, then add each of these forms as
subforms to the tab/page.

Another approach would be to have a single combobox in the header of a
single form. The user picks a "CELL", the combobox's AfterUpdate event
requeries the form, and the form's source is based on a query that uses the
combobox's value as a selection criterion.

Someone wants to see a different "CELL"s data? Select the CELL and it
shows.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Pixie78]

See, that's the beauty of "any advice", sometimes it's better than planned.
I thought the tabs would be going about it the long way, just thought it
would be easy to view but the combo box is a great suggestion and I've
already built the form for it and it's just as easy as flipping though tabs.
Thank you!