createQuery(String, String)

/ Published in: Visual Basic
Save to your folder(s)

This method creates a query with a given name and given SQL.
Note: Requires the deleteQuery(String) method.

Copy this code and paste it in your HTML
  1. Private Sub createQuery(name As String, sql As String)
  2. Call deleteQuery(name)
  4. Dim queryDef As DAO.queryDef
  5. Set queryDef = CurrentDb.CreateQueryDef(name, sql)
  6. End Sub

Report this snippet


RSS Icon Subscribe to comments

You need to login to post a comment.