Pass-thru Queries

D

Duane Hookom

I use a little DAO code to set the SQL property of the saved pass-through
query. Something like:
Dim strSQL As String
strSQL = "SELECT... FROM ... WHERE ID=" & Me.txtID
Currentdb.QueryDefs("qsptMyQuery").SQL = strSQL
 

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

Use a variable in a ShapeRange.Increment 0
Pass Through Query - not returning rows 1
Passing a variable to a query 1
Pass-Through query used to update an access table 2
Space at end of multi page list to accommodate new entries 1
Like "* " and function to pass parameters into a query 4
Incorrect date in pass-thru query 1
Using pass-through query results in forms 0

Top