Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Jan 2005
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm trying to debug some code on a command button and 'stop' isn't forcing a break. Is there some special feature that will prevent 'stop' from breaking code execution in certain instances? (my message boxes aren't stopping the code either)
    Each Call statement takes around 30 seconds to run- would that have anything to do with it?
    I'm lost.

    I have:

    (lots of code)
    .
    .
    Call FYMedian("GPECR")
    Call FYPR("GPECR")

    MsgBox ("wtf?")
    Stop
    MsgBox ("wtf?")

    DoCmd.RunSQL "Delete TImmun.* From TImmun"
    DoCmd.RunSQL "INSERT INTO TImmun ( ImmunDate, Immun, Country )" & _
    .
    .
    (lots of code)

    Of course, I tried it first without the 'wtf' message boxes, which don't work either.

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts
    It wasn't clear, even though the code doesn't stop, are your message boxes displaying?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    Lounger
    Join Date
    Jan 2005
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I just found my mistake- everything is fine.

    (I missed a branch in the code above this section, which was diverting control to another module, so this code was never being run.)

    Feel free to delete this entire posting (I feel like an idiot...)

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    [quote name='bst73' post='796821' date='08-Oct-2009 05:06']I just found my mistake- everything is fine.

    (I missed a branch in the code above this section, which was diverting control to another module, so this code was never being run.)

    Feel free to delete this entire posting (I feel like an idiot...)[/quote]
    Easily done mate, we have all done that at some time or other.

  5. #5
    3 Star Lounger
    Join Date
    Sep 2001
    Location
    Stuck at work..., Missouri, USA
    Posts
    248
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Some of us more often than we'd care to admit.
    <font face="Comic Sans MS">Morgan Erickson</font face=comic>
    morgan.erickson@sprint.com
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>-From <img src=/S/flags/Colorado.gif border=0 alt=Colorado width=30 height=18> but living in <img src=/S/flags/Missouri.gif border=0 alt=Missouri width=30 height=18>...and working in Kansas.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •