Breakpoints

[dmarti69]

We are having a problem with a specific access 2000 database. The breakpoint or stop option in the VBA will not work it just skips right over it. It will work on other databases though. Is there a setting or security that we should check.

Thanks

 

[pdx_man]

Set breakpoints in the entire procedure and trace. The code that currently has a breakpoint just might never be executed.

 

[dmarti69]

We tried that it wont stop for even a stop command.

 

[pdx_man]

Is this an Event Procedure or code in a module? If Event, which one?

 

[dmarti69]

Its in the vba code for debugging. In the database in question it wont stop at breakpoints

 

[pdx_man]

Yes, but is the code from the Module tab or is it code behind a Form or Report.

What is the code/procedure in question?

 

[Atomic Shrimp]

I think PDX has a pont here; It sounds very much as though the code in which you have set the breakpoints simply isn't being executed at all; for example it might be within a conditional block or loop (If/Then, While/Wend Do/Loop etc) where the condition is never being met:

'Condition:
If 9=8 then
Msgbox "You Will never see this Message Box"
End If

if you put a breakpoint on the Msgbox line,it will never stop there as Access skips over that bit because the condition 9=8 is never true.

Alternatively, the breakpoints you have set might be in an event that simply doesn't get triggered (or hasn't as yet) - for example the OnClick event of an object that is not enabled etc, or perhaps an event related to an object that you have subsequently deleted or renamed.

HTH

Mike

 

[dmarti69]

The code is from a form. We have put numerous breakpoints in and stop statements in and it still wont stop. This is a converted access 97 database.

 

[pdx_man]

Ok, we're getting closer to what I'm looking for. What is the actual code in the first line of the procedure

ie
Private Sub Form_Activate ()
:
:

What is it that you are trying to do. You may just be using the wrong event for what is actually triggering.

[This message has been edited by pdx_man (edited 02-14-2001).]

 

[BarkerD]

For some reason (I don't know why) Access seems to not execute code on an event. I have had this happen, and this is what I did to solve it.

Delete the Event Procedure in the properties box, and then use the code builder to re-link the code in the form module to the event. This could be a bug, I'm not sure.

HTH
Duane Barker