Solved

remember current position

Posted on 1999-01-20
2
262 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

I’ve seen a number of people looking for examples of how to access web services from VB6.  I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…
Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…

760 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now