Results 1 to 2 of 2
  1. #1
    jeffbase34 is offline Novice
    Windows XP Access 2003
    Join Date
    May 2009
    Posts
    1

    Is There a Way to Debug or Step Through VB code?

    Hey guys,



    I am trying to break down an Access database designed by a programmer several years ago. I've hit a brick wall because the mdb uses VB code which I don't know.

    Thankfully, the guy inserted detailed comments so I can somewhat follow the code. My problem is I don't understand what gets executed when. Is there some way or an app that could step me through the code and show me exactly what it is running on the front end? The code refers macros that reference other macros which references queries.

    Thanks!

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Access is Event driven so it can be a bit confusing to follow until you inderstand the Event model. If your system is using macros rather than code I'm not sure the debugger can single step through macros. In code you just clock outside of the left margin in the code window to set a break point and when the code stops, F8 will single step the code. VBA has an excellent debugger.

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

Similar Threads

  1. Replies: 4
    Last Post: 04-29-2009, 04:59 PM
  2. Need help with code
    By hoenheim in forum Programming
    Replies: 9
    Last Post: 09-11-2008, 04:19 PM
  3. Need Help Getting to Code
    By Snuffles in forum Programming
    Replies: 8
    Last Post: 04-22-2008, 05:25 PM
  4. Navigation Code
    By henryclay in forum Forms
    Replies: 2
    Last Post: 11-15-2006, 09:48 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