Results 1 to 3 of 3

Thread: cycling through a recordset, storing info to a 2-dimensional array

  1. #1
    Guest

    Post

    can someone let me know how to cycle through every record in a recordset, when i try it it gets to the end of the database, and gives an end of file error.

    i have tried looping until data1.recordset.eof, but it still give the error. how do i avoid the error?

    ------------------

    Wossname,
    Email me: wossnamex@talk21.com

  2. #2
    Guru Clunietp's Avatar
    Join Date
    Oct 1999
    Location
    USA
    Posts
    1,844

    Post

    error even though you use EOF?

    like this?
    Code:
    do until rs.eof = true
        debug.print rs.fields("fieldname").value
        rs.movenext
    loop
    What kind of database are you working with? (text, access, SQL server, etc)

  3. #3
    Guest

    Post

    im using an access.mdb database

    ill try again with your code.

    Also...
    how do i get the data1 to go to a bookmark, i set a bookmark in a search routine im writing, but when i try to make the control revert to the bookmark (if the search fails) it just goes back to the first record. Note, im not using the refresh statement after or before the bookmark bit.

    ------------------

    Wossname,
    Email me: wossnamex@talk21.com

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