P
Paul Mak
I want to use code to re-define or change a set query I created earlier.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mark via AccessMonster.com
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
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