Tuesday, October 26, 2010

The MsgBox prompt IF…THEN…ELSE Access macro

I don’t like Microsoft Access macros as much as I like VBA – I do a lot of work in VBA and know it well – although Access macros are useful in limited, simple tasks, anything that requires VBA expressions are not fun because you have to enter a VBA expression in a non VBA IDE.

MSGBOXmacro

Notice also, the editing environment is not conducive to using VBA Enumerations in the MSGBOX expression.

Note that Microsoft Access 2010 has enhanced the Macro Designer and added more Macro commands – you can create a macro in Access 2010 that will not survive running the same file under Access 2007. If you used VBA, you will probably need to re-compile to ensure VBA binary compatibility and keep on going.

No comments: