A2007 Macro issue

[LACOPERON]

Hi Everyone
Got an error message “cannot run macro XXX†while was working on creating
some tables in my database. What I was working on had nothing to do with the
particular form the macro calls or the macro itself. The macro is simply a
“close YYY form “. When I went to check the macro, noticed that there is a
yellow triangle with an exclamation point inside on the line for the close
action. I checked all the macros and this appears on all the macros that use
the “close†action. The macros work when I run them from the forms and it
dosent seem to cause any other problem when just using the DB. Can someone
can let me know what this icon means?…. operating info, running DB from
server, I’m using access 2007 (OS: XP-SP3) and have 1 user running access
2003 (OS: XP-SP3) The DB seems to run fine from 2003 system, could this be a
03-07 version issue? The DB was originally created in 03 but have been forced
to admin from 2007. has been operating trouble free for more than a year
until this
Thanks everyone...

 

[Brendan Reynolds]

Hi Everyone
Got an error message “cannot run macro XXX†while was working on creating
some tables in my database. What I was working on had nothing to do with
the
particular form the macro calls or the macro itself. The macro is simply
a
“close YYY form “. When I went to check the macro, noticed that there is a
yellow triangle with an exclamation point inside on the line for the close
action. I checked all the macros and this appears on all the macros that
use
the “close†action. The macros work when I run them from the forms and it
dosent seem to cause any other problem when just using the DB. Can
someone
can let me know what this icon means?…. operating info, running DB from
server, I’m using access 2007 (OS: XP-SP3) and have 1 user running
access
2003 (OS: XP-SP3) The DB seems to run fine from 2003 system, could this be
a
03-07 version issue? The DB was originally created in 03 but have been
forced
to admin from 2007. has been operating trouble free for more than a year
until this
Thanks everyone...

The icon means that the macro action is not trusted. If I remember
correctly, I believe the Close action is trusted only if the Save argument
is set to Prompt.