ACC 2000 - Find Text within a Query using VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to use VBA code to programmatically loop through all the
Queries in an Access 2000/2002/2003 database to find a particular string
within the Query? I am guessing I would have to loop through the Queries
collection looking within the SQL text of the query for the string?
 
Tony_VBACoder said:
Is there a way to use VBA code to programmatically loop through all the
Queries in an Access 2000/2002/2003 database to find a particular string
within the Query? I am guessing I would have to loop through the Queries
collection looking within the SQL text of the query for the string?
Click to expand...


That's what you can do all right.

For Each qdf On db.QueryDefs
pos = InStr(qdf.SQL, "yourstring")
If pos > 0 Then
'do something
End If
Next qdf
 
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

Append Passthrough Query Results to Local Table 2
Append Query VBA help 2
query parameter in vba 4
Creating a select query using sql in VBA 6
Loop Question 2
Access Command button to look up and copy data from a query to a table 0
SQL Quotes help 5
DAO: query of multiple tables can not find 3

Back
Top