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
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?
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?