For Next... Each question

Results 1 to 2 of 2

Thread: For Next... Each question

  1. #1
    Join Date
    Dec 1969

    Default For Next... Each question

    I tried posting this message once and after saying it posted I tried viewing the topic list to see if it showed up, but it didn&#039;t. So if it does resurface I&#039;m sorry for the double post..<BR><BR>ANYWAYS<BR><BR>I am looking to use For Each... Next to page through my record set.. I&#039;ve tried the following syntax:<BR><BR>For Each record in objRS<BR>But I get "method not supported by this object" or something like that. If possible, what is the correct syntax to do this?<BR><BR>Thanks<BR>Mike

  2. #2
    Join Date
    Dec 1969

    Default Can't use FOR...EACH...

    A recordset is *NOT* a Collection.<BR><BR>It&#039;s actually an *array* OF collections, if you care!<BR><BR>Anyway:<BR><BR>&#060;%<BR>Do Until RS.EOF<BR>&nbsp; &nbsp; ...<BR>&nbsp; &nbsp; RS.MoveNext<BR>Loop<BR>%&#062;<BR><BR>What book or other material are you learning from that didn&#039;t have this in the very first example of using a recordset????<BR><BR>I think it&#039;s time to get a new book or whatever!<BR><BR>

Posting Permissions

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