Home | About me | EXCEL VB Programming (XL97-2003) | ACCESS Programming | EXCEL VB.Net Programming | EXCEL Spreadsheet Functions |  Material Management  |  Guestbook
 

ADO CompareBookmarks Method

The CompareBookmarks method compares two bookmarks. This method returns a CompareEnum value that indicates the bookmark's relative row positions.

Note: The two bookmarks must be within the same Recordset, or within a Recordset and its clone.

Note: You can use this method only if the provider support bookmarks.

Syntax

result=objRecordset.CompareBookmarks(mark1,mark2)

Example

If objRecordset.CompareBookmarks(Bookmark1, Bookmark2) = adCompareEqual Then
   MsgBox "Bookmarks Are Equal", vbOK
Else
   MsgBox "Bookmarks Are Not Equal", vbOK
End If