Access 2010 Macro not Functional in 2007

[dargo72]

Hello,



I created a database with a macro in Access 2010. The macro runs when you click a button. When someone clicks the button in Access 2007, the record is saved, but the macro does not automatically close the form and the database as it should. The following error message is received.

What should I do so that users (not using 2010) can utilize this database function.

Thank you,

[ItsMe]

It seems as though you are trying to call a macro that needs a control to be active. Is there a control on the form that is not available for editing/saving at the time the macro is being called?

[Dal Jeanis]

The basic answer is this - Access is not backwards compatible. You have to code it on a machine at the lowest level that you need it to run - in this case, on an Access 2007 machine. Sorry.

[ItsMe]

The basic answer is this - Access is not backwards compatible. You have to code it on a machine at the lowest level that you need it to run - in this case, on an Access 2007 machine. Sorry.

There it is in a nutshell. For some reason I wasn't comprehending. Must be suffering from dyslexia.

[dargo72]

There it is in a nutshell. For some reason I wasn't comprehending. Must be suffering from dyslexia.

Thank you for the replies. I am going to work on it using someone else's computer that has only 2007. I was just hoping that there was a trick to use to ensure that I could create macros with arguments/methods that would be acceptable to 2007.......

[Dal Jeanis]

You don't necessarily have to code on 2007. Alternative is, decompile, recompile and test the result on 2007.

The only other alternative is to limit yourself to .mdb, which even if coded on 2010 should be backwards compatible to 2003, therefore 2007.