Results 1 to 7 of 7
  1. #1
    Lounger
    Join Date
    Nov 2001
    Location
    Newark, New Jersey, USA
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Error communicating with OLE or Active X (2000)

    I created a new form within my project, and when I try to add code to the form, I get the following error:

    The expression On Click you entered as the event property setting produced the following error: A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control.

    This error occurs no matter what event has code... even just a simple docmd.close in the on click event.
    The code in the rest of the project works fine. Am I missing something simple here?

    Thanks, Rich

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error communicating with OLE or Active X (2000)

    Have a look at KB <A target="_blank" HREF=http://support.microsoft.com/default.aspx?scid=/search/viewDoc.aspx?docID=KC.Q295824&dialogID=3629168&ite rationID=1&sessionID=anonymous|3217704>Q295824</A>
    Hope this help
    Francois

  3. #3
    Lounger
    Join Date
    Nov 2001
    Location
    Newark, New Jersey, USA
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error communicating with OLE or Active X (2000)

    Ufortunately that article doesn't quite show the same symptoms...

    Here's what my error shows...

    *The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].
    *There may have been an error evaluating the function, event, or macro.

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error communicating with OLE or Active X (2000)

    Doing a search on the <A target="_blank" HREF=http://support.microsoft.com/default.aspx?ln=EN-US&pr=kbinfo&>MS KB</A> with "A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control"
    give a lot of more articles.
    Maybe one of them applies to your problem
    Francois

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Error communicating with OLE or Active X (2000)

    What exactly is going on in your form? There are other problems that have nothing to do with ActiveX controls that can cause that kind of error, and automation is one of them.
    Charlotte

  6. #6
    Lounger
    Join Date
    Nov 2001
    Location
    Newark, New Jersey, USA
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error communicating with OLE or Active X (2000)

    Hi Charlotte,

    Well, at the moment the only code on the form is for a button which closes the form... I commented everything else out in an attempt to figure out the problem. What I plan to have the form do, is the user selects a case (via an option group), and that will in turn filter what is displayed in a combo box. The user also has to fill-in three other fields before saving the data. What I'd like to do, but haven't figured it out yet, is have that data append to a recordset in a different form. Not sure if this is possible, but thought I'd give it a try.
    Back to the initial problem however... I copied some code from a sample in a class I had taken, but like I mentioned before, all of that is commented out... so I don't think it could be causing the problem. Any thoughts or ideas would be appreciated. I'm debating whether to just delete the form and start over again... hoping the trouble will go away with the form. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

    Thanks for the assistance... it's greatly appreciated.

    Rich

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Error communicating with OLE or Active X (2000)

    Post the code that isn't commented out, the code that closes the form. If there's nothing wrong with that code, then the only thing left is the form itself. Do any of your controls have functions called in their event properties? Look at the property sheet for each control and see if you have a function instead of an event procedure for any of them.
    Charlotte

Posting Permissions

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