Can you do a global search in the code?

[JWCrosby]

Some time ago I renamed a table and apparently didn't have the feature turned
on that would automatically update the name throughout the database. now the
"old" name is creeping up in errors, particularly when a query is opened.

Is there any way that I can globally search for the old table name in the
underlying code or something to see if it is still lurking somewhere?

Thanks in advance.

Jerry

 

[Jack Cannon]

Jerry,

With respect to the code, that is a simple matter.
Just click on the "Current Project" button prior to clicking on the "Find
Next" button.

However it sounds as though the problem exists in the queries instead of the
code.
In that case you will just have to open each query and look.

Jack Cannon

 

[KARL DEWEY]

Or you can use the Documentor to analyze the queries to Word and search the
RTF document for the name.

 

[Paul Shapiro]

I use this routine to search all queries for a string. strFieldname is the
argument to the function and is the text to be found.
Dim qdf As DAO.QueryDef
Dim strOut As String

strOut = "Searching for the string: " & strFieldname

'Search the querydefs
strOut = strOut & vbCrLf & "Used in Queries: "
For Each qdf In CurrentDb.QueryDefs
If InStr(qdf.SQL, strFieldname) Then
strOut = strOut & vbCrLf & " " & qdf.Name
End If
Next

 

[JWCrosby]

Your suggestion worked great, Karl. Thanks.

Jerry