var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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.
Try a for/next loop similar to:
(say you want the 5th record of recordset 'myrecordset')
For intI=1 to intRecord
So there's no way of directly accessing the ith record?
So does that mean that there is no way of directly accessing the ith record in Access 97 or 2000?
PS: Sorry about the double post, pressed back and refresh by accident.
Perhaps you might try the Recordset.AbsolutePosition property as in:
Me.recordset.AbsolutePosition = 5
Subtitute a variable for the 5 and you may get where you need to.