Error 3265 Item cannot be found in the collection...

[Dniss]

Error 3265 Item cannot be found in the collection corresponding to the
requested name or ordinal.

Hi all,
I have a small vba code that stopped working lately. Basically all my
recordsets fields have to be indentified as rst.fields([column #]) instead of
rst.fields("name") in order to work.

e.g
MyRecordset.fields("Fiscper") now has to be changed to MyRecordset.fields(0)
in order to work.

I found this help page on the subject but I can't make sense out of it.
http://support.microsoft.com/kb/q201826/
I'm not sure how to apply this solution to my work. Aside from the
connectstr do I have to change anyting else? Do I have to list all the
tables? Do I run only the code only once?
Can anyone help me??
TIA

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?RG5pc3M=?=,

Since you haven't received a response to this, yet, I suggest you try in a group
more appropriate to the topic of your question. Unfortunately, you give no
indication of which programming environment you're using, nor to which object
library rst is pointing. data.ado might be appropriate...

I have a small vba code that stopped working lately. Basically all my
recordsets fields have to be indentified as rst.fields([column #]) instead of
rst.fields("name") in order to work.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail