Access 2016 Problem communicating with OLE server or ActiveX control

Question

I have an Access 2016 (Office 365) database and am trying to add a command button on a form to open another form. I used the command button wizard to do the code for me.

When I click on the button I get this message:

I have searched and searched, tried every solution I could find, including re-installing office but still get the same problem. It's driving me potty! I'm new to Access so I have no idea what to do to fix this. Van anyone help me please?

Answer 1

Try a compact and repair.

Does your VBA code compile without errors?

Check your VBA references to ensure none are marked as MISSING.

Try deleting that button.  Then create a new one (no wizard) and then add the On Click event (event procedure) with the code previously supplied above.

Answer 2

I couldn't find the code, it said it was an embedded macro and there wasn't anything in the code module for the form I had the button on. I did try as you said, I did that to begin with before trying the wizard (I know how to write code but am new to access forms and stuff) but I get this message:

Thanks :)

Answer 3

What's the code that the wizard created for you for the button's click event?

Try:

DoCmd.OpenForm "YourFormName"

Answer 4

Hmm, might be this database was upgraded form an earlier version.  Check your References...

http://www.access-diva.com/d5.html

Towards the bottom of the page of some References no longer needed or used by Access 2016.  Also suggest making a back-up before adjusting the References.