Posted By

CaptainProton on 03/01/10


Tagged

sql query create access


Versions (?)

createQuery(String, String)


 / Published in: Visual Basic
 

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

  1. Private Sub createQuery(name As String, sql As String)
  2. Call deleteQuery(name)
  3.  
  4. Dim queryDef As DAO.queryDef
  5. Set queryDef = CurrentDb.CreateQueryDef(name, sql)
  6. End Sub

Report this snippet  

You need to login to post a comment.