1

I have upgraded from office 2013 to office 2016 & now when I try to open a database using access 2016 on the switchboard it says the expression on click you entered as the event property setting produced the following error: the expression you entered has a function name that access can’t find.

Anyone any ideas on how I can get this open.

Thanks

4 Spice ups
2

On_Click() is the action of clicking on something, like a button. It’s what’s called an Event Handler. In Access, you put in the name of a Macro function to fire when someone “clicks” the object. If the name you typed in doesn’t match any macro in the code, then it throws that error.

3

Thank you Jenner. I will take a look

4

Also, check that the references are good. In some older versions of Access ti would not always update the references properly which causes some of the functions or subroutines to not compile or be available properly. (Database Tools, Visual Basic, Tools, References) Make sure the checked ones are ok (not missing).