extract SQL sentence from a query via vba code

  • Thread starter Thread starter thread
  • Start date Start date
T

thread

Hi all,

is it posible to extract SQL sentence from a query via VBA code?
 
Hi

Yes...

Dim MyQuery As QueryDef
Dim QuerySQL As String
QuerySQL = CurrentDb.QueryDefs("qryName").SQL
MsgBox QuerySQL

Regards

Andy Hull
 
You must log in or register to reply here.

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

pulling SQL sentence from a query to a string value 3
is it posible to convert text in a table to a query with vba code 10
build a query via vba 7
SQL sentence in ADO object 2
changing sql sentence in query via vba code 6
expression as a value of a table 1
Aggregate Function Error 0
Extracting documents from OLE field 1

Back
Top