Results 1 to 7 of 7
  1. #1
    Lounger
    Join Date
    Nov 2001
    Location
    Carson City, Nevada, USA
    Posts
    46
    Thanks
    2
    Thanked 0 Times in 0 Posts

    object invoked has disconnected (2000 - SP 3)

    I get this error when running the attached workbook.

    Run-time error '-2147417848 (80010108)
    Automation error
    The object invoked has disconnected from its clients.

    To see it,
    Open the workbook,
    Click on the Select button
    In the Date box, enter a new fate,
    Press the Tab key.

    That should produce the error. I have done some searching, here and google and microsoft, but nothing seems to apply to my problem

    Thanks for any help

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: object invoked has disconnected (2000 - SP 3)

    You unload the userform in the On Click event procedure of the list box. This event fires (I don't know why) after any of the other controls has been updated. It's better to put a command button on the userform that unloads it, and to remove unload from the On Click event of the list box.

  3. #3
    Lounger
    Join Date
    Nov 2001
    Location
    Carson City, Nevada, USA
    Posts
    46
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: object invoked has disconnected (2000 - SP 3)

    Thank you Hans,
    That did it.

    I did want the user to only have to click on the list entry desired to update every thing but this works.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: object invoked has disconnected (2000 - SP 3)

    Closing the form on a single click of a list box is not as user-friendly as it may seem:
    - In Windows applications, users can enter information in any order they like, so you can't be sure that the list box is the last control they visit.
    - Reacting to a list box click makes it impossible to select an item by using the up/down arrow keys, and to correct a mistake.

  5. #5
    Lounger
    Join Date
    Nov 2001
    Location
    Carson City, Nevada, USA
    Posts
    46
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: object invoked has disconnected (2000 - SP 3)

    Yes, I have found that out. Thanks... Now if I can find a way to have the OK button work when the user presses the return key without regard to what field the cursor is in....

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: object invoked has disconnected (2000 - SP 3)

    Set the "Default" property of the OK button to True.
    Legare Coleman

  7. #7
    Lounger
    Join Date
    Nov 2001
    Location
    Carson City, Nevada, USA
    Posts
    46
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: object invoked has disconnected (2000 - SP 3)

    Thank you Legare,

    I had overlooked that property. It works just right now...

Posting Permissions

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