DLookup and single and double quotes

[Yannick Turgeon]

Hello all,

I'm using A97.

Say I've got a table "myTable" with two fields: "PK" and "Description"

Say my table has three rows:

PK Description
1 Elvis "The King" Presley
2 Jack "C'mon" Black
3 Bob "The Wonder" Dylan

My question is: How can I use de DLookup function to find the PK if I'm
searching for a Description with both single and double quote in it?

Ex: myPK = DLookUp("PK", "myTable", "Description = ??? )

Thanks for your help.

Yannick

[Billie Dee]

You're going to have some fun but ...
First off - strings are surrounded by single quotes
Then - double up all your quotes - both types

Sub Test()
Dim varAnswer As Variant
varAnswer = DLookup("PK", "myTable", "[Description]= 'Bob ""The
Wonder"" Dylan'")
If Not IsNull(varAnswer) Then
MsgBox "First one is: " & varAnswer
Else
MsgBox "Error finding first item"
End If
varAnswer = DLookup("PK", "myTable", "[Description]= 'Jack ""C''mon""
Black'")
If Not IsNull(varAnswer) Then
MsgBox "Second one is: " & varAnswer
Else
MsgBox "Error finding second item"
End If
End Sub

I hope this helps
Billie Dee