Tags Tags

Echo On = No crashing macro in Access 2007

March 25th, 2010 - 11:57 am ET by gregl | Report spam
Help Create a new topic
I created a database in an earlier version of Access (2003) that contained a
macro with the Echo On = No action that worked fine. However, when I open
the database in Access 2007 and run that macro, the Status Bar Text doesn't
show and after the macro executes Access (but not my pc) is frozen. I have
to close and then reopen the database to see the results (which do appear to
be correct.) I guess this is somehow a security issue (because when I set
Echo On = Yes, the macro runs fine), but I've scoured the Help files and the
message boards, tried everything I can think of, and nothing solves the
problem. Any insight into my security settings or anything else that could
be causing this problem would be appreciated.
email Follow the discussionReplies 3 repliesReplies Make a reply

Replies

#1 Steve Schapel
March 25th, 2010 - 04:56 pm ET | Report spam
Greg,

Do you have another Echo action at the end of your macro to set it back to
Yes?

Steve Schapel, Microsoft Access MVP


"gregl" wrote in message
news:
I created a database in an earlier version of Access (2003) that contained
a
macro with the Echo On = No action that worked fine. However, when I open
the database in Access 2007 and run that macro, the Status Bar Text
doesn't
show and after the macro executes Access (but not my pc) is frozen. I
have
to close and then reopen the database to see the results (which do appear
to
be correct.) I guess this is somehow a security issue (because when I set
Echo On = Yes, the macro runs fine), but I've scoured the Help files and
the
message boards, tried everything I can think of, and nothing solves the
problem. Any insight into my security settings or anything else that
could
be causing this problem would be appreciated.

Similar topics

Make your own search :