+ Reply to Thread
Results 1 to 4 of 4

Run-time error '3265': Item cannot be found in the collection corresponding to the request

  1. #1
    Registered User
    Join Date
    06-12-2013
    Location
    philippines
    MS-Off Ver
    Excel 2003
    Posts
    17

    Run-time error '3265': Item cannot be found in the collection corresponding to the request

    hi i have 3 tables that i want to join. Staff_Session_A, Staff_Session_B, Staff_Profile.
    Staff_Session_A table is from other database named [LOCDB1] and both Staff_Session_B and Staff_Profile are from database named [LOCDB].

    Please Login or Register  to view this content.

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,909

    Re: Run-time error '3265': Item cannot be found in the collection corresponding to the req

    My SQL is pretty rusty, but it doesn't look like that field is included in your output. It needs to be part of the first SELECT statement, I think.
    Rory

  3. #3
    Registered User
    Join Date
    06-12-2013
    Location
    philippines
    MS-Off Ver
    Excel 2003
    Posts
    17

    Re: Run-time error '3265': Item cannot be found in the collection corresponding to the req

    i want to display same attached image.Attachment 652555

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,873

    Re: Run-time error '3265': Item cannot be found in the collection corresponding to the req

    To attach an image, create a file with the image and save as a .jpg. Then click on Go Advanced. Scroll down to Manage attachments. Follow the wizard to attach a picture file. Your current attachment is not visible.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Run Time Error: Item with specified name not found
    By Joseph9098 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-29-2018, 05:49 PM
  2. [SOLVED] Error: Item Text not found in Shapes Collection
    By ell_ in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-15-2018, 11:11 PM
  3. Replies: 0
    Last Post: 12-08-2014, 06:46 AM
  4. Run-time error '-2147024809 (80070057)' Item with specified name wasn't found
    By tom_6030 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-08-2014, 10:24 PM
  5. [SOLVED] run time error '3265'; item cannot be found in the collection corresponding to the regues
    By baig123 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-08-2014, 03:29 AM
  6. Replies: 2
    Last Post: 05-13-2014, 07:07 AM
  7. [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

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