Invalid Procedure Call

  • Thread starter Thread starter Guest
  • Start date Start date
G

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????
 
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)
 
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


Van T. Dinh said:
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)



Magnetic Dave said:
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????
Click to expand...
Click to expand...
 
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
 
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)
 
Back
Top