471,119 Members | 1,376 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,119 software developers and data experts.

Nested forms, three deep to create Excel-like tables???

NA
Is it possible to have adjustable tables (not Access tables per se) but
those in Ms Word or Excel based on nexted forms three deep? In other words,
if I have a main form, Repair History, both the row and columns would grow
accordingly.
Column Heading: Parts
Row Heading: Repair Description

In this case, I may only know 25% of the parts when creating the table after
which, I would like the user to be able to add both the type of parts as
well as the repair description. So, something like this
***Day 15: New User
Customer info
...
...
...
...

Repair History

Washers Gaskets
Solder
1) Bathroom Sink Leak Repair [SS - s14] [natural ruber -size 00] [
Acid Core - 5feet]
2) Master Shower Repair [Bronze - s20]
***Day 200
Customer info
...
...
...
...

Repair History
Washers
Gaskets Solder Caulk
1) Bathroom Sink Leak Repair [SS - s14] [natural ruber -size 00] [
Acid Core - 5feet]
2) Master Shower Repair [Bronze - s20]
3) Tub Repair
[silicone- 1 tube]

In this case, the users would merely add a column heading 'Caulk', which,
presumably, would be an additional record in the parent table (repair parts)
to the workorders table. This is necessary because the database design
knows little about plumbing and the plumbers know nothing about database
design. I would assume that this could be achieved by nesting the three
forms from the three respective tables three deep. However, I can't seem to
get it to work.

Can Access allow such "tables" to expand both horizontally and vertically?
Note that I do not want to use combo boxes.


Nov 12 '05 #1
1 2332
"NA" <NA@NA.COM> wrote in message news:<40**********************@news.rcn.com>...
Is it possible to have adjustable tables (not Access tables per se) but
those in Ms Word or Excel based on nexted forms three deep? In other words,
if I have a main form, Repair History, both the row and columns would grow
accordingly.
<SNIP>
Can Access allow such "tables" to expand both horizontally and vertically?
Note that I do not want to use combo boxes.


Sounds like a fundamental misunderstanding of database design. Excel
and Access are VERY different. Tables in Access are not really meant
to be adjustable - well, not after you've delivered your solution, say
as an MDE. If you want the users to be able to add fields at runtime,
you're going to make a serious mess of your database. You need to
figure out what information you need to store about each "thing" up
front. You can hide fields on your form, but you really shouldn't let
your users muck with your table design. It'll be impossible to keep
your database working.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by kettch | last post: by
1 post views Thread by Thapliyal, Deepak | last post: by
6 posts views Thread by Licheng Fang | last post: by
PrinsonG
1 post views Thread by PrinsonG | last post: by
2 posts views Thread by Christopher.M.Weber | last post: by
5 posts views Thread by ElPresidente | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.