variable

[JIMMIE WHITAKER]

This works fine:

Dim STRSQL, VTEMP
VTEMP = Text3
STRSQL = "SELECT * FROM Instructors" _
& " WHERE FIRSTNAME LIKE ('s' + '%')"
Form_INSTDATA.RecordSource = STRSQL

This does not work:
Dim STRSQL, VTEMP
VTEMP = Text3
STRSQL = "SELECT * FROM Instructors" _
& " WHERE FIRSTNAME LIKE (text3 + '%')"
Form_INSTDATA.RecordSource = STRSQL

I tried with vtemp, quotes, no quotes, quoting every way you can possible
imagine. I spent 2 hours quoting various ways.
Tth top one works with the & " WHERE FIRSTNAME LIKE ('s' + '%')"
How do I get a variable in there instead of using a letter?
Access 2000 form and ms sql/msde tables.
Again top deal works like a champ.

[Simon Hayes]

"JIMMIE WHITAKER" <kp*****@worldnet.att.net> wrote in message
news:%%********************@bgtnsc05-news.ops.worldnet.att.net...

This works fine:

Dim STRSQL, VTEMP
VTEMP = Text3
STRSQL = "SELECT * FROM Instructors" _
& " WHERE FIRSTNAME LIKE ('s' + '%')"
Form_INSTDATA.RecordSource = STRSQL

This does not work:
Dim STRSQL, VTEMP
VTEMP = Text3
STRSQL = "SELECT * FROM Instructors" _
& " WHERE FIRSTNAME LIKE (text3 + '%')"
Form_INSTDATA.RecordSource = STRSQL

I tried with vtemp, quotes, no quotes, quoting every way you can possible
imagine. I spent 2 hours quoting various ways.
Tth top one works with the & " WHERE FIRSTNAME LIKE ('s' + '%')"
How do I get a variable in there instead of using a letter?
Access 2000 form and ms sql/msde tables.
Again top deal works like a champ.

Assuming that Text3 is just a string, then something like this should work:

STRSQL = "SELECT * FROM Instructors" _
& " WHERE FIRSTNAME LIKE ('" & Text3 & "' + '%')"

Or this may be slightly simpler:

STRSQL = "SELECT * FROM Instructors" _
& " WHERE FIRSTNAME LIKE ('" & Text3 & "%')"

In general, it's helpful in this situation to print the value of STRSQL
after you've constructed it, because then you can see what SQL is being sent
to the server - you can also paste it into Query Analyzer to help work out
what's wrong.

Simon

[JIMMIE WHITAKER]

Thanks, I got it working. It sure is something how the single and double
quotes have to be arranged for this. I thought I had tryed every way
possible.
The lines below is what worked: AGAIN THANK VERY MUCH.

Private Sub Command7_Click()
Dim STRSQL
STRSQL = "SELECT * FROM Instructors" _
& " WHERE FIRSTNAME LIKE ('" & Text3 & "%')"
Form_INSTDATA.RecordSource = STRSQL
End Sub

"Simon Hayes" <sq*@hayes.ch> wrote in message
news:41**********@news.bluewin.ch...

"JIMMIE WHITAKER" <kp*****@worldnet.att.net> wrote in message
news:%%********************@bgtnsc05-news.ops.worldnet.att.net...

This works fine:

Dim STRSQL, VTEMP
VTEMP = Text3
STRSQL = "SELECT * FROM Instructors" _
& " WHERE FIRSTNAME LIKE ('s' + '%')"
Form_INSTDATA.RecordSource = STRSQL

This does not work:
Dim STRSQL, VTEMP
VTEMP = Text3
STRSQL = "SELECT * FROM Instructors" _
& " WHERE FIRSTNAME LIKE (text3 + '%')"
Form_INSTDATA.RecordSource = STRSQL

I tried with vtemp, quotes, no quotes, quoting every way you can possible imagine. I spent 2 hours quoting various ways.
Tth top one works with the & " WHERE FIRSTNAME LIKE ('s' + '%')"
How do I get a variable in there instead of using a letter?
Access 2000 form and ms sql/msde tables.
Again top deal works like a champ.


Assuming that Text3 is just a string, then something like this should

work:
STRSQL = "SELECT * FROM Instructors" _
& " WHERE FIRSTNAME LIKE ('" & Text3 & "' + '%')"

Or this may be slightly simpler:

STRSQL = "SELECT * FROM Instructors" _
& " WHERE FIRSTNAME LIKE ('" & Text3 & "%')"

In general, it's helpful in this situation to print the value of STRSQL
after you've constructed it, because then you can see what SQL is being sent to the server - you can also paste it into Query Analyzer to help work out
what's wrong.

Simon