pulling SQL sentence from a query to a string value

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

thread

Hi all,

i need to pull by coding the SQL sentences of the queries in order to
make decision or to make changes
is it posible by coding to extract this data?
 
Hi all,

i need to pull by coding the SQL sentences of the queries in order to
make decision or to make changes
is it posible by coding to extract this data?
Click to expand...

Dim strSQL As String
strSQL = CurrentDb.Querydefs("Queryname").SQL


John W. Vinson [MVP]
 

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

extract SQL sentence from a query via vba code 1
is it posible to convert text in a table to a query with vba code 10
String is to short for SQL sentence 2
expression as a value of a table 1
SQL sentence in ADO object 2
exporting the result of the SQL sentence(query) to excel 1
Select, copy and past first sentence from each paragraph to adifferent document 5
Pulling data from a linked SQL table 2

Back
Top