On Click Error: "occurred while Microsoft Access was communicating with the OLE Server or ActiveX Control"

vba ms-access ms-access-2013
JeffO picture JeffO · Mar 19, 2015 · Viewed 16.8k times · Source

Seems like this is has been asked a few times before.

After working on a form for a few weeks, I suddenly get the error when I click on a button: "The expression On Click you entered as the event property produced the following error: A problem occurred while Microsoft Access was communicating with the OLE Server or Active X Control."

This also happens with any control's event on the form (e.g. After Update on other text fields)

I tried re-installing Access to no avail.

Not sure if this is relevant, but I have a subform on the form as well. I have an "on-click" event that works on the subform, but when the code breaks at the following line (which worked before):

Me.Parent.orderID = Null

The error I get is: "Method 'Parent' of object '_Form_frmOrderQuery' failed (frmOrderQuery is the name of the subform)

Anyway, this all worked before until I changed the query for the subform by adding a few more fields.

Finally: All of the event handlers (button click, after-update, etc) work on my other forms in the database.

Any help/suggestions would be greatly appreciated.

Thanks,

jeff

Answer

mikemaster picture mikemaster · Oct 25, 2018

Figured it out, this was stupid easy. Whatever Form is having issues, just copy it and delete the old form. Rename the new form to the same as the last (so all your vba and stuff works). Done!

Related questions

Combobox null in if statement

I am trying to code an if statement where if a certain combobox is null, then it runs a certain part of code if it has data in it then it runs another. I wrote up this: Private Sub ProjectAddSetDateAutoBtn_…

Read More
ADODB doesn't exist in Access 2013 project, how do I add a reference to it

I am trying to rebuild an Access adp project in Access 2013 as and mdb. The tables are all linked tables in both version so that is not an issue. I have imported the forms from the old project so the …

Read More
Access 2013 VBA - Setting New Click Event for Controls

I have searched everywhere for this, and it seems like a simple fix, but I can't seem to find the solution. I have several Rectangle controls in my Access 2013 form, and I'm creating an OnClick event that handles them all. …

Read More