R
Rob Parker
Can anyone explain to me why I get this error message from a Report, which
is based on the same recordsource as a form, and was generated by saving the
form as a report (with some subsequent tweaking to remove form-only
controls, change typeface, etc). The form works fine, the report doesn't -
it gives the error message. (Using Access 97)
The underlying query (based on a set of cross-tab queries, all based on a
single table but with a couple of fields from joined tables) contains 167
fields. The form (and report) present a table summarizing 15 years cost
data in 10 different categories fro each record, together with a total for
each row; the form/report footer section contain Sum fields for each of
these fields. In total, there are approx. 380 controls on both the form and
in the report (well under the 754 limit).
I've compacted (and repaired) the database - still the same error. I've cut
and pasted the controls from the report into a new report - same error.
I've re-generated the report from the form (via "Save as report"), and with
absolutely no tweaking at all it still gives the same error.
I finally got it to work - the application had to be delivered today - by
designing a separate subreport containing the Sum fields, and including that
in the report footer. Not pretty, but it worked.
What I really would like to know is why the form works, but the report
doesn't.
TIA,
Rob
is based on the same recordsource as a form, and was generated by saving the
form as a report (with some subsequent tweaking to remove form-only
controls, change typeface, etc). The form works fine, the report doesn't -
it gives the error message. (Using Access 97)
The underlying query (based on a set of cross-tab queries, all based on a
single table but with a couple of fields from joined tables) contains 167
fields. The form (and report) present a table summarizing 15 years cost
data in 10 different categories fro each record, together with a total for
each row; the form/report footer section contain Sum fields for each of
these fields. In total, there are approx. 380 controls on both the form and
in the report (well under the 754 limit).
I've compacted (and repaired) the database - still the same error. I've cut
and pasted the controls from the report into a new report - same error.
I've re-generated the report from the form (via "Save as report"), and with
absolutely no tweaking at all it still gives the same error.
I finally got it to work - the application had to be delivered today - by
designing a separate subreport containing the Sum fields, and including that
in the report footer. Not pretty, but it worked.
What I really would like to know is why the form works, but the report
doesn't.
TIA,
Rob