UtterAccess.com
We have detected that you are using an unsupported web browser. We recommend you to upgrade your web browser to get the most from UtterAccess forums.
Why should and how can I upgrade?
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Runtime Error 3464    
 
   
Golfnutt
post Apr 18 2007, 11:49 AM
Post #1

UtterAccess Guru
Posts: 654
From: Michigan



I receive a runtime error 3464 when running the below code, which is from my Customer Contacts Table
e.CustomerName = DLookup("CustomerName", "TblCustomerInfo", "[Customer_Code] = " & Me.Customer_Code)
Customer_Code is a text data type
Go to the top of the page
 
+
fkegley
post Apr 18 2007, 12:46 PM
Post #2

UtterAccess VIP
Posts: 23,630
From: Mississippi



Try this instead:
e.CustomerName = DLookup("CustomerName", "TblCustomerInfo", "[Customer_Code] = '" & Me.Customer_Code & "'")
Go to the top of the page
 
+
Golfnutt
post Apr 18 2007, 01:38 PM
Post #3

UtterAccess Guru
Posts: 654
From: Michigan



Excellent!
Im still trying to learn about the proper syntax structure.
All those single and double quotes are very confusing.
Thanks again Frank
Go to the top of the page
 
+
fkegley
post Apr 18 2007, 01:49 PM
Post #4

UtterAccess VIP
Posts: 23,630
From: Mississippi



Yes, they are. The single quote is used inside double quotes, normally to delimit a text value. # are used around date values, nothing around numbers that are not dates.
You're welcome. I am glad I could help.
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Search  ·  Go to Top  ·  Lo-Fi Version Time is now: 29th August 2014 - 11:15 AM