As usual Rick, so clear explanations... I've learned so much from your videos.. You are truly a master. In the past, i had no idea how to deal with that syntax and all i did, was trying all the possibilities to make this to work. But now, everything looks so easy.. Thanks a lot!
Don't you want IsNull(S) in your DDQ function? I knew this would be related to Apostrophes but I think Chr(34) & Replace(s,"'","''") & chr(34) still works in those cases. (for my Qt function)
Thanks Richard for stating your reasons. There is a workaround to escape the single quote character. Infact, I wrote a function to put the single quotes to clear the headaches all together. Anyone may try it to see. The function assumes the string would not contain double quotes. Copy and paste function to a module to see the single quotes and escapes clearly. The function can be enhanced to handle double quote. I just think there very slim chances anyone would come across DDQ in a string. ==================== Function replace_escape_quotes(textValue) as String If IsNull(textValue) Then Exit Function replace_escape_quotes= "'" & Replace(textValue, "'", "''") & "'" End Function ==================== With this function all you need to do is call the custom function inside the Dlookup =DLookUp("[CreditLimit]","[CustomerT]","[LastName] = " & replace_escape_quotes(Lastname)) The custom function removes the whole headache altogether. I tested for O'Brien and it worked perfectly. I'm very comfortable with DDQ, but single quotes are more readable and modern programming languages like Python makes it even easier to use.
Dear Richard .you are only and one hope for access developers....may you live long...keep it up legend Richard ...love from pakistan
Thanks
The "mystery" of the DDQ solved! Thanks for the great explanation on how Access treats single and double quotes!
Glad it was helpful!
As usual Rick, so clear explanations... I've learned so much from your videos.. You are truly a master. In the past, i had no idea how to deal with that syntax and all i did, was trying all the possibilities to make this to work. But now, everything looks so easy..
Thanks a lot!
You are very welcome
10:01. Hi, Richard, I was expecting to see "If IsNull(S) Then" instead of "If IsNull(DDQ) Then"...
Do you think he left this there to test if we're paying attention...?
Always read the description
Uh... yeah... uh... it's a test. :)
I knew it...! 🤓
thanks
Welcome
Don't you want IsNull(S) in your DDQ function? I knew this would be related to Apostrophes but I think Chr(34) & Replace(s,"'","''") & chr(34) still works in those cases. (for my Qt function)
Yep - always check the notes down below. Realized the error as soon as I posted the video.
Using double double quotes always gives me a headache just like time travel examples.
You were late to our Time Travelers Meeting tomorrow.
Thanks Richard for stating your reasons. There is a workaround to escape the single quote character.
Infact, I wrote a function to put the single quotes to clear the headaches all together.
Anyone may try it to see. The function assumes the string would not contain double quotes.
Copy and paste function to a module to see the single quotes and escapes clearly. The function can be enhanced to handle double quote. I just think there very slim chances anyone would come across DDQ in a string.
====================
Function replace_escape_quotes(textValue) as String
If IsNull(textValue) Then Exit Function
replace_escape_quotes= "'" & Replace(textValue, "'", "''") & "'"
End Function
====================
With this function all you need to do is call the custom function inside the Dlookup
=DLookUp("[CreditLimit]","[CustomerT]","[LastName] = " & replace_escape_quotes(Lastname))
The custom function removes the whole headache altogether. I tested for O'Brien and it worked perfectly.
I'm very comfortable with DDQ, but single quotes are more readable and modern programming languages like Python makes it even easier to use.
Oh sure... there's always multiple ways to deal with an issue. Thanks for sharing. :)
Thanks for steering my learning. I had to do some digging. 😀
Handy for dealing with Klingon.
It does kinda look like Klingon, huh? DdQ' NoT sQ!