Macro not stopping at Toggle Breakpoint - MS ACCESS

[MUKESHY12390]

Hi frnds,

Currently I'm investigating on some project that has already created the thing is that when I set "Toggle breakpoint" and try to run macro it don't stop at toggle breakpoint , it just get complete the entire process.

I have tried "CurrentDb.Properites("AllowBreakIntoCode") = True", but its not solve my problem.


waiting for some expert suggestion.

 

[Derek Brown]

First of all you need to be certain that the processing does indeed get to the breakpoint.
Add a new line to the macro (at the point where you want the breakpoint) with the single VBA command "Stop".
If it does reach that line, try "cleaning" the code modules by copying the code to a new module.

 

[MUKESHY12390]

I have tired that by adding "msgbox "hi" at very beginning but it doesn't work and also tried copying data into new module (on same database).

 

[MUKESHY12390]

thanks Derek for your help . I got solution.

 

[mole999]

what was the problem / solution. Sharing it might help someone else who looks at this thread

 

[MUKESHY12390]

you can refer to the link http://www.mrexcel.com/forum/micros...pecial-keys-option-ms-access.html#post4534530

also if it doesn't help you I can explain more in detail, just let me know

 

[mole999]

As you appeared to have had resolved in the other thread, I will lock this one to prevent duplication of unexplained effort