DAO error 3265 
Author Message
 DAO error 3265

I am trying to adapt an old DAO program for a new use. The format of the
table is changed. When testing, I get error 3265 (Item not in
collection). I'm not sure what that means? I am trying to go through the
table definition steps for any typos (likely with my typing) but would
apprecuiate any pointers that might narrow the search.

TIA

-----------------
Wayne Wengert



Wed, 03 Oct 2001 03:00:00 GMT  
 DAO error 3265
Found the base problem. It appears this error occurs if you try to refer to
a field that does not exist in the table (I put an extra space in a field
name reference)

Does anyone know if there is a way to get the offending field name - it
would sure help in debugging?

Quote:

> I am trying to adapt an old DAO program for a new use. The format of the
> table is changed. When testing, I get error 3265 (Item not in
> collection). I'm not sure what that means? I am trying to go through the
> table definition steps for any typos (likely with my typing) but would
> apprecuiate any pointers that might narrow the search.

> TIA

> -----------------
> Wayne Wengert




Thu, 04 Oct 2001 03:00:00 GMT  
 DAO error 3265

If you have the simple "On Error GoTo <error label>" error handling in the sub
where the error occurs, you might try commenting out the On Error line, and
when the error occurs, debug, and the offending line should be highlighted.  
This line will probably contain the reference to the non-existent field.  
Sortof a 'development time' inline error handler...wouldn't recommend leaving
the usual error handling routines commented out....



Quote:
>Found the base problem. It appears this error occurs if you try to refer to
>a field that does not exist in the table (I put an extra space in a field
>name reference)

>Does anyone know if there is a way to get the offending field name - it
>would sure help in debugging?


>> I am trying to adapt an old DAO program for a new use. The format of the
>> table is changed. When testing, I get error 3265 (Item not in
>> collection). I'm not sure what that means? I am trying to go through the
>> table definition steps for any typos (likely with my typing) but would
>> apprecuiate any pointers that might narrow the search.

>> TIA

>> -----------------
>> Wayne Wengert




Thu, 04 Oct 2001 03:00:00 GMT  
 DAO error 3265
Tim;

Thanks for the suggestion. Actually I did not have Error Handling on at the time.
I got a pop-up window with the error code and cryptic message. If it would drop
into debug at the offending line that would be great.

When these type of errors occur, are ther additional parameters avil I could pick
up to help determine the cause?

Thanks again for the suggestion.

Wayne

Quote:

> If you have the simple "On Error GoTo <error label>" error handling in the sub
> where the error occurs, you might try commenting out the On Error line, and
> when the error occurs, debug, and the offending line should be highlighted.
> This line will probably contain the reference to the non-existent field.
> Sortof a 'development time' inline error handler...wouldn't recommend leaving
> the usual error handling routines commented out....



> >Found the base problem. It appears this error occurs if you try to refer to
> >a field that does not exist in the table (I put an extra space in a field
> >name reference)

> >Does anyone know if there is a way to get the offending field name - it
> >would sure help in debugging?


> >> I am trying to adapt an old DAO program for a new use. The format of the
> >> table is changed. When testing, I get error 3265 (Item not in
> >> collection). I'm not sure what that means? I am trying to go through the
> >> table definition steps for any typos (likely with my typing) but would
> >> apprecuiate any pointers that might narrow the search.

> >> TIA

> >> -----------------
> >> Wayne Wengert




Fri, 05 Oct 2001 03:00:00 GMT  
 DAO error 3265
When the popup window appears with the message, hit Control-Break and it
should move right to the offending line of code, highlighted.

You must have "Allow Break Into Code" checked in tools/startup/advanced.



Quote:
>Tim;

>Thanks for the suggestion. Actually I did not have Error Handling on at the
> time.
>I got a pop-up window with the error code and cryptic message. If it would drop
>into debug at the offending line that would be great.

>When these type of errors occur, are ther additional parameters avil I could
> pick
>up to help determine the cause?

>Thanks again for the suggestion.

>Wayne


>> If you have the simple "On Error GoTo <error label>" error handling in the
> sub
>> where the error occurs, you might try commenting out the On Error line, and
>> when the error occurs, debug, and the offending line should be highlighted.
>> This line will probably contain the reference to the non-existent field.
>> Sortof a 'development time' inline error handler...wouldn't recommend leaving
>> the usual error handling routines commented out....



>> >Found the base problem. It appears this error occurs if you try to refer to
>> >a field that does not exist in the table (I put an extra space in a field
>> >name reference)

>> >Does anyone know if there is a way to get the offending field name - it
>> >would sure help in debugging?


>> >> I am trying to adapt an old DAO program for a new use. The format of the
>> >> table is changed. When testing, I get error 3265 (Item not in
>> >> collection). I'm not sure what that means? I am trying to go through the
>> >> table definition steps for any typos (likely with my typing) but would
>> >> apprecuiate any pointers that might narrow the search.

>> >> TIA

>> >> -----------------
>> >> Wayne Wengert




Sat, 06 Oct 2001 03:00:00 GMT  
 DAO error 3265
It can, go to Tools|Options|General and select the Break On All Errors
option.  Then when an error occurs a dialog will come up and select the
Debug button.  The offending line will be visible.

Later,
Tony Fountain, MCP
tonyfo at primenet dot com
ICQ# 16575458
Please do not email me directly, my wife already clutters up my inbox



Sun, 14 Oct 2001 03:00:00 GMT  
 
 [ 6 post ] 

 Relevant Pages 

1. DAO Error 3265 - technical - help!

2. ADO error 3265

3. Error 3265:Item not found in this collection

4. Error 3265 Item not found in this collection

5. Run time error 3265

6. Errors 3265 & 3186

7. Errors 3265 & 3186

8. error 3265 when accessing odbc data source through data control

9. Error 3265, item missing from collection

10. Run Time Error 3265

11. 3265 runtime error, item not found in collection

12. ADO error 3265

 

 
Powered by phpBB® Forum Software