Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Is there any way to speed up search??

Status
Not open for further replies.

b31luv

Technical User
Feb 21, 2002
171
US
I've linked to Outlook and perform a search for by the clients name. It takes from 30 seconds to a 1 minute to perform this search. Any suggestions on how to speed the search up?

Second problem, the search will find a record for one client but not for another. I've verified the spellings several times to be sure that the spelling is correct. The way I'm doing this is I locate the client on a different screen. Then I open the form with the client info(Outlook) OnLoad I

Code:
Private Sub Form_Load()
    Dim bolOpen As Boolean
    Dim rs As Object
    
    bolOpen = CurrentProject.AllForms("Form - Table - Tracking Log - Find Job Numbers").IsLoaded

    If (bolOpen) = True Then
        'MsgBox "Opened", vbCritical
        With Forms![Form - Table - Tracking Log - Find Job Numbers]
            Me.Text4 = Forms![Form - Table - Tracking Log - Find Job Numbers]!Text42
            Me.Text6 = Forms![Form - Table - Tracking Log - Find Job Numbers]!Text46
            Me.Text8 = Forms![Form - Table - Tracking Log - Find Job Numbers]!Text44
            Me.Text14 = Forms![Form - Table - Tracking Log - Find Job Numbers]!Text50
            
        End With
    Else
        'MsgBox "Closed", vbCritical
        'Me.Client.Visible = True
        'Me.Client.SetFocus
        'Me.LocateClient.Visible = True
    End If
    
    Set rs = Me.Recordset.Clone
    rs.FindFirst "[Company] = '" & Me![Text4] & "'"
    Me.Bookmark = rs.Bookmark

End Sub

Outlook has 1437 records.

In performing a search for one client, the client names shows, however the address, phone and all other info does not. I've searched through to find that all names are spelled correctly. Have I just designed a terrible dbase, structurally or is there something I'm missing?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top