Outputting a report with subreports

[mbaddar]

Hi,

Does anyone know if you can output a report that contains subreports to a Word file. When I try to Save my report to a Word file using the output method I always get a message box, "Cannot process subreports using Save as."

Thanks,
MB

 

[LonnieJohnson]

I tried the Export as Rich Text Format and it worked for me. ljprodev@yahoo.com
Professional Development
MS Access Applications

 

[Watermelon]

Hi Lonnie,

Did you use the "outputto" method for this?

Thanks,
MB

 

[LonnieJohnson]

Yes.

DoCmd.OutputTo acOutputReport, "MyReportName", acFormatRTF, "c:\MyFileName.doc"

Hope this helps... B-) ljprodev@yahoo.com
Professional Development
MS Access Applications

 

[LonnieJohnson]

Private Sub Description_AfterUpdate()

ID = DLookup("EV200_EVENT_ID", _
"EV200_EVENT_MASTER", _
"EV200_EVENT_DESC = '" & Description & "'&quot

End Sub

The above state says this:

The field on your form called ID will equal the value that gets looked up in the column EV200_EVENT_ID of table EV200_EVENT_MASTER where the EV200_EVENT_DESC column of the table matches the value in your combo box called Description.

If this does not work. Maybe you can send me the form and the table in a database and I can take a closer look.

B-) ljprodev@yahoo.com
Professional Development
MS Access Applications

 

[mbaddar]

Hi Lonnie,

Thanks for your response and I hope you check this again. I tried the code that you had and I still am getting the "The Save as Command cannot process any subforms in your report?" Any ideas? My report is mostly subforms and reports and I really can't change this.

Thanks,
MB