Re: Dcount error

Tech-Archive recommends: Fix windows errors by optimizing your registry

Yes

The query work as expected, no errors, by itself or with a report.

"Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx> wrote in message
news:e$1CmxNLHHA.3952@xxxxxxxxxxxxxxxxxxxxxxx
Is the SQL in strSQL correct? (can you run the query afterwards without an
error)?

The misleading error message you're getting is common if a field or table
name is mistyped.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Aaron" <nomail@xxxxxxxxxx> wrote in message
news:V%Ilh.236$nk6.82@xxxxxxxxxxxxxxx
In a Dcount statement I have been using, I'm suddenly getting a:

"Runtime Error: 2001, You Cancelled the previous operation".

The context is:
Set dbs = CurrentDb()
Set qdf = dbs.CreateQueryDef("qryTempRptQry", strSQL)
RC = DCount("*", "qryTempRptQry") ' <--**** Highlighted error
***
If RC = 0 Then

I'm getting this error in one App & not the other using exact same
syntax, sames references. The query is being created and contains
records in the faiuling app,(with the Dcount test commented).

Any suggestions appreciated.





.