Results 1 to 3 of 3

Thread: recordset

  1. #1
    Join Date
    Nov 2003
    Location
    New Zealand
    Posts
    47

    Unanswered: recordset

    Hi everybody, I need to know the code for a for loop.

    ie
    for each record in a recordset do
    --blah blah

    I want to display each record in the recordset into different groups in a word document. but im not sure of the syntax used to get a specfic record. I can get fields.

    ANy help would be great

    thanks.
    Nerdy Girl

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    for each record in a recordset do
    --blah blah
    do while not YourRecordsetName.EOF
    'blah blah
    YourRecordsetName.movenext
    loop



    I want to display each record in the recordset into different groups in a word document


    you can only address the fields in the current record
    whatever = YourRecordsetName!YourFieldName
    etc

    izy
    currently using SS 2008R2

  3. #3
    Join Date
    Nov 2003
    Location
    New Zealand
    Posts
    47

    Thanks

    perfect, thanks........heaps. Just
    Nerdy Girl

Posting Permissions

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