syntax question

[dumdum2]

Is it possible to use a select statement for a query instead of a table? If so, what is the syntax?

With rst
.PageSize = 8
.ActiveConnection = cn
.Source = "SELECT * FROM 'search query'"
.LockType = adLockOptimistic
.CursorType = adOpenStatic
.Open
End With

Thanks-

 

[PHV]

Perhaps this ?
.Source = "SELECT * FROM [search query]"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dumdum2]

Thanks, I tried that but I'm still getting a run-time error: "No value given for one or more parameters" and stops on the .Open command. So I guess the Select statement is working, but something must be wrong with the query.....?

 

[PHV]

AFAIK you can't use a parametized query in ADO ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dumdum2]

guess i am dumb....what is AFAIK ?

how best can i narrow the recordset?

 

[PHV]

As Far As I Know

 

[dumdum2]

ah ha.....

do you know how i can narrow the recordset?

 

[lespaul]

why not just put the SQL of [Search Query] in your code?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[dumdum2]

Thanks, I tried that also--but it didn't work.......I replaced the select statement with the sql statement....is that the wrong place to put it??

 

[lespaul]

what's the SQL you tried of the Search query?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[dumdum2]

SELECT timage.*, InStr([Keywords],[Forms]![search]![searchtext]) AS Expr1
FROM timage
WHERE (((InStr([Keywords],[Forms]![search]![searchtext]))>0));


thanks-

 

[PHV]

Perhaps this ?

.Source = "SELECT timage.*, InStr([Keywords],'" & [Forms]![search]![searchtext] & "') AS Expr1" _
 & " FROM timage WHERE InStr([Keywords],'" & [Forms]![search]![searchtext] & "'))>0"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dumdum2]

that works! great, thanks!