Signature (Visual Basic / VBA)
Public Function BookmarkFromString( _
ByVal vString As Variant _
) As Variant
Code Examples
BookmarkToString("01020304") = Chr$(1) + Chr$(2) + Chr$(3) + Chr$(4))
BookmarkToString("010203C0") = Chr$(1) + Chr$(2) + Chr$(3) + Chr$(192))
Assuming
Dim wsCur As Workspace
Set wsCur = CreateWorkspace("Main", "Admin")
Dim dbCur As Database
Set dbCur = wsCur.OpenDatabase("C:\TEMP\SOMEDB.MDB")
Dim rsCur As Recordset
Set rsCur = dbCur.OpenRecordset("MSysObjects")
rsCur.MoveNext
Dim strBookmark As String
strBookmark = BookmarkToString(rsCur.Bookmark)
for example
rsCur.Bookmark = BookmarkFromString(strBookmark)
Notes & Version History
| vBookmark | 8-character long string which represents the value of the "Bookmark" property for some DAO Recordset. Function returns Null if vBookmark is Null or cannot be fixed up to a String. |