Search all Queries for a Field

[jgabel]

I need to find out where the field called "R_SHIFT" is being referenced in all our MS Access queries. I just need the query name so I can go into the query and change the name from "R_SHIFT" to "SHIFT"

Thank you so much for any help you can offer. I'm posting this question in hopefully the right place as I was thinking there was a function for Modules to Find Field?

I have never done any Modules before..

 

[Rx_]

V-Tools http://www.btabdevelopment.com/ts/othertools
Total Deep Search is one of the many add-in tools.
Sounds like something done at the airport security. But, it actually takes any string - finds it in data, objects or anywhere else.

If you need to do this with code look for:
Function ShowFieldsRS
and other related collections of objects at:
http://allenbrowne.com/func-dao.html

 

[jgabel]

Very helpful information, worked great in my database I do not recommend having this done at the airport however.

 

[gemma-the-husky]

but this sort of code will do it

Sub findtext()
Const ftext = "desired field name"
 
Dim qdef As QueryDef
For Each qdef In CurrentDb.QueryDefs
    If InStr(qdef.SQL, ftext) > 0 Then
        MsgBox ("String found in : " & qdef.Name)
    End If
Next
End Sub