PC Review


Reply
Thread Tools Rate Thread

A2007 Macro issue

 
 
LACOPERON
Guest
Posts: n/a
 
      11th Mar 2010
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...
:-)

 
Reply With Quote
 
 
 
 
Brendan Reynolds
Guest
Posts: n/a
 
      12th Mar 2010
"LACOPERON" <(E-Mail Removed)> wrote in message
news:1A553CAF-87A9-445D-A25F-(E-Mail Removed)...
> 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.

--
Brendan Reynolds

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
MDE in A2003, A2007 MacDermott Microsoft Access Form Coding 0 3rd May 2010 04:57 PM
A2007 -> A2003 did not go well Avid Fan Microsoft Access Form Coding 2 7th Apr 2010 10:18 AM
ListCount bug: is it OK in A2007? Vladimr Cvajniga Microsoft Access 3 5th Jan 2008 06:02 PM
MDE from A2007 for use in A2003 =?Utf-8?B?VG9tIFZlbnRvdXJpcw==?= Microsoft Access 3 6th May 2007 03:50 PM
Excel Macro Issue Trying to autorun Macro Upon Opening Worksheet wyndman Microsoft Excel Programming 2 25th May 2004 06:59 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:31 PM.