ADO SQL

[Guest]

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 & ")); "

 

[Guest]

I'm think its because the field is text ? but still can't get it to work.

 

[RB Smissaert]

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

 

[Guest]

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]

By the way what does the Chr(34) do ?

That is the double-quote character.
Chr(39) is a single quote.
If your 3 double quotes work then the one with Chr(34) may also work.
I think it gets less confusing if you combining single or double quotes to
use
the character codes instead, so Chr(34) etc.

RBS

 

[PaulD]

FYI single quotes ' work also

so this should work
" WHERE (((MultVend.VEND_PART_NUM)='" & myString & "')); "

: 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
: >
: >
: > : > > 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 & ")); "
: >
: >

 

[RB Smissaert]

Yes, that is the Chr(39)

RBS

 

[Guest]

Thanks RD
I have been at coding for about 8 months at the school of 9pm till 3am LOL
Still learning and thanks for the lesson