J
jonefer
the following line used to work, but I had to change my reference to DAO. 3.5
because of replication in Access 97...
If DCount("*", "qryGlobalSearch") = 0 Then
MsgBox "Sorry, there were no results for '" & Me.txt_SearchDB & "'"
Else
DoCmd.OpenForm "frm_SearchResults"
End If
Now I get the following error:
Run-time error '64479'
The expression you entered as query parameter produced this error: 'The
object doesn't contain the Automation object 'Defect#.'
Are there any bandaid fixes for this while I wait to switch to Access 2000?
because of replication in Access 97...
If DCount("*", "qryGlobalSearch") = 0 Then
MsgBox "Sorry, there were no results for '" & Me.txt_SearchDB & "'"
Else
DoCmd.OpenForm "frm_SearchResults"
End If
Now I get the following error:
Run-time error '64479'
The expression you entered as query parameter produced this error: 'The
object doesn't contain the Automation object 'Defect#.'
Are there any bandaid fixes for this while I wait to switch to Access 2000?