Your Ad Here

advanced code snippet search

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.

Expand | Embed | Plain Text 
  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.