Application stopping in VBA Module

  • Thread starter Thread starter PSULionRP
  • Start date Start date
P

PSULionRP

I have an Access Application that I am enhancing and when I click on a button
on the form, it is reaching a statement in a VBA Module and is stopping. I
don't have any breakpoints set. Why is it just stopping??? The line is yellow.

Can anyone help me out here???

Thanks in advance for your review and hopeful for a reply.

Thanks!

PSULionRP
 
In the VBA window, choose Compile on the Debug menu.
Fix any errors, and repeat until it compiles okay.
(The Compile item greys out on the Debug menu.)

If that doesn't solve the problem, perform a decompile.
You probably want to follow the recovery steps listed here:
http://allenbrowne.com/recover.html
 
FWIW-

For cases of "phantom breakpoints" as described by OP, it's usually
sufficient IME to just copy the line where the code stopped/highlighted
the yellow (and to be safe, the above & below lines as well) then delete
those lines and re-insert the code by pasting it back again.
 
Yes, that may solve it.

Once I see any inconsistency between the 2 versions of the code (text and
compiled), I personally want to decompile to deal with whatever other rocks
are hidden under the surface.
 
Allen said:
Yes, that may solve it.

Once I see any inconsistency between the 2 versions of the code (text
and compiled), I personally want to decompile to deal with whatever
other rocks are hidden under the surface.
Click to expand...

Aha, I see where you are coming from. I took Michael Kaplan's advice to
not use decompile too often and only as a last resort so for that
reason, I tend to try and fix phantom breakpoint by deleting &
re-inserting the code based on this principle.

Of course when a product reaches a major development, I usually want to
import everything into a fresh blank file, which should usually clear
out the gunk I created throughout my development.
 
Back
Top