How to re-define or change a set query?

  • Thread starter Thread starter Paul Mak
  • Start date Start date
P

Paul Mak

I want to use code to re-define or change a set query I created earlier.
 
Create a module and make a function or sub to set the query's sql property
equal to a string variable with the new sql statements:

Sub ChangeQuery()
Dim strSQL As String
Dim qdf As DAO.QueryDef

strSQL = "SELECT Field1 FROM Table1;"
Set qdf = CurrentDb.QueryDefs("qryTest")
qdf.SQL = strSQL
Set qdf = Nothing
End Sub
 
You must log in or register to reply here.

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

Re set new tablet computer with lost password 1
Need to Re-set and Customize Autonumber in a Form 2
Deleting Define Names 2
Still stuck: rerunning a query to change criteria 1
Assign predefined query 2
How to use button to set form filter via query 1
Run time Error - Application Defined or Object Defined Error Excel Vba 0
Error User defined type not defined 2

Back
Top