ACC2: "Output To" Command Fails with Financial Functions

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

SYMPTOMS

Advanced: Requires expert coding, interoperability, and multiuser skills.

When you choose the Publish It With MS Word button or the Output To Rich Text Format command while you are previewing a report, you may receive the following error message:

   Can't obtain this property setting. The property may not be
   available in this view, or an error has occurred.

If you choose the Analyze It With MS Excel button or the Output To Microsoft Excel command, you may receive the error message:

   Can't evaluate expression.

CAUSE

These 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.

RESOLUTION

Perform 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 INFORMATION

Steps to Reproduce Problem

  1. Open a new database.

  2. Create and save the following new table:

          Table: Table1
          --------------------
          Field Name: Rate
    
             Data Type: Number
             Field Size: Single
          Field Name: Term
             Data Type: Number
             Field Size: Long Integer
          Field Name: Amount
             Data Type: Number
             Field Size: Long Integer
    
    

  3. Enter the following data as the first record in Table1:

          Rate: 0.09
          Term: 15
          Amount: 573750
    

  4. Create the following new query based on Table1:

          Query: Query1
          --------------------------------------
          Type: Select Query
          Field: Rate
          Field: Term
          Field: Amount
          Field: Pmt([Rate],[Term],[Amount],0,0)
    

  5. Run the query. Note that a negative number appears in the calculated field. Save the query as Query1 and then close it.

  6. Select the Query1 query in the Database window and then choose the AutoReport button on the toolbar.

  7. While you are previewing the new report, choose the Publish It With MS Word button on the toolbar. The first error message stated above occurs.

REFERENCES

For 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
Version : 2.0
Platform : WINDOWS
Hardware : X86
Issue type : kbbug
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 14, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.