searching for text in query criteria

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

Guest

Is there a handy way to search all queries in a database for the presence of
a particular text string in the criteria?
 
AccessMan said:
Is there a handy way to search all queries in a database for the presence of
a particular text string in the criteria?
Click to expand...


You can easily search all the **saved** queries with
something like:

Dim db As DAO.Database
Dim qdf As DAO.QueryDef

Set db = CurrentDb()
For Each qdf In db.QueryDefs
If qdf.SQL Like "*WHERE *XYZ*" Then
Debug.Print qdf.Name, qdf.SQL
End If
Next qdf
Set db = Nothing
 

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

Parameter search in a text field 1
Criteria of parameter queries 2
Use In() Expression as Query criteria with guts from Function 1
Access Dcount (multiple criteria) 3
search multiple criteria 0
All-Record criteria in a query...hmmm 4
access 2007 criteria in query 2
Optional Parameters 8

Back
Top