Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Debugging with ReturnVars and TempVars

Access 2013: The Missing Manual; By Matthew MacDonald
First, I think this book is terrific. Second, I had difficulty figuring out how to display the contents of both ResultsVars and TempVars while debugging. It turns out that you can't get Access to concatenate them with a string in the Message Box macro. Also, it is squinky (that's both squirrely and hinky) about how it decides to reference the values depending on the function: The ever-moving, equal-signed, expression.Would be nice to have a description of how these magical fields actually Work, which would be an expansion of what's already in the book. Took me Days to figure this out, with lots of slow, controlled, regression testing. :-)
1 person likes
this idea