Article View: comp.databases.ms-access
Article #172Re: For each syntax
From: Joe "Nuke Me Xemu" Foster
Date: Sat, 13 Mar 1999 00:00
Date: Sat, 13 Mar 1999 00:00
31 lines
2032 bytes
2032 bytes
ChrisH <cmh@v-wave.com> wrote in article <7cbjfg$gtj2@dagger.videotron.ab.ca>...
> I want to delete all the items in my list box.
> I was hoping to use something like:
> For Each Item In lstJobNum
> lstJobNum.RemoveItem (Item)
> Next
lstJobNum.Clear
However, in the general case, I'm a little unclear <g> on the For Each
concept. In what order are the items processed? What if I don't like
that ordering? What are the real advantages of For Each versus, say:
Dim S As Stooge: Set S = Stooges.Larry.Curly.Moe.Shemp
S.Pies(0).Throw Stooges.Larry, Overhand, Hard
Dim i As Integer: For i = S.Nyuks.Count - 1 To 0 Step -1
Dim N As Nyuk: Set N = S.Nyuks(i)
N.Volume = i
N.Vocalize
Set N = Nothing
Next i
S.Stand There, LikeAPracticeDummy
Set S = Nothing
--
Joe Foster <mailto:jfoster@ricochet.net> KrazyKookKultz! <http://www.xenu.net/>
WARNING: I cannot be held responsible for the above They're coming to
because my cats have apparently learned to type. take me away, ha ha!
Technical Details
Message-ID:
<01be6ced$c8642d90$fa35170a@probe>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<7cbjfg$gtj2@dagger.videotron.ab.ca>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 110e3b,e9f5d1b99c2fcdfc X-Google-Attributes: gid110e3b,public X-Google-Thread: ff0ac,e9f5d1b99c2fcdfc X-Google-Attributes: gidff0ac,public X-Google-Thread: f645d,e9f5d1b99c2fcdfc X-Google-Attributes: gidf645d,public X-Google-Thread: 1143a7,e9f5d1b99c2fcdfc X-Google-Attributes: gid1143a7,public X-Google-Thread: 108062,e9f5d1b99c2fcdfc X-Google-Attributes: gid108062,public From: "Joe \"Nuke Me Xemu\" Foster" <joe@bftsi0.UUCP> Subject: Re: For each syntax Date: 1999/03/13 Message-ID: <01be6ced$c8642d90$fa35170a@probe> X-Deja-AN: 454399653 References: <7cbjfg$gtj2@dagger.videotron.ab.ca> X-Complaints-To: newsabuse@remarQ.com X-Trace: 921287130 F7W8ZAFJM8074CCB3C usenet78.supernews.com Organization: North American Marcab/Teegeeack Love Association Newsgroups: comp.databases.ms-access,comp.lang.basic.visual,comp.lang.basic.visual.database,comp.lang.basic.visual.misc,cz.comp.lang.basic.visual