Determine "current record" within banded Data Access Page

Posted on 2005-04-10
Last Modified: 2008-03-10

I am writing a VBScript for a banded Data Access Page.  

I need the script to identify what is the current record, returned as the record's number (i.e. is it the table's record no 1, 2, 3 . . .  or whatever?).  Can anyone help me?  

Thanks a lot,
Question by:Craydon
    LVL 46

    Accepted Solution

    Take a look at
    METHOD:  Recordset::Move

    Good Luck!


    Author Comment


    Hi Gary,

    Thank you for the answer.  The web page you referred me to didn't really give me an answer, but it gave me some clues where to look which eventually lead me to the solution, so I'll give you the points. Thank you!

    Just for the record, here is the solution I arrived at:

    Dim CurrentRecord
    CurrentRecord = MSODSC.CurrentSection.DataPage.Recordset.Bookmark - 1

    LVL 46

    Expert Comment

    That was my plan...:> To point you in the right direction
    Glad I could help!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    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…
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…

    779 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

    18 Experts available now in Live!

    Get 1:1 Help Now