![]() Microsoft states in the online help that the recordset returned by the Clone method has no current In function, except that you can't set the Filter or Sort properties for recordsets created using the RecordSetClone property. Recordset object, whereas RecordsetClone is a property of the Access Form object. There are two clone methods: Clone and RecordsetClone. 'Move to the last record, and print its positionĪs mentioned earlier, a clone is a functional replica of the original. 'the current cursor position, for referenceĭebug.Print "Current position: " & rs.AbsolutePosition 'Move to the middle of the recordset, and print Set rst = dbs.OpenRecordset("SELECT * FROM Table1", dbOpenDynaset) The following procedureĭemonstrates how to use Bookmarks for record navigation: Public Sub UsingBookmarks() Using Bookmarks is much faster than using the other recordset navigation methods. For that reason, you shouldĪlways check the Recordset object's Bookmarkable property before attempting to use Bookmarks on non-Access recordsets. Linked Paradox tables that have no primary key do not support bookmarks. Recordsets based on external data sources may not allow them. The internal Bookmarks are lost, and any Bookmarks you have set become invalid.Īlthough recordsets based entirely on Access tables always support Bookmarks, not all recordset typesĭo. So there is really no practical limit to the number of bookmarks you can set. You will soon see, creating a reference to a Bookmark is simply a matter of setting the value of a variable. ![]() When you open a recordset, every row is automatically assigned a unique internal Bookmark, and as Once the Bookmark has been set, then set the Bookmark in the original recordset to move its cursor. The search, and then when you find the data you're looking for, save the current Bookmark for theĬlone. Search for data in a form without changing the record position of the form. Search for data without moving the cursor in the original recordset. Using a cloned recordset, you can navigate or The difference is primarily in navigation. Changes made to the data in the clone are reflected in the Same data as the recordset it was copied from. In terms of recordsets, a clone is a functional replica of the original. ![]() Spot, make your changes, and then return to where you were in the first place. Or change a value in some other part of the same recordset, you could set a Bookmark, move to the other For example, to move from your current position in the recordset to check A recordset Bookmark is a special marker that you place in your recordset so you can quickly return or ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |