• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 296
  • 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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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