ACC2: No Way to Specify Page Range Using Output To Command

 Last reviewed: May 28, 1997
Article ID: Q120059
The information in this article applies to:
  • Microsoft Access version 2.0

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

You can use the Output To command in Microsoft Access to save the output of a table, a query, a form, a report, or a module in one of the following file formats:

  • Microsoft Excel (.XLS)
  • Rich Text Format (.RTF)
  • MS-DOS Text (.TXT)

When you use the Output To command with a report you cannot specify the range of pages that you want. The entire report is output to the file.

RESOLUTION

To work around this behavior, base the report on a query that limits the report's output to the records you want. For example, use a query that limits the records in the report to the top 10 records.

MORE INFORMATION

When you choose Output To from the File menu, the All and Selection buttons are unavailable (appear dimmed) because Microsoft Access does not support specifying a range for the output.

REFERENCES

For more information about the Output To command, search for "Output To," and then "Output To Command" using the Microsoft Access Help menu.

Additional query words: export grayed
Keywords : FmrHowto kbusage
Version : 2.0
Platform : WINDOWS
Hardware : X86
Issue type : kbprb
Resolution Type : kbworkaround

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 28, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.