Return to Snippet

Revision: 24432
at March 1, 2010 16:03 by CaptainProton


Initial Code
Private Sub createQuery(name As String, sql As String)
  Call deleteQuery(name)
  
  Dim queryDef As DAO.queryDef
  Set queryDef = CurrentDb.CreateQueryDef(name, sql)
End Sub

Initial URL


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

Initial Title
createQuery(String, String)

Initial Tags
sql, query

Initial Language
Visual Basic