Movenext & Loop

Results 1 to 2 of 2

Thread: Movenext & Loop

  1. #1
    Tony Guest

    Default Movenext & Loop

    Anyone know how, when using <BR><BR>Do While Not recordSet.EOF<BR>da da da <BR>recordSet.Movenext<BR>Loop<BR><BR>I can get the recordSet to "Movenext" if ONE field only in the recordSet is Null or Empty????? ie, Are there any vb arguments or code you can use to identify a null field????<BR><BR>Thanks, Tony<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default isnull()

    do until rs.eof<BR><BR><BR>if isnull(rs("field1")) then<BR> rs.movenext<BR>end if<BR>loop<BR><BR>&#039warning: u must make sure that at some point, rs will reach eof , otherwise, u will time-out the script

Posting Permissions

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