+ Reply to Thread
Results 1 to 3 of 3

run time error '3265': item cannot be found in the collection corresponding to the reques

  1. #1
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    run time error '3265': item cannot be found in the collection corresponding to the reques

    here i am trying displaying actual columnname(header) please help me out

    1st columname is wds_id but second colmn name displaying as Fields(actual column name is Company Name)..etc


    Please Login or Register  to view this content.

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: run time error '3265': item cannot be found in the collection corresponding to the re

    the error means your field names don't match the recordset
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643
    Why are you looping through rst2?

    You've just used CopyFromRecordset to put the data from rst2 onto a worksheet.
    If posting code please use code tags, see here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Run-time error 3265, but fields do exist!
    By jik_ff in forum Access Tables & Databases
    Replies: 2
    Last Post: 01-14-2014, 12:23 AM
  2. [SOLVED] Run Time Error 3265 - Item not found in this collection
    By Sc0tt1e in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-23-2013, 07:19 AM
  3. Replies: 1
    Last Post: 11-17-2012, 11:10 PM
  4. runtime error 3265 error in a VBA Query to pull info from ERP Database
    By NBVC in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-12-2010, 03:59 PM
  5. [SOLVED] Run time error 13 with new Collection
    By Tomkat743 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-19-2006, 07:50 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1