Error 3265, item missing from collection 
Author Message
 Error 3265, item missing from collection

Help!  I'm trying to create a simple html report file, and I keep getting
the error "item missing from collection" on lines where it's accessing
specific fields from my database.

Here's the code snippet where the error(s) occur:

If (datFamily.Recordset.RecordCount > 0) Then
        datFamily.Recordset.MoveFirst
        Dim count As Integer
        count = 0
        'While Not (datFamily.Recordset.EOF)
  ===> Print #6, datFamily.Recordset("Family_ID")
            'Print #6, " "
            Print #6, datFamily.Recordset("Family_Name")
            'Print #6, " --  $"
 ===>  Print #6, datFamily.Recordset("Balance")
            Print #6, "<br>"

I did some research on previous posts, and saw several people comment that
this error is often caused by a typo.  Well, I have checked my code against
the database field names several (many many many) times, and see no
discrepancy.

This error made me  go "???", so I tried making a very simple form which
just accessed the same database to get those field values...and it worked
fine!  So I'm thinking it must be something else on this one form?  But the
only other time this "datFamily" database is accessed is during Form Load
for an SQL query, which follows:

datFamily.RecordSource = "Select Distinct [Family_Name] " + _
                         "from Family order by [Family_Name]"

I have refreshed the database, but to no avail.  Please either enlighten me,
releasing me from the depths of my profound ignorance, or give me a command
which will mercilessly club this database into instant obediance!  ;)

I await your replies with breathless anticipation.
Liana



Wed, 09 Mar 2005 06:57:17 GMT  
 Error 3265, item missing from collection
HI,

I don't see the select statement you're using before this loop, but the one you
described as being in the form_load event:

Select Distinct [Family_Name] " + _       "from Family order by [Family_Name]

returns only the column 'Family_Name'. Therefore you would not have the other 2
columns, hence the error?



Wed, 09 Mar 2005 09:39:56 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Error 3265:Item not found in this collection

2. Error 3265 Item not found in this collection

3. 3265 runtime error, item not found in collection

4. Run-time error 3265: Item not found in this collection

5. Run-time error '3265': Item not found in this collection

6. Error 3265:Item not found in this collection

7. Error 3265 - Item not found in this collection

8. Run Time Error 3265: Item cannot be found in the collection

9. 3265 - Item not found in the collection

10. 3265 Item not found in the collection

11. 3265, Item not found in this collection

12. 3265 Item not found in the collection

 

 
Powered by phpBB® Forum Software