ACC2000: Cannot Export a Report with a Datasheet Form As a Subreport (207489)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q207489
Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SYMPTOMS

When you try to export a report that contains a form in Datasheet view as a subreport to another file format such as Text (*.txt), Microsoft Excel (*.xls), or Rich Text Format (*.rtf), you may receive the following message:
The Save As command can't process any subforms contained in your report.
This behavior can occur regardless of the file format to which you output the report.

RESOLUTION

To work around this behavior, save the datasheet form as a report before you output the main report. To do so, follow these steps:
  1. In the Database window, click Forms under Objects, and then right-click the form. Click Save As on the menu that appears.
  2. In the Save Form 'MyForm' To text box, type a name for the subreport (for example, MySubReport), select Report in the As box, and then click OK.
  3. Open the main report in Design view.
  4. Right-click the control that contains the datasheet form, and then click Properties to display the Properties sheet, if it is not already visible.
  5. Click the Data tab, and then change the Source Object from Form.MyForm to Report.MySubReport, where MyForm is the name of the datasheet form and MySubReport is the name of the report you saved in step 2.

MORE INFORMATION

CAUTION: If you follow the steps in this example, you modify the sample Access project NorthwindCS.adp. You may want to back up the NorthwindCS.adp file and follow these steps on a copy of the project.

Steps to Reproduce Behavior

  1. Start Microsoft Access, and then open the sample database Northwind.mdb or the sample project NorthwindCS.adp.
  2. In the Database window, click Forms under Objects, and then click New.
  3. In the New Form dialog box, click AutoForm: Datasheet.
  4. Click Shippers in the combo box to select the table where the form's data comes from, and then click OK.
  5. On the File menu, click Close. When you are prompted to save changes to the design of the form, click Yes, and then type frmShippers in the Form Name box. Click OK.
  6. In the Database window, click Reports under Objects, and then click New.
  7. In the New Report dialog box, click Design view, and then click OK to create a new, unbound report.
  8. On the Window menu, click Tile Vertically.
  9. In the Database window, click Forms under Objects, and then drag the frmShippers form to the Detail section of the new report.
  10. On the File menu, click Export.
  11. In the Export Report 'Reportx' To dialog box, click Rich Text Format (*.rtf) in the Save as type list box, and then click Save. You receive the error message described in the "Symptoms" section. You must click No to dismiss the error message. The output file is not created.
Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kbprb KB207489
©2004 Microsoft Corporation. All rights reserved.