Break Points Don't Work

[Paul H]

For some reason none of the break points I set work. Access just skips right past them. I've resorted to using msgboxes just to see if the code is running at all. I'm no receiving syntax errors I should be getting. Is there some setting in Access or Database options I need to change? I am working most of the bugs out, but makes simple tasks much harder.

Thanks in advance.



Paul

[aytee111]

Put the break point on the function/sub name, then you will know that the code is not being bypassed. There is no particular on/off switch for them, they are a standard part of the VBA editor.

[orange]

I'm no receiving syntax errors I should be getting

Can you show us some code?
Have you tried stepping through code?
Msgboxes on entry to function and again at exit may be best practical option.

[Paul H]

It doesn't matter where I put the break point. It won't break, so I can't step through the code. Yes, I used the msgbox to verify the code was running.
Skipping to the chase. I finally got the form working as desired, but debugging it was hell.

It's just the weirdest thing.

This code that I wasn't sure was running clearly has a syntax error, see below.

   
Private Sub cmdGenderB_Click()
    
    strReportName = "rpt R00003B Gender"
    DoCmd.OpenForm Form, "frmReportParms_B"
    
End Sub

When I clicked the button it would just blink at me like nothing happened. I would have expected an error message on this.
I finally spotted it and fixed, but again it was puzzling. It still is. So if someone else has the same problem, I can assure them they are not the only one.

Thanks for chiming in.

Paul

[Paul H]

To put this subject to bed I finally succeeded by creating a blank database and importing every object from the old to the new. The import stalled towards the end, but after testing it looks like all or most of the bugs have disappeared. I can now set break point and call up VBA modules with a few keystrokes. Probably should have tried this sooner. So far so good.

Paul