Event failed to run error!!

[Blakey129]

Hi i am getting the error below when i try to open forms in my access database, I developed the database on my pc at work but decided to bring a copy home for editing and design changes, i am running access 2007 - can anyone help? Thank you all.




This error occurs when an event has failed to run because Microsoft Office Access cannot evaluate the location of the logic for the event. For example, if the OnOpen property of a form is set to =[Field], this error occurs because Access expects a macro or event name to run when the event is fired.

[ItsMe]

How did you copy the DB? If you Import objects you need to make sure and include macros and such. There is a button to click for "Options" in the import wizard. This will allow you to select things like custom menus and import procedures, etc. Also, Macros are not always compatible with different versions of Access. So if you are using 2007 and the Macro was made with 2010 you are probably going to experience problems.

[Blakey129]

Hi thanks for replying, i copied the entire database by just right clicking it and copying to my pen drive, I then just copied it again to my personnel laptop, i am running access 2007 on my macbook pro, I installed access 2007 using the program"crossover" which allows you to run microsoft software on macbook's, the program is working ok apart from when I want to view code, the macbook just locks up ? - however i still get the original error code whatever happens? - thanks again

[ItsMe]

On Open is an Event Handler. I am not sure what =[Field] means. If you have a Macro Run in your event handler that is one thing. Causing On Open to equal something is another.

Having an event handler = something should not work on a Mac or a PC.

Can you post your code for the On Open event? If the code is correct an calls a Macro, your OS on your Mac is probably missing a component that is required by the Macro.

[Dal Jeanis]

It is saying that it cannot find the VBA or the macro for one or more of the form's events.

Check on the work machine, for one of the forms that is failing at home, and see if the event handles are macros or code. If they are macros, then you know that the macros somehow didn't get to your home machine. If they are VBA, then you know THAT didn't make it.

the program is working ok apart from when I want to view code,

Ah. So something is NOT working right about your crossover-installed Access 2007. I'd expect that one or more of the references required by the Access VBA coding environment are missing from your macbook.