| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO SQL
Yes, that is the Chr(39)
RBS "PaulD" <nospam wrote in message ... FYI single quotes ' work also so this should work " WHERE (((MultVend.VEND_PART_NUM)='" & myString & "')); " "Mike" wrote in message ... : Thanks but just got it with this i had to have 3 """ instead of 2 "" : WHERE (((MultVend.VEND_PART_NUM)=""" & myString & """)); : By the way what does the Chr(34) do ? : : "RB Smissaert" wrote: : : One of these 3 should work, probably the last: : : strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM, " & _ : "MultVend.VEND_DESC " & _ : "FROM MultVend " & _ : "WHERE (((MultVend.VEND_PART_NUM) = " & _ : myString & ")); " : : strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM, " & _ : "MultVend.VEND_DESC " & _ : "FROM MultVend " & _ : "WHERE (((MultVend.VEND_PART_NUM) = " & _ : Chr(34) & myString & Chr(34) & ")); " : : strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM, " & _ : "MultVend.VEND_DESC " & _ : "FROM MultVend " & _ : "WHERE (((MultVend.VEND_PART_NUM) = " & _ : Chr(39) & myString & Chr(39) & ")); " : : : RBS : : : "Mike" wrote in message : ... : Hi all I'm really at a loss any help would be great : Thanks Mike : : I have SQL that works with no problem : : strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM, : MultVend.VEND_DESC " _ : & " FROM MultVend " _ : & " WHERE (((MultVend.VEND_PART_NUM)=""14002"")); " : : and this will NOT : Where myString = me.textbox1.value : : strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM, : MultVend.VEND_DESC " _ : & " FROM MultVend " _ : & " WHERE (((MultVend.VEND_PART_NUM)=" & myString & ")); " : : |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
