Use QBE Grid with Double-Quotes and/or Apostrophe

[ryguy7272]

In the QBE Grid, with Like "INT'L" in Criteria, my Query works fine. It
fails when I try to create a dynamic Query with this VBA:

' Build criteria string for Broker
For Each varItem In Me.lstBroker.ItemsSelected
strBroker = strBroker & ",'" & Me.lstBroker.ItemData(varItem) & "'"
Next varItem
If Len(strBroker) = 0 Then
strBroker = "Like " * ""
Else
strBroker = Right(strBroker, Len(strBroker) - 1)
strBroker = "IN(" & strBroker & ")"
End If

I’m sure it has to do with the ‘ in the INT’L. I tried quotes and
double-quotes, like this:
strBroker = "Like " * ""


Can’t seem to quite get it working though.

Can anyone see what the problem is?

Regards,
Ryan---

 

[Jeanette Cunningham]

Ryan,
the general idea is to use 3 double quotes instead of one double quote, one
single quote and another double quote
Separated for clarity that is:
Use " " " instead of " ' "

use """ & Me.lstBroker.ItemData(varItem) & """
instead of
'" & Me.lstBroker.ItemData(varItem) & "'


Jeanette Cunningham

 

[ryguy7272]

BRILLIANT!!

Thanks for the help last time and thanks for the help this time!!


Ryan--
PS, thanks, in advance, for the help next time...there will probably be a
next time as well...