Creating query from SQL string

S

stevecrowhurst

Can anyone tell how I write the code to create a qry from
an SQL string that is currently in a MsgBox
 
A

Allen Browne

Dim db As DAO.Database
Dim qdf As DAO.QueryDef

Set db = CurrentDb()
Set qdf = db.CreateQueryDef("SomeName4TheQuery")
qdf.SQL = "SELECT BookingID, BookingDate FROM tblDaoBooking;"

Set qdf = Nothing
Set db = Nothing
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
VBA Export to PDF 0
Delete a Query, or Empty it and Reload With New SQL? 3
How to Change criteria on a saved query using VBA 0
Build Dynamic Query from Form 6
Word macro that can call cells out of Excel for a find and replace 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0

Top