Answers for "create query as sql access vba"

SQL

0

create query as sql access vba

Sub CreateQuery()
 
    Dim db      As DAO.Database
    Dim qDef    As DAO.QueryDef
 
    Set db = CurrentDb
    Set qDef = db.CreateQueryDef("MyQuery")
    qDef.SQL = "SELECT * FROM Vitoshacademy"
    qDef.Close
    db.Close
    Set qDef = Nothing
    Set db = Nothing
    Application.RefreshDatabaseWindow
 
End Sub

Posted by: Guest on March-02-2021

Source

Code answers related to "create query as sql access vba"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#