Results 1 to 2 of 2

Thread: Navigation Buttons

  1. #1

    Thread Starter
    New Member
    Join Date
    May 2001
    Location
    Pakistan
    Posts
    3

    Red face Navigation Buttons

    How do I design Navigation Buttons i.e., First, Next, Previous, Last to work with any recordset, in a Dataenvironment.

  2. #2
    Fanatic Member
    Join Date
    Jan 2001
    Location
    Vietnam
    Posts
    613
    Code:
    Private Sub MoveFirst(rs As ADODB.Recordset)
        rs.MoveFirst
    End Sub
    Private Sub MoveLast(rs As ADODB.Recordset)
        rs.MoveLast
    End Sub
    Private Sub MovePrev(rs As ADODB.Recordset)
        If rs.BOF Then
            rs.MoveFirst
        Else
            rs.MovePrevious
        End If
    End Sub
    Private Sub MoveNext(rs As ADODB.Recordset)
        If rs.EOF Then
            rs.MoveLast
        Else
            rs.MoveNext
        End If
    End Sub

Posting Permissions

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



Click Here to Expand Forum to Full Width