Results 1 to 4 of 4
  1. #1
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664

    Walking through the VBA code

    I have a lot of time debugging computer source code. The VBA code in MS Access 2010 is in a league by itself.

    Hence this post. When I am going through some VBA code line by line in this debugger, it is harder.



    For instance when the program transfers out of one subprogram to another it is hard to understand exactly where you now are.

    Yes, you know the program has shifted to a new location, but no you do not know the name of the new piece of code that you are now in.

    Most debuggers keep track of that at the top of the screen showing you where you now are.

    Is there a way for the VBA debugger to do the same? It just makes tracing the programs steps much easier.

    Any help appreciated. Thanks in advance.

    Respectfully,


    Lou Reed

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    yes you do know. whereever the code is, look at the top left or right combo box of the code screen.
    the left one shows objects, the right one show lone Subs and functions.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    As ranman says-- you do know if you look at the "boxes".

    What exactly does this mean I have a lot of time debugging computer source code.
    You have time to review code?
    You have already spent a lot of time reviewing code?
    You have a lot of code awaiting review?

    Lou, with 500+ posts, I'm sure you have some experience debugging code.
    See this link for details on debugging vba.

    UPDATE: Sorry forgot to include link in original post.

    Thanks RuralGuy for the reminder.
    Last edited by orange; 12-09-2016 at 11:51 AM. Reason: added link

  4. #4
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    What exactly does this mean

    Code:
    I have a lot of time debugging computer source code.


    It means that I have used source code debuggers for a long time. The MS Access VBA code debugger was not as clear as to where you are in the
    walk (so to speak) as the others were..

    Respectfully,


    Lou Reed

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

Similar Threads

  1. Replies: 5
    Last Post: 08-29-2016, 04:33 AM
  2. Replies: 20
    Last Post: 10-13-2015, 09:05 AM
  3. Replies: 3
    Last Post: 10-16-2014, 08:49 AM
  4. Replies: 7
    Last Post: 05-28-2013, 09:11 AM
  5. Replies: 1
    Last Post: 05-04-2013, 12:19 PM

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