Re: Help with understanding order of For Each Control

David W. Fenton wrote:
rkc <rkc@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
news:gvA3f.37626$Xl2.24112@xxxxxxxxxxxxxxxxxxxx: 


David W. Fenton wrote:

"Terry Kreft" <terry.kreft@xxxxxxxxx> wrote in
news:ol2dnZfynb783dPeSa8jmw@xxxxxxxxxxx: 


Most likely it corresponds to creation sequence as that is when
it would be added  to the forms controls collection, but as Tom
says "If you need a specific order ..."

Isn't it the same as the z order? That is, if you use BRING TO
FRONT, does it not change the order?

Of course, I'm not sure why you'd ever need a collection
processed in a particular order == that rather defeats the
purpose of collections.

Have you never used an Order By clause in the SQL used to retrieve
a Recordset? What does that do if not determine the order in
which data is stored in the Fields Collection? Why would you do
that if you didn't want to process the 'collection' in a
particular order? 


Er, what?

A SQL resultset is not a collection, except colloguially speaking. 

SQL Resultset?

What good would a ->dao.recordset<- be without the fields collection? The whole purpose of a recordset is to support operations on the Fields collection.


I was speaking of collections in the sense used in the object models
for automating Access, and DAO and VBA. In those contexts,
collections are, by definition, unordered. 

Point to documentation that says that.

This is from the VBA help file:

<quote>
Collection Object

A Collection object is an ordered set of items that can be referred to as a unit.
</quote>





.

Relevant Pages

  • Re: Two columns with same name in ADO Recordset Fields collection
    ... the Fields collection of an ADO recordset? ... populate a Recordset from it to be returned to my COM clients. ... I try to populate the fields collection of a recordset, ... DefinedSize, FieldAttributeEnum Attrib, Object FieldValue) ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: run-time error 3265 Item Not Found in This Collection
    ... Your recordset has only one field, and the Fields collection is zero-based. ... > Set dbMain = CurrentDb ... > Set rsMain = dbMain.OpenRecordset ...
    (microsoft.public.access.modulesdaovba)
  • How do you store binary object data in a table column
    ... I have an imaging application which allows a user to enter search criteria, ... The collection object is made up of data about each image that matched the ... I do not want to store Images in the database, ... ADO recordset, and saved the recordset as an XML file, but now how do I get ...
    (microsoft.public.data.ado)
  • Two columns with same name in ADO Recordset Fields collection
    ... the Fields collection of an ADO recordset? ... populate a Recordset from it to be returned to my COM clients. ... I try to populate the fields collection of a recordset, ... Cannot append. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: display recordset values
    ... >>> assign the values in the record to PName? ... But I'm not sure how to use the recordset. ... >>> Public Function PNameAs String ... >> The Recordset Object has a Fields collection that holds the results. ...
    (microsoft.public.vb.database.ado)
Loading