Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003

    Unanswered: In Access 97, how do I access the ith record of a recordset

    I'm trying to access a particular field of an arbitrary record from a recordset. How do I do this? Is there an array access style mechanism? i.e.

    myrecordset ("fieldname") (i)

    Any help would be greatly appreciated. I know this works in Access XP, but not 2000 or 97.

  2. #2
    Join Date
    Nov 2002
    San Francisco
    I guess you talk about ADO, right?

    ADO recordset has MOVE method.

    myrecset.Move recordNumber

    it has also other moves....

    MoveFirst, MoveLast, MoveNext, MovePrevious


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts