Results 1 to 4 of 4
  1. #1
    mks123's Avatar
    mks123 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2014
    Posts
    33

    Macro not stopping at "Toggle BreakPoint" or Stop

    Hi,

    Currently I'm investigating one project which has already created the thing is that I'm not able to use "Toggle BreakPoint (F9)" and also stop (to use to stop macro at word "Stop)

    In other words macro not stopping at breakpoint or Stop keyword, It just complete the entire process and shows message "Done".

    Also I have used code "CurrentDb.Properites("AllowBreakIntoCode") = True". But its not working.

    any suggestion most welcome.




    Thanks,
    mks

  2. #2
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Is this really a macro or is it code? I've heard of using the 'step through' function of a macro, but never heard of putting break points in a macro - only in a procedure in a module.
    If it's code, put your break at the start and F8 single step through it. Whatever condition you expect to exist in the section where you're putting a break probably isn't the case, thus the code doesn't execute as you expect. If it's really a macro, excuse my ignorance as I'm a bit behind in Access versions.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    mks123's Avatar
    mks123 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2014
    Posts
    33
    I am able to put breakpoint and stop .... and then when I press F8 or F5 it just complete the entire process don't stop at breakpoint.

  4. #4
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    If you're happy with your solution for this problem which was achieved at Mr. Excel, http://www.mrexcel.com/forum/microso...ml#post4534171

    please mark this thread as solved. If you're not the same person, let us know that you still have the problem.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 18
    Last Post: 11-04-2015, 02:13 PM
  2. Replies: 1
    Last Post: 09-07-2015, 08:00 AM
  3. Disabled Breakpoint continues to stop code
    By Glenn_Suggs in forum Access
    Replies: 3
    Last Post: 08-15-2014, 04:32 PM
  4. Replies: 2
    Last Post: 02-21-2012, 01:35 PM
  5. Replies: 7
    Last Post: 01-29-2012, 07:44 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums