too many fields

  • Thread starter Thread starter mcnewsxp
  • Start date Start date
M

mcnewsxp

i have to create access form that mimic survey forms that contain lots of
questions and therefore lots of fields.
these are usully toss-aways and only used for short periods of time, then
when they serve their purpose they are deleted. the end-users usually want
their data as flat as can be. i like to use table binding because i don't
have to code any IO.
what are some of you doing do deal with this situation? for example, my
latest one will need mimic a two page form. each will have over 200 fields.
NOTE: any talk of re-usability and data normalization will fall on deaf
ears. the only reason we're using ms access for these applications is for
it's quick-and-dirtynesss.
so i'm just looking for some quick-and-dirty tips.
thanks much,
mc
 
each will have over 200 fields.
NOTE: any talk of re-usability and data normalization will fall on deaf
ears. the only reason we're using ms access for these applications is for
it's quick-and-dirtynesss.
so i'm just looking for some quick-and-dirty tips.
Click to expand...

<shrug>

Ok, if you want to misuse Access and work against it rather than with
it, I can't say much.

You've seen Duane Hookum's AtYourSurvey sample survey database? It's a
readily adaptable NORMALIZED template for just this circumstance. But
of course you don't want to use a normalized database, so...

John W. Vinson[MVP]
 
<shrug>

Ok, if you want to misuse Access and work against it rather than with
it, I can't say much.

You've seen Duane Hookum's AtYourSurvey sample survey database? It's a
readily adaptable NORMALIZED template for just this circumstance. But
of course you don't want to use a normalized database, so...
Click to expand...

so why waste my time and yours.
as far as i can tell that is why most people that i work with use access -
for quick and dirty so they can move their data from the field to a real DB.
surely some of the access folks that visit here have some D&D tricks of the
trade that allow you to use large flat files.
tia,
mcnewsxp
 
Back
Top