Echo On = No crashing macro in Access 2007

  • Thread starter Thread starter gregl
  • Start date Start date
G

gregl

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.
 
Greg,

Do you have another Echo action at the end of your macro to set it back to
Yes?
 
No I don't. Is that necessary in 2007? (I didn't need to do that in 2003.)
And does that explain why the Status Bar Text doesn't display? Thanks.
 
Greg,

You are quite correct, it should not be necessary. I am sorry about my
unclear previous reply... I should have said to try putting an Echo/Yes
action at the end of the macro, as an experiment as part of the process of
trying to diagnose.

The other question is that I assume you have the database in a folder that
is set up in Access 2007 as a Trusted Location?
 
Similar Problem

I am running Windows 7 with Access 2007. The problem is that the macro i have runs fine on the computer that created it, but when other computers try to run the macro it locks up Access and just beeps everytime you try to click or anything. You actually have close Access inorder to do anything. I has to be some sort of security setting but i cant find it. The other macro i have in the file works fine. If i could post the file I would.

This file is for an online class and my instructor cant get it to run, and I cant get it to run on any of my other computers.

Any suggestions??

Doug

PS. This does not have any Echo commmand in it, but does have a SetValue action set with a Visible set to false.
Hope that helps any.
 
Last edited:
Ok i found the problem with mine. I have a Duel monitor set up. For some reason with Access was bringing up a new prompt window it was trying to put it on the second screen, which other computers dont have.So the reasont it was Dinging was because there was a prompt window waiting on input that you could not see.

Took me a while to figure it out, and now i got it.
 
Do not know what ths about. I dd snd an inqyiry a while
I use entourage ver 10,o for Mac
 
Steve, replying to your response to my response to this post (which I saw on
another board where this thread appeared, but for some reason don't see here)-
Added Echo On = Yes action to end of macro - macro doesn't blow up now at
least, but of course still doesn't display Status Bar Text ("Macro is
running") embedded in Echo On = No action set at beginning of macro.
I run this macro from a form. Interestingly, when I have the form open and
run the macro while in the macro design view, I do see the desired text while
the macro is running (and it goes back to "Ready" when the macro is done)!
It doesn't blow up either, even when I remove the Echo On = Yes action from
the end.
I do have the database in a trusted location.
So this is an improvement, but I'd still like to see the Status Bar Text
"Macro is running" when I run the macro from the form.
Thanks again.
 
Back
Top