Denver Area Access Users Group

General Meeting Presentation

Tuesday, October 6, 2009

Table Interface Classes and Automated VBA Code Generation

Lindsay Wert

Development of any non-trivial MS Access application can involve generation of a variety of VB code elements. Some of these elements may feel repetitive because the pattern is the same, but the details are different. In this discussion, we will explore an area where such repetition is advantageous, but repetitive nonetheless, namely VB classes to interface with Access tables. In addition, an add-in method for automatically generating the VB code for these classes will be discussed.

The discussion will include:

  • Table interface classes, what they are, their purpose, and examples of their use
  • Automated VB code generation based on templates and table definition extracted using DAO, and implemented as an add-in.

Lindsay Wert is a consulting product development manager and engineer with extensive experience managing and participating in engineering development of multiple-technology electro-mechanical devices and software applications, including applications for small business based on MS Access and Java web platforms.