• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 300
  • Last Modified:

Determine "current record" within banded Data Access Page

Hi,

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,
Craydon
0
Craydon
Asked:
Craydon
  • 2
1 Solution
 
tbsgadiCommented:
Take a look at
http://www.devguru.com/Technologies/ado/quickref/recordset_move.html
METHOD:  Recordset::Move

Good Luck!

Gary
0
 
CraydonAuthor Commented:


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


Cheers,
Craydon
0
 
tbsgadiCommented:
That was my plan...:> To point you in the right direction
Glad I could help!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now