How to get SQL string for query in VBA

Max Moor · Jun 15, 2004

Hi All,
I have a predefined query "qrySales." Is there a way in VB that I
can get the SQL string defining this query into a variable string to
manipulate?

- Max

Ken Snell · Jun 15, 2004

strSQL = CurrentDb.QueryDefs("qrySales").SQL

Max Moor · Jun 15, 2004

strSQL = CurrentDb.QueryDefs("qrySales").SQL

That was quick, Ken. You must have been waiting for me. :-)

Thanks for
the help. This was just what I needed.

- Max

Ken Snell · Jun 15, 2004

You're welcome.

--

Ken Snell
<MS ACCESS MVP>

Max Moor said:
That was quick, Ken. You must have been waiting for me. Thanks for
the help. This was just what I needed.

- Max