Solved

remember current position

Posted on 1999-01-20
2
264 Views
Last Modified: 2010-05-03
Hi,
I program VB with Ms Access database.
I open a Recordset and use MoveNext command. How do I remember my current record position and save it in an variable. Then use MoveNext or whatever to move to other record. Then I want to come back to the last record position that I store in an variable.

Thank
0
Comment
Question by:woaini
2 Comments
 
LVL 9

Accepted Solution

by:
Dalin earned 20 total points
ID: 1469696
Dim myBookmark as Variant
' setbookmark
myBookMark = recordset.bookmark

' Return
recordset.bookmark = myBookMark

Regards
0
 

Author Comment

by:woaini
ID: 1469697
It's perfect !!! Thank.
0

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question