Error: automation error the object invoked has disconnected from its clients

[siroos12]

Good day all,

I built a vba userform in my excel file and frequently receiving "automation error the object invoked has disconnected from its clients" error. Some times it works and some times it is not. I have comboboxes in the form, by choosing the comboboxes some times it does not show the range on itself and some times it just give me "Run Time" Error and close the excel.
it does confuse me because it happens some times not always.

I do appreciate in advance for your help.

Cheers.

[siroos12]

I just read lots of articles bout this error but could not handle how to solve it. the latest article was "INFO: Error or Unexpected Behavior with Office Automation When You Use Early Binding in Visual Basic" so I considered i need to do qualifying my code but i do not know how?!

here is the codes which I wrote on a excel vba userform:

Please Login or Register  to view this content.

It is a data entry form which gives the user options to reset the form, submit or reload it. I it works fine at same time but as long as I submit for first time and reload it to submit next item it gives me that error.

I checked it on another pc and it works fine, I am not sure what is wrong with my pc.

[jaslake]

Hi siroos12

With Code changes in the attached I get no indication of this

as long as I submit for first time and reload it to submit next item it gives me that error

Let me know of issues.

[siroos12]

Thanks jaslake,

I see the deferences. I just opened the file and it worked first time that I open the form. on second time when I try to open combo boxes it just close the excel. now I considered if i close the excel file and re open it it does not work even on first time.

[jaslake]

Hi siroos12

I'm not able to duplicate this on the Sample File. Are you getting this behavior on the Sample File or your Live File?

on second time when I try to open combo boxes it just close the excel. now I considered if i close the excel file and re open it it does not work even on first time.

[siroos12]

Hi there,

I just downloaded your file and try to test it.

[jaslake]

Hi siroos12

Just a shot in the dark...set the Zoom on the Ranges Worksheet to 100%...

[siroos12]

It is 100% and still the same issue

[jaslake]

Hi siroos12

I don't have Excel 2013. I've tested the Sample File in Excel 2007 and 2010 with no issues. If you have either of these versions try running the File in these versions. Other than that, sorry, I'm out of ideas.

[siroos12]

Thanks my friend,

I am building this for a customer, lets hope that they use 2007 or 2010. By the way i just removed the part of cod which unload and show the form again after submitting first record. It works now but i need to press the button to add next record which is not too bad

I do appreciate all others if they can help.

Thanks.

[jaslake]

You're welcome...sorry I couldn't help...best of luck.

[Norie]

What happens if you remove the DTPicker controls?

Also, have you tried populating the comboboxes in the Initialize event rather than using the RowSource property?

For example.

Please Login or Register  to view this content.

[siroos12]

Hi Norie.

I will give it try but i do not know how to initialize the comboboxes. i need to google it

[Norie]

The code I posted is for populating the comboboxes.

It would go in the Initialize event of the userform.

[siroos12]

Dear Norie,

Is it going to be like this?

Please Login or Register  to view this content.

[Norie]

No, the code goes in the form's Initialize event.

Please Login or Register  to view this content.

By the way, have you tried removing the DTPickers? That was kind of the main point of my post.

[siroos12]

yes i did. but does not help. let me try this code and will update you.

[siroos12]

Thanks Norie, it does not give me that error any more but new issue. the "reset form" button does not work any more. and I need a message box popup after submitting the form says: "Do you want to submit new record?" with yes/no buttons.so by pressing submit button msgbox says "do you want to submit?". by pressing "yes" I need the next msgbox "Do you want to submit new record?" popup and by pressing "yes" reset the form and by pressing "no" close the form. how do I do that?

[Norie]

What I posted shouldn't affect anything else.

Did you remove/change any of the existing code?

[siroos12]

Wow it works now, it was my mistake! i added your code to the file that "jaslake" provided. I just added it to my initial file and it works stunning. Thanks a lot guys.

[Winon]

Hello siroos12,

Jaslake and Norie have gone to great lengths helping you to solve your issue.

Please be so polite as to at least mark this Thread as Solved.

Thank you.

Regards.

[siroos12]

Hi Winon,

I really do appreciate of their help. I did not want to be impolite my friend but if I did something wrong I am sorry for that and thank a lot for their help and your comment as well. thanks all.

I do not know how to mark it solved? I wanted to do it before but i did not know how to?!
Would you please tell me how to do that?

Best regards.

[Winon]

Hello siroos12,

That is the way to go, thank you for your feedback.

Go to each Post of everyone that has offered you a solution, and click on the Star * to the far left at the bottom of that Post, and add to their Reputation.

Then go to your first Post, and above the Post Screen, select Thread Tools> Solved.

Thank you kindly.

Regards.

[siroos12]

I will do it now, and will do on my other post later as well. thanks a lot.

[Winon]

Hello siroos12,

Thank you for your kind co-operation.

Merry Christmas to you, and all you nearest and dearest.

Regards