The information in this article applies to:
SYMPTOMS
Advanced: Requires expert coding, interoperability, and multiuser skills.
If you choose the Analyze It With MS Excel button or the Output To Microsoft Excel command, you may receive the error message:
CAUSEThese errors can occur if the report is based on a query containing a built-in financial function or if one of the text boxes in the report contains an error that returns the "#Error" message. RESOLUTIONPerform the calculation using the financial function in the report itself, not in the query the report is based on. Also, make sure to fix any invalid expressions in the ControlSource property of any text box that returns the "#Error" message. STATUS
Microsoft has confirmed this to be a problem in Microsoft Access version
2.0. This problem no longer occurs in Microsoft Access version 7.0.
MORE INFORMATIONSteps to Reproduce Problem
REFERENCESFor more information about the Output To command, search for "Output To" then "Output To Command (File Menu)" using the Microsoft Access Help menu. Additional query words: interoperability
Keywords : kberrmsg kbusage OtpProb |
Last Reviewed: April 9, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |