pause without break point

[Guest]

Hi all,

sometimes, execution pause without breaking points and can continue if F5
key pushed. could you tell me the reason?

Clara

 

[Ronald Dodge]

I only had one situation happen to me, which actually took place in Access.
There were no break points, nor was there a "Stop" command at the point
where VBA stopped running and took the user into VBA while testing the
program out, but it was pretty persistent that it happened at one particular
point in the code, and it only took place the first time around it was ran,
but yet, there was no error message or anything. Not even the typical
Continue, End, Debug, and Help error dialog box.

Since that time, we are no longer facing the issue. However, I'm not sure
if it was due to some update that had to be done or if there was some other
change that stopped it from happening again.

Are you finding a similar type finding or what sort of pattern are you
noticing when this takes place?

Does it happen only the first time it is ran since the file being opened?
Does it stop at a particular point every time, when it does happen?
Is it some other persistent pattern as to when this happens?

--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000

 

[Guest]

Hi Ronald,

The following are some points which I think is improtant to describe the
situation:
1. I made some change in code, but the change is very small
2. the 'stop' happened some times in the same place
3. there was a yellow stripe marking the code line and nothing
4. I have met similar cases sometimes in Excel VBA

thank you for your reply

Clara

 

[Crazybass2]

I have a similar issue that started around the same time of the original post
(10/07). However, on my system it is not related to any one excel VBA code,
but most workbooks with code. The only change to my system have been the
normal MS Fix/Patch files that are pushes to our computers through MS Update.


Code runs fine, but the user has to continually click the CONTINUE button to
execute code. There is no consistency to the problem...sometimes code runs
without stopping, other times it stops every few seconds.

 

[xluser]

My pc has a similar problem if I keep debugging the programs but if I reboot
the pc
and click f5, the program will run without stopping. But any debugging done
on any programs will start them all over again, so I always need to reboot pc
to stop it. The same program runs fine on other pc.
But I have another program that runs fine on my pc and when it runs on
another user's pc, it will just stop halfway, without error message or
anything at all. You
wouldn't even notice it stop running. This will happen if the user does
other things (open another Excel or open a database) when the program is
running but it's fine
if the pc is just left alone to run the program.
Any idea what is causing this?