+ Reply to Thread
Results 1 to 4 of 4

Run-Time Error '-2147024809 (80070057)': Could not find the specified object

  1. #1
    Forum Contributor
    Join Date
    10-25-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    292

    Run-Time Error '-2147024809 (80070057)': Could not find the specified object

    I have no idea what to put as the title of this thread.

    Here is what is happening...

    I have an set of If Then Statements as follows:

    Please Login or Register  to view this content.
    So basically, different things will happen depending on if a selection is made: External, Employee, Agency.

    Yesterday, while testing this form multiple times, I kept finding that when I selected Agency and then put information under the following fields: "Cand_Ext", "CandLocComboBox", "Cand_Shift", "Cand_PS_ID" then saved the selection by clicking the command button, 'Add/Update' which then stores the data within the worksheet, the data within those four fields would not keep. When I would return to the candidate's name everything would be there except the information stored in those four fields.

    But, when I selected Employee and entered information under those four fields, "Cand_Ext", "CandLocComboBox", "Cand_Shift", "Cand_PS_ID", and then 'add/update' and then returned later to that candidate, the information would still be there.

    So,
    Agency - info does NOT stay for "Cand_Ext", "CandLocComboBox", "Cand_Shift", "Cand_PS_ID"
    Employee - info DOES stay for "Cand_Ext", "CandLocComboBox", "Cand_Shift", "Cand_PS_ID"

    I decided to take a look this morning to see where the problem might lie. I opened up my practice document, which is a duplicate document of the one we use, but without confidential information in the values worksheet and it has example data rather than real data.

    I went to my candidate tab within the MultiPage Userform and selected the name, George Washington, and I was given the following error:

    Run-Time Error '-2147024809 (80070057)': Could not find the specified object. When debugging, the following line of code, from the above code, was highlighed,

    Please Login or Register  to view this content.
    Since there are multiple lines of code like the one above, this is the one just under:

    Please Login or Register  to view this content.
    I'm wondering if the two experiences are related, what the error means and how to fix it.

    Yesterday, while using the UserForm using real data under live circumstances, I wasn't given this code when retrieving a candidate from the combobox.

    I'm attaching the doc for reference:

    ISW UserForm Original V0.xlsm

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Run-Time Error '-2147024809 (80070057)': Could not find the specified object

    There is no control named Cand_StatusPS
    If solved remember to mark Thread as solved

  3. #3
    Forum Contributor
    Join Date
    10-25-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    292

    Re: Run-Time Error '-2147024809 (80070057)': Could not find the specified object

    Oh! hello! That's because I deleted it. OK, that explains the error message and caused another but I fixed it because it was the same problem elswehere. That still leaves the other problem, but I will start a new thread because these two are obviously not related. Thank you!!

  4. #4
    Forum Contributor
    Join Date
    10-25-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    292

    Re: Run-Time Error '-2147024809 (80070057)': Could not find the specified object

    I have figured out the previous problem, too. I had the following code elsewhere that removed that information:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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