Re: For Each

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



The choice of view for the form is not important for how you do this. It's
done the same way:

With Me.RecordsetClone
.MoveFirst
Do While .EOF = False
Debug.Print .Fields("washed").Value
.MoveNext
Loop
End With


--

Ken Snell
<MS ACCESS MVP>


"David W" <davidw@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:uwsBYnFPFHA.904@xxxxxxxxxxxxxxxxxxxxxxx
> How would you loop through the field [washed] in each record using the
> single form mode, not continious?
>


.



Relevant Pages

  • Email Sending - How To
    ... I need to write a batch app. ... that will loop thru data, ... while (not Eof) do begin ... Prev by Date: ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: ifstream limitations?
    ... > The while loop was: ... > above will discover EOF when it calls getline and may ... Prev by Date: ...
    (microsoft.public.vc.language)
  • Checking for EOF with Streamreader
    ... What is the best way to check for EOF when using the streamreader? ... Following is what I have tried but all end in an error when eof is reached. ... Adding 'until line is nothing' to the end of the loop. ... Prev by Date: ...
    (microsoft.public.dotnet.languages.vb)
  • Re: SQL for Quering Access Tables from a Table/Field List Table
    ... from Do until .EOF to End With, and I am prompted to enter the value ... Apparently when there is nothing in the record set it breaks ... out of the loop. ... Prev by Date: ...
    (microsoft.public.access.externaldata)
  • Re: detab utility challenge.
    ... I know he is not suggesting anyone write such a silly loop. ... Once the character returned is EOF, ... Once getc returns EOF (by the way, ...
    (comp.lang.c)