Runtime error: '2001'

[jerry28ph]

A strange Runtime Error appears after a click my command button containing my Dlookup functions. Any idea what does it mean?

********************************
* Runtime Error: '2001'
*
* You canceled the previous operation.
*
********************************

Please I need your advise.
Thanks.
JE

 

[missinglinq]

This is one of those strange Access errors! What it usually means in DLookup() functions, in my experience, is that nothing was found because the syntax used for the DLookup() was flawed.

Can you give us the code you're using, as well as the Datatype for the field you're using in your Where clause?

 

[jerry28ph]

Hi, this is the code i am working:

Text476 = DLookup("TDirect", "Smdr Qry_Total_Direct")
Text474 = DLookup("ttcec", "Smdr Qry_Total_CCEC_PC")
Text479 = DLookup("TQueue", "Smdr Qry_Total_Queue")
Text481 = DLookup("NCCEC", "Smdr Qry_Total_CCEC")
Text483 = DLookup("SumOftime", "Query of Total Talk Time CCEC")
Text485 = DLookup("SumOftime", "Query of Total Talk Time (CCEC) - Direct")
Text487 = DLookup("SumOftime", "Query of Total Talk Time (CCEC) - Queue")
Text489 = DLookup("TCalls", "Smdr Qry_Total_Outgoing")
Text491 = DLookup("SumOfTime", "Query of Total Talk Time Outgoing Calls")

I didn't put the criteria into DLookup, coz it's already mentioned in the query.

tHIS IS MY QUERY FOR TEXT476:

SELECT TabLogs.Party1Name, TabLogs.Dialled_number, TabLogs.Direction, TabLogs.[Call duration], TabLogs.[Call start]
FROM TabLogs
WHERE (((TabLogs.Party1Name)=[forms]![FrmLog]![combo17]) AND ((TabLogs.Dialled_number)=[forms]![FrmLog]![text135]) AND ((TabLogs.Direction)=[forms]![FrmLog]![text30]) AND ((TabLogs.[Call duration])<>#12/30/1899#) AND ((TabLogs.[Call start]) Between [forms]![frmLog]![text295] And [forms]![frmLog]![text297]));

Data types:

Party1name = Text
Dialled_number = Text
Direction = Text
Call Duration = Date/Time
Call Start = Date/Time


Please.

This is one of those strange Access errors! What it usually means in DLookup() functions, in my experience, is that nothing was found because the syntax used for the DLookup() was flawed.

Can you give us the code you're using, as well as the Datatype for the field you're using in your Where clause?