extract SQL sentence from a query via vba code

[thread]

Hi all,

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

 

[Andy Hull]

Hi

Yes...

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

Regards

Andy Hull