Posted By

CaptainProton on 03/01/10


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)
  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.