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!

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.

__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"