Posted By

CaptainProton on 03/01/10

Tagged

sql
query

Versions (?)

Last Edited at 03/01/10 04:03pm

Statistics

Viewed 1512 times

Favorited by 0 user(s)

Related snippets

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

Copy this code and paste it in your HTML

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

Report this snippet Tweet

Comments

You need to login to view comments.