ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ADO SQL (https://www.excelbanter.com/excel-programming/398734-ado-sql.html)

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

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

"Mike" wrote:

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


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



RB Smissaert
ADO SQL
 
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


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

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



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




Mike
ADO SQL
 
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

"RB Smissaert" wrote:

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


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


All times are GMT +1. The time now is 01:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com