=========
REF:
http://www.mrexcel.com/forum/showthread.php?t=355482 

=========
It appears the SetWarnings Action is missing when building a new Macro.
Go to the Design Tab, click Show All Actions


http://www.anysitesupport.com/access-2007-macros-setwarnings/