Results 1 to 8 of 8
  1. #1
    AlexBierig is offline Novice
    Windows 10 Access 2019
    Join Date
    Jun 2025
    Posts
    2

    Question unwanted Stopmarker in Code (yellow marked line)

    Hallo
    may be I was looking with wrong keywords - sorry for the German Scool English...
    I'm using Access 2019 (part of Office 2019): Retail 7.1.11.27, running on Server 2016
    I have an Access Projekt in which the autostart-macro runs a function called Main() as long - this function checks the screen metrics, initalises connections and command-object to an SQL-Server. It also saves the settings from the Access, cuts off the toolbar an so on (this will be restored, when closing Access)

    To test some behaviour I set a stopmarker via F9 to check and proof. But I'm afraid, I saved the screen, the code or just closed Access, while the main-function was stooped at the break point, which I set with F9.
    This causes now some difficulties:
    Click image for larger version. 

Name:	accessstopsunwantedl.jpg 
Views:	31 
Size:	85.2 KB 
ID:	53120

    I can't take off this stop marker (having NO F9 stop-symbol)


    I run the function to it's end and saved it, closed the access, edited die makro, compiled it and saved it, saved the form in designer mode, running mode
    but this annoying stop resists.
    Has someone an idea what else I could do?

    regards
    Alex
    Attached Thumbnails Attached Thumbnails accessstopsunwanted.JPG  

  2. #2
    jojowhite's Avatar
    jojowhite is offline Competent Performer
    Windows 11 Access 2021
    Join Date
    Jan 2025
    Posts
    430
    Click on that Line of code and press F9 (toggle debugging) then Save (ctrl-S) your code.

  3. #3
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,550
    And if that does not work, try a decompile and recompile.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 11 Access 2021
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    F9 sets a breakpoint. A breakpoint is identified by a red circle in left margin which doesn't show for you.
    In my test, breakpoints are cleared when database closes.
    This does appear to be some sort of corruption. If clearing breakpoints from Debug menu doesn't work, nor decompile/compile, create a new module and copy/paste code. Delete old module and rename new. If that still doesn't work, might have to create new db and import from the old.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    isladogs's Avatar
    isladogs is offline Access MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,204
    This may be due to a 'phantom' breakpoint
    Make a minor change to the procedure such as adding a blank line and then save and compile.
    This should fix the issue if the other suggestions haven't done so.
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

  6. #6
    Vstar920AZ♣ is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2023
    Location
    Phoenix, AZ
    Posts
    11
    This happens to me on occasion too.
    The two things I do that often help are to toggle all breakpoints from the menu bar (that way, theoretically I get them all). Then I move the code down a few lines. Some of these errors seemed to be based on line position and this solves it most of the time.
    Sometimes I insert a blank module (this won't help on forms). Then I move the code to the new module.

    Viel Gluck!!

  7. #7
    AlexBierig is offline Novice
    Windows 10 Access 2019
    Join Date
    Jun 2025
    Posts
    2
    Hello together

    sorry for the late answer - my wife wanted me doing some holidays at Lake Constance without a computer. So we enjoyed the few days, includung the icy and heavy thunderstorm.
    I got a lot of suggests for the solution of my problem.
    In my case solved the problem:
    This may be due to a 'phantom' breakpoint
    Make a minor change to the procedure such as adding a blank line and then save and compile.
    This should fix the issue if the other suggestions haven't done so.

    AND... an office update, which suddenly raised...

    Thank you for helping me

    Regards
    Alex. Bierig

    ps: now I'm looking, if there is a button: solved.

  8. #8
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,550
    Thread Tools, top right of thread.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

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

Similar Threads

  1. Replies: 1
    Last Post: 07-12-2023, 08:24 AM
  2. Replies: 2
    Last Post: 07-12-2016, 12:11 PM
  3. How to make string background Yellow?
    By Cecil in forum Access
    Replies: 3
    Last Post: 05-19-2016, 06:57 AM
  4. Replies: 3
    Last Post: 03-14-2012, 12:33 PM
  5. Replies: 2
    Last Post: 03-20-2010, 11:08 AM

Tags for this Thread

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