Answers

Question and Answer:

  Home  Microsoft Access Developer

⟩ Tell us what property of the querydef object can you use to change the SQL syntax?

SQL property. If you declare a qdf variable and assign it to a query, you can change the syntax of the sql statement using qdf.sql = “Select…”. One interesting feature of this property: You don’t have to save the changes, they are immediately saved. Compare that with the DAO recordset object where you must use the Edit method followed by Update in order to save your changes.

 149 views

More Questions for you: