A
Asif
Hello
I have a suppliers form which I have a button which
relates to the following code
Private Sub cmdFindSupplier_Click()
Dim rst As New ADODB.Recordset
Dim strCriteria As String
strCriteria = "[ContactName] Like '*" & InputBox
("Enter the " _
& "first few letters of the name to find") & "*'"
Set rst = Me.RecordsetClone
rst.Find strCriteria
If rst.NoMatch Then
MsgBox "No entry found.", vbInformation
Else
Me.Bookmark = rst.Bookmark
End If
Set rst = Nothing
End Sub
When I click on the button it comes with the
following error and the NoMatch is highlighted
Compile Error:
Method or data member not found.
I know the error occurs because NoMatch is only used in
Microsoft Jet Workspaces only and I am creating an access
project adp. John yesterday suggested I use Eof/Bof but
how would I do that, or is there something else I can use
instead of NoMatch.
Kind Regards
Asif
..
I have a suppliers form which I have a button which
relates to the following code
Private Sub cmdFindSupplier_Click()
Dim rst As New ADODB.Recordset
Dim strCriteria As String
strCriteria = "[ContactName] Like '*" & InputBox
("Enter the " _
& "first few letters of the name to find") & "*'"
Set rst = Me.RecordsetClone
rst.Find strCriteria
If rst.NoMatch Then
MsgBox "No entry found.", vbInformation
Else
Me.Bookmark = rst.Bookmark
End If
Set rst = Nothing
End Sub
When I click on the button it comes with the
following error and the NoMatch is highlighted
Compile Error:
Method or data member not found.
I know the error occurs because NoMatch is only used in
Microsoft Jet Workspaces only and I am creating an access
project adp. John yesterday suggested I use Eof/Bof but
how would I do that, or is there something else I can use
instead of NoMatch.
Kind Regards
Asif
..