CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4
  1. #1
    Join Date
    May 2001
    Location
    MO, USA
    Posts
    87

    database BOF and EOF

    okay here it is... i have a database form and the database is connected thru dao and not hard coded in.....but i am having problems with EOF and BOF.....
    private sub command1_click()
    data2.recordset.movenext
    end sub


    where and how would i put in the BOF and EOF code
    to stop the move at the EOF and BOF

    thanx in advance

    midnightservice


  2. #2
    Join Date
    Jun 2001
    Location
    Sri Lanka
    Posts
    272

    Re: database BOF and EOF

    Do While rs.EOF = false And rs.BOF = false
    List1.AddItem rs!f2
    rs.MoveNext
    Loop



    Srinika


    If u don't know how to Rate an answer, then Rate my answer to learn, If u know, then practice it

  3. #3
    Join Date
    May 1999
    Location
    Omika, Japan
    Posts
    729

    Re: database BOF and EOF


    private sub command1_click()
    if not data2.recordset.Eof then
    data2.recordset.movenext
    end if
    end sub







    RK

  4. #4
    Join Date
    Jul 2000
    Location
    Milano, Italy
    Posts
    7,726

    Re: adding to others...


    private sub command1_click() 'to scroll forward
    if not data2.recordset.Eof = true then
    data2.recordset.MoveNext
    end if
    end sub

    private sub command2_click() 'to scroll backward
    if not data2.recordset.bof = true then
    data2.recordset.MovePrevious
    end if
    end sub










    Special thanks to Lothar "the Great" Haensler, Tom Archer, Chris Eastwood, TCartwright, Bruno Paris, Dr_Michael
    and all the other wonderful people who made and make Codeguru a great place.
    Come back soon, you Gurus.

    The Rater
    ...at present time, using mainly Net 4.0, Vs 2010



    Special thanks to Lothar "the Great" Haensler, Chris Eastwood , dr_Michael, ClearCode, Iouri and
    all the other wonderful people who made and make Codeguru a great place.
    Come back soon, you Gurus.

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

Featured