Denver Area Access Users Group

General Meeting Presentation

Thursday, October 19, 2023

Alessandro Grimaldi

"VBA Pills" - Access Tips and Tricks

Alessandro Grimaldi

IMPORTANT: This presentation is at 10:30 AM Mountain Time

Over the many years of his Access work, including some innovative Access UI programming in VBA, Alessandro Grimaldi has collected quite a number of VBA snippets. Join us as he presents a number of what he calls "VBA pills", showing tricks and techniques you might not know yet.

Topics include:

  • Hardware info (computer, memory, hard disks, monitors)
  • Tools: magnifier, screenshots, webcam, whatsapp
  • Zip files: zip, unzip, file counting
  • Working with records: delete duplicates, get next record ID
  • Working with files: read a whole folder, shorten a path

A programmer since 1983, VBA since 1998, for several years Alessandro was consulting for the United Nations in different countries (Italy, Afghanistan, North Korea, Ethiopia, Austria), creating tons of Office applications, from simple automation tools to corporate level applications. Since 2014 he lives in Frankfurt where for five years he worked as a VBA developer for the European Central Bank. He has been experimenting on graphical interfaces with Access since 2006.