Signature (Visual Basic / VBA)
Public Function BookmarkFromLong( _
ByVal vBookmark As Variant _
) As Variant
Code Examples
BookmarkFromLong(67305985) = Chr$(1) + Chr$(2) + Chr$(3) + Chr$(4)
BookmarkToLong(-1073544703) = 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 lngBookmark As Long
lngBookmark = BookmarkToLong(rsCur.Bookmark)
for example
rsCur.Bookmark = BookmarkFromLong(lngBookmark)
Parameters
| Parameter | Description |
|---|---|
| vBookmark | Long integer value 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 number. |