Multiple Forms Entry

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

Guest

I have two tables, each keyed by [ID]. I also have two forms - one whose
record source is table 1 and another form whose record source is table 2.
I'd like to be able to use one form for data entry but am running into a "too
many controls on form" issue.

Is there a way for me to copy the controls on form 2 into a subform that I
place on form 1? Or, can I link the two forms together (seemlessly) so some
controls on the combined form update table 1 and other controls update table
2?

Mike
 
How many controls do you have on each form? The limit for controls is
something over 700; however, this is not the number of controls currently on
the form, but a lifetime accumulation. Each time you add a control, it adds
1 to the count, but deleteing a control does not subtract from the count.

Before you do anything rash, try doing a compact and repair on your
database. This may reset the count.
 
I have two tables, each keyed by [ID]. I also have two forms - one whose
record source is table 1 and another form whose record source is table 2.
I'd like to be able to use one form for data entry but am running into a "too
many controls on form" issue.
Click to expand...

How many controls do you have!? There's a limit of over 700 controls
on a Form - however, this is a cumulative count of all the controls
ever added, and deleting controls doesn't recover them. You'll be able
to do so by creating a new form and copying and pasting controls from
your old form onto it.
Is there a way for me to copy the controls on form 2 into a subform that I
place on form 1? Or, can I link the two forms together (seemlessly) so some
controls on the combined form update table 1 and other controls update table
2?
Click to expand...

How are Table1 and Table2 related? Normally if you have a one to many
(or, very rarely, one to one) relationship, you can use a Form for the
"parent" table with a Subform for the "child"; each form would have
controls bound to its table.

I *very* strongly suspect that you're having trouble, not because of
your form design, but because of your *table* design. If you have two
tables both keyed by the same ID in order to get around the 255 field
limit - your table structure IS WRONG and is the source of your
troubles. Could you describe your tables?

John W. Vinson[MVP]
 
I know it sounds bad, knowing things about DB design but I have a survey with
a couple hundred questions, and three ratings each. I also have labels so I
know what question I'm on ,etc. Table 1 and 2's tie to one another is the
ID, which really is the questionaire number.

That's how I get over 255 columns in a table. My other table - table 2 - is
more of the same (as table 1) plus other types of questions.

John Vinson said:
I have two tables, each keyed by [ID]. I also have two forms - one whose
record source is table 1 and another form whose record source is table 2.
I'd like to be able to use one form for data entry but am running into a "too
many controls on form" issue.
Click to expand...

How many controls do you have!? There's a limit of over 700 controls
on a Form - however, this is a cumulative count of all the controls
ever added, and deleting controls doesn't recover them. You'll be able
to do so by creating a new form and copying and pasting controls from
your old form onto it.
Is there a way for me to copy the controls on form 2 into a subform that I
place on form 1? Or, can I link the two forms together (seemlessly) so some
controls on the combined form update table 1 and other controls update table
2?
Click to expand...

How are Table1 and Table2 related? Normally if you have a one to many
(or, very rarely, one to one) relationship, you can use a Form for the
"parent" table with a Subform for the "child"; each form would have
controls bound to its table.

I *very* strongly suspect that you're having trouble, not because of
your form design, but because of your *table* design. If you have two
tables both keyed by the same ID in order to get around the 255 field
limit - your table structure IS WRONG and is the source of your
troubles. Could you describe your tables?

John W. Vinson[MVP]
Click to expand...
 
I know it sounds bad, knowing things about DB design but I have a survey with
a couple hundred questions, and three ratings each. I also have labels so I
know what question I'm on ,etc. Table 1 and 2's tie to one another is the
ID, which really is the questionaire number.

That's how I get over 255 columns in a table. My other table - table 2 - is
more of the same (as table 1) plus other types of questions.
Click to expand...

That's what I was suspecting.

Check out a totally different technique which will:
- allow any desired number of questions
- allow you to add, change, or delete questions without redoing all
your tables, queries, forms, and reports
- allow much easier summaries and analysis of survey results

All in Duane Hookum's excellent sample database "At Your Survey":

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'


John W. Vinson[MVP]
 
Back
Top