Subforms, reports and exporting

[Marc]

Hi,
I have a database with several tables I need to group and
show together for output to rtf. I tried creating forms
for each table, then using subforms to get them all
together. I saved the form with subforms as a report.
It looks great on screen, but when I try to export to rtf
format, it does not export the subforms.
Is there any way around this? Am I approaching this wrong,
is there a better way?

Thanks,

Marc

 

[Hugh O'Neill]

Hi,
I have a database with several tables I need to group and
show together for output to rtf. I tried creating forms
for each table, then using subforms to get them all
together. I saved the form with subforms as a report.
It looks great on screen, but when I try to export to rtf
format, it does not export the subforms.
Is there any way around this? Am I approaching this wrong,
is there a better way?

Thanks,

Marc

Yes, I think you may be! Using Forms for printing is not what they are
for. It's much better to use Reports for printing.

hth

Hugh

 

[Marc]

-----Original Message-----



Yes, I think you may be! Using Forms for printing is not what they are
for. It's much better to use Reports for printing.

hth

Hugh
.
Hi Hugh,

Sorry, I didn't make myself very clear. After I created
the form that has the subforms in it, I'm using the "File-
Save As" function to save it as a report. So I am trying
to use a report for output. When I view the report on
screen, or print it out, it looks great.
I'm then trying to export the Report as an rtf document.
I get the error message "The Save As command can't process
any subforms contained in your report". The rtf document
then only contains the information that was on the main
form.

Any ideas. By the way, I'm in Access 2000 on Windows 98.

Thanks,

Marc

 

[Rick Brandt]

Sorry, I didn't make myself very clear. After I created
the form that has the subforms in it, I'm using the "File-
Save As" function to save it as a report. So I am trying
to use a report for output. When I view the report on
screen, or print it out, it looks great.
I'm then trying to export the Report as an rtf document.
I get the error message "The Save As command can't process
any subforms contained in your report". The rtf document
then only contains the information that was on the main
form.

Two things. When you saved the main form as a report any subforms within are still
subforms in the report. They are not all copied as subreports. You would need to
save those as reports separately and then revise the main report so it is referencing
the subreport objects instead of the subforms.

Second: Exporting to RTF will likely not produce anything even remotely resembling
your forms/reports as RTF processing removes all graphical attributes. You will lose
all lines, boxes, background colors, etc..

 

[Marc]

-----Original Message-----


Two things. When you saved the main form as a report any subforms within are still
subforms in the report. They are not all copied as subreports. You would need to
save those as reports separately and then revise the main report so it is referencing
the subreport objects instead of the subforms.

Second: Exporting to RTF will likely not produce anything even remotely resembling
your forms/reports as RTF processing removes all

graphical attributes. You will lose

all lines, boxes, background colors, etc..

Thanks Rick,

Good point on number two above. I may have to approach
this differently.
Thanks for your advice.

Marc