Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Move.Next

Status
Not open for further replies.

Johno2090

Programmer
May 3, 2002
31
GB
I know there is a move next command but i was wondering if there is any way i can do a kina move.previous and start form the bottom of a database and work my way up.

Cheers in Advance
 
with objRS

.movelast - moves to the end of the recordset

do until .bof=true

... your code

.moveprevious ' moves to the previous record

loop

end with
 
there are set functions in place for what you are asking.

rs.MoveNext
rs.MovePrevious
rs.MoveFirst
rs.MoveLast

so in your case.
rs.MoveLast then
rs.MovePrevious

examples here
[bomb]
I may not get it the 1st or 2nd time,
but how sweet that 15th time can be.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top