This is the Access category.

This category includes Microsoft Access code samples for VBA. Queries, forms and reports may also be covered.

Access icon

Reference latest version of DBEngine

In How to get most recent DBEngine object, Access MVP Alex Dybenko shows us some VB.NET code for grabbing the latest version of DAO's DBEngine Object.

It smartly uses a loop to start from the newest version and walks its way down to the lowest version, trying to set an object reference each time. But the VBA version of the same code just hardcodes each version. Why not loop in VBA as well?

Continue Reading »

Peltier Tech Charting Utilities for Excel