So I'm using Candice Tripp's universal search tool here. It works great for my need, but it keeps returning "~TMP" tables. I'm able to ignore them, so it's isn't horrible. Just was wondering if anyone could provide a solution to adjust the code to remove the temporary tables so I don't have to keep ignoring them. This is the code behind the search button:

CODE

Private Sub cmdSearch_Click()On Error Resume Next

Dim strSearch As String Dim tdf As DAO.TableDef Dim rs As DAO.Recordset Dim RSS As DAO.Recordset Dim lngLoc As Long Dim lngRow As Long Dim lngI As Long Dim strQuote As String

If IsNull(Me.txtSearch) Or Trim(Me.txtSearch) = "" Then Exit Sub

strSearch = Me.txtSearch

Me.lblMessage.Caption = "Searching for '" & strSearch & "'."

Set rs = CurrentDb.OpenRecordset("tblSearchMatch")

For Each tdf In CurrentDb.TableDefs If Left(tdf.name, 4) <> "MSys" And tdf.name <> "tblSearchMatch" Then Set RSS = CurrentDb.OpenRecordset(tdf.name) If Not RSS.BOF Then lngRow = 1 Do Until RSS.EOF