Invalid Procedure Call

[Guest]

I have an Access 2000 SP3 database query that USED to run, and now Every Time
I try to run it I get "Invalid Procedure Call". It uses Linked tables and
compares two monatary amounts. When I remove the criteria (>0), from the
query, it runs.

In troubleshooting I isolated the comparison in a column:

CHK: IIf([DEBTOR]![PRIN])>[DEBTOR2_01]![CCA_AMT],"Y","N")

The Query runs fine, UNTIL I set a Criteria for this column as "Y", then
again I get "Invalid Procedure Call". The More I seem to work on this, the
more results seem to fail. WHAT IS GOING ON????

 

[Van T. Dinh]

If [DEBTOR] and [DEBTOR2_01] are DataSources (i.e. Tables / Queries) in your
Query, try:

CHK: IIf([DEBTOR].[PRIN])>[DEBTOR2_01].[CCA_AMT],"Y","N")

HTH
Van T. Dinh
MVP (Access)

 

[Guest]

Thank you for your reply, but I still get "Invalid...".

Also, I have other criteria for fields that are NOT calculated, DB_Wkby
<>"MON", and DB2_CCA_Amount >0. When I REMOVE those criteria I also get
"Invalid..." Something odd is going on. Why would this happen???

Thanks in advance,

Magnetic Dave

If [DEBTOR] and [DEBTOR2_01] are DataSources (i.e. Tables / Queries) in your
Query, try:

CHK: IIf([DEBTOR].[PRIN])>[DEBTOR2_01].[CCA_AMT],"Y","N")

HTH
Van T. Dinh
MVP (Access)

I have an Access 2000 SP3 database query that USED to run, and now Every Time
I try to run it I get "Invalid Procedure Call". It uses Linked tables and
compares two monatary amounts. When I remove the criteria (>0), from the
query, it runs.

In troubleshooting I isolated the comparison in a column:

CHK: IIf([DEBTOR]![PRIN])>[DEBTOR2_01]![CCA_AMT],"Y","N")

The Query runs fine, UNTIL I set a Criteria for this column as "Y", then
again I get "Invalid Procedure Call". The More I seem to work on this, the
more results seem to fail. WHAT IS GOING ON????

 

[Van T. Dinh]

Have you check the References of your database?

 

[Guest]

Yup, none of them are Missing. I have references in the following order:

Visual Basic For Applications
Microsoft Access 9.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.1 Library

 

[Van T. Dinh]

I think your computer hasn't been patched with the latest JET (SP8) and MDAC
(version 2.8).

Post the full SQL String of your query and relevant details of the
datasources for the Query / SQL.

HTH
Van T. Dinh
MVP (Access)