Code stopping at breakpoint... but there isn''t one.

  • I have a code that runs a query in SQL, and when it gets to the code that runs the query Access stops. It acts as if I've put a breakpoint in, because if you hit F5 the Access continues through the code.

  • Never mind...

    I went into the code, added a breakpoint and a bookmark. Saved the code. Removed the breakpoint and bookmark saved the code. No change.

    I added a space to the sql query (because I knew this would have no impact on the query) and viola... no more breakpoint.

     

  • What I do when that happens is that I cut the line then repaste it in place (quick ctrl-X, ctrl-v).  This works everytime, but I must admit it's very annoying.

     

    Anoter thing I do before sending my work is use the clear all break points from the debug menu.  I'm not sure it's bulletproof but it seems to do the job for the moment.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply