Advanced Search

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.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.