DLookup you cancelled the previous operation

[Maverick6197]

Does anyone know what is wrong with the following code:

I'm trying to use this to pull an e-mail address from a table based on the
dealer and then e-mail a report to that e-mail using the Win2pdf mail helper
program. Everything seems to work fine except the DLookup....

___________________________________________________________________________

Dim AUTACCode As String

AUTACCode = DLookup("[E-MAIL_CONTACT]", "tblMasterDealerContact", "
[AUTAC_LOOKUP_CODE] = '" & Me![txtAUTACLookup] & "'")

E-MAIL_CONTACT is a field in tblMasterDealerContact
AUTAC_LOOKUP_CODE is a field in tblMasterDealerContact

SaveWin2PDFDword "file options", &H41
SaveSetting "Dane Prairie Systems", "Win2PDF", "PDFMailRecipients",
AUTACCode
SaveSetting "Dane Prairie Systems", "Win2PDF", "PDFMailSubject",
"Warranty Request Denial Notification"
SaveSetting "Dane Prairie Systems", "Win2PDF", "PDFMailNote", "Please see
the attached document concerning a Warranty Request filed with Astec
Underground."
SaveSetting "Dane Prairie Systems", "Win2PDF", "PDFFileName", "C:\
Documents and Settings\cau1042\Desktop\rptDeniedClaim.pdf"
DoCmd.OpenReport "rptDeniedClaim", acViewNormal

________________________________________________________________________________


txtAUTACLookup is a control on my form. Its data source is =((Forms!frmClaim!
cmbDealerNumber) & "WM")

Everytime I run the code it gives me the "You cancelled the previous
operation." error.

The 2 fields from my table actually have spaces not underscores, but I've
tried it both ways.

tblMasterDealerContact is a linked Excel file.

Any help would be greatly apprecitated. Thanks again.

Shannan

 

[Klatuu]

That error is misleading. It usually means one of the names in the DLookup
doesn't match the names in the table. The issue is that Access sends the
request to Jet and waits for a reply. Jet can't find the name, so can't
complete the request, so it tells Access it has canceled the request. Access
then raises that error.
Be sure the spelling of all the names both table and field are correct. The
only other thing is to ensure your syntax is correct for the data type of the
field in the criteria argument. As written, it is expecting
[AUTAC_LOOKUP_CODE] to be a text data type.

 

[Maverick6197]

Yes. [AUTAC_LOOKUP_CODE] is a text field as are the rest of the fields in
the code.

That error is misleading. It usually means one of the names in the DLookup
doesn't match the names in the table. The issue is that Access sends the
request to Jet and waits for a reply. Jet can't find the name, so can't
complete the request, so it tells Access it has canceled the request. Access
then raises that error.
Be sure the spelling of all the names both table and field are correct. The
only other thing is to ensure your syntax is correct for the data type of the
field in the criteria argument. As written, it is expecting
[AUTAC_LOOKUP_CODE] to be a text data type.

Does anyone know what is wrong with the following code:

[quoted text clipped - 40 lines]

Shannan

 

[Maverick6197]

Nevermind. I took the underscores out of the equation and it worked. Thanks
for your help.

Yes. [AUTAC_LOOKUP_CODE] is a text field as are the rest of the fields in
the code.

That error is misleading. It usually means one of the names in the DLookup
doesn't match the names in the table. The issue is that Access sends the

[quoted text clipped - 10 lines]