ACC2002: Error on Report with Subform When You Use "Publish It with Microsoft Word" Command (289908)



The information in this article applies to:

  • Microsoft Access 2002

This article was previously published under Q289908
Moderate: Requires basic macro, coding, and interoperability skills.

For a Microsoft Access 2000 version of this article, see 199079.

SYMPTOMS

When you try to export a report with the "Publish It with Microsoft Word" OfficeLinks command, you may receive the following message:
The Save As command can't process any subforms contained in your report.

Do you want to proceed anyway?
If you respond to the message by clicking Yes, the report is still exported with the subform part being blank.

If you respond to the message by clicking No, the report is still exported with the subform part omitted.

CAUSE

This behavior occurs if the report that you are exporting contains a subform instead of a subreport.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Open the sample database Northwind.mdb.
  2. Create a new report in Design view that is based on the Categories table.
  3. Save the report.
  4. In the toolbox, click the Subform/Subreport button, and then drag the object to the detail section of the report to start the Subform/Subreport Wizard.
  5. On the first page of the wizard, click Use an existing report or form, click the Products form in the list, and then click finish.
  6. On the File menu, click Print Preview.
  7. On the Tools menu, click the down arrow to the right of OfficeLinks button, and then click Publish It with Microsoft Word.

    Note that when the wizard starts outputting the file, you receive the message that is mentioned in the "Symptoms" section of this article.

Modification Type:MajorLast Reviewed:11/5/2003
Keywords:kberrmsg kbprb KB289908