Debug Point - Step-by-step not displayed

[gray]

Hi

Access2007

I have a couple of debug points set in my code... one in Form-ApplyFilter and one in Form-Timer.

When I apply a filter the code steps thru' the ApplyFilter event OK but from that point my debug points are ignored... i.e. Access does not step thru'

I have set
Me.Form.OnTimer = "[Event Procedure]"
and
Application.Echo True

explicitly in my ApplyFilter Event to make certain it's not that.

I know it's running the form timer code cos' I've a got diagnostic msgbox in it....even placing the debug on that msgbox does not get Access to step thru'

Any ideas anyone please? THanks

 

[boblarson]

Make sure you haven't unchecked the USE ACCESS SPECIAL KEYS checkbox in the Startup Options. That will cause breakpoints to be ignored.

 

[gray]

Hi Bob

Apologies for late reply - distracted by a 1 day job that took 2 weeks!

I've verified that option thanks.. I've also done the usual compact and repair.. I've created a copy of the Db, deleted the code module and restored it (via notepad to lose any phantom control charcters)... I've forced the offending event to run on form-open and it steps thru' OK... but the step thru' just will not work post-ApplyFilter event.

I know Applyfilter can call current events in main and subforms so I've put debugs in those too....

Still nothing steps thru' after the applyfilter

Any other ideas please?

 

[boblarson]

If you haven't done a decompile, you should probably try that.

 

[gray]

Cheers Bob!! That's worked... I now have a step thru'

For anyone else with this problem... try... Start-Run (on XP) then type...

"c:\Program Files\Microsoft office\office12\msaccess.exe" /decompile "c:\Shared_Network\Test.mdb"

Replace the directory for msaccess.exe plus directory and name of your mdb as appropriate... but ensure quotes are as shown.


Thanks again...