Running queries from code

B

Bill

I'm used to opening recordsets in code by passing
the SQL query as a character string. E.g.,
rsMyset.open "Select bla bla bla"
What's the syntax if one wants to run an established
query by specifying the name of the query? The help
text I see suggests that the use of Query("QMyQuery")
is outdated, so I'm in mystery.

Thanks,
Bill
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

running queries in code 2
"Data type mismatch" without any criteria! 6
Passing Query Parameters from form to another VBA subroutine 3
SQL pass thru query from code always propting for DSN 5
union query of complex queries 1
passing array to function to pick up values 4
code to rename image files from query 1
SQL not importing records from ACCDB 2

Top