General Meeting Presentation

Tuesday, November 6, 2018

Jim Pilcher

Reports, Sub Reports, and Banishing VBA

Jim Pilcher

Complicated business requirements can sometimes require complicated reporting. Many of us immediately start thinking VBA as a way to enhance and extend the Microsoft Access reporting environment. Unfortunately, that sometimes can turn into a rat’s nest of code and unnecessary complexity. In our November meeting, DAAUG Vice President Jim Pilcher will demonstrate creative use of subreports to reduce and eliminate VBA code in a complex situation dictated by a client’s requirements. He will first show you a VBA solution and then, understanding how subreports behave in Access, how he virtually eliminated behind-the-scenes VBA manipulation with a creative and atypical approach to sub reports. At the end of the meeting you should have some fresh ideas about how to apply your own creative solutions to Access reporting. Bonus: If time permits, Jim will also give a brief overview of the powerful command line options when starting up Microsoft Access.

Jim Pilcher, the current DAAUG Vice-President, is a prominent Microsoft Access developer in the Colorado Front Range, having worked with Access professionally since its introduction in 1993. Jim’s company, DataOne, Inc., maintains a broad clientele base providing database solutions for local and state-wide enterprises, as well as large international companies. A frequent presenter at the Denver Area Access Users Group, Jim has served twelve terms as its President, and eight terms in other DAAUG capacities. Visit his web site at www.dataoneinc.com