Codekabinett - Access, VBA & Co.

Welcome to the Codekabinett-Website!

On this site you’ll find a growing collection of articles about Access, VBA and SQL programming. There are articles for beginners as well as programming experts available here.

My current focus is on providing guidance on how to write VBA code that does not just get the job done, but is also readable, robust and maintainable. This particular sub-topic is mainly covered by the Better VBA video series.

Of course I try my best to provide working, error free explanations, samples and download. Still, sometimes an error or bug slips the net. I love to get corrections and suggestions for improvement anytime. If you have any, just email me.

Thank you for visiting.

Phil
(Philipp Stiefel)

The most recent updates on this website...

RSS-Feed

VBA-Bug introduced with the latest (2019-08) Windows Update - Updated - 2019-08-19
August 2019 Windows Update causes VBA applications to fail with an "invalid procedure call error"
UPDATE: Patches available for most operating systems!

Access/VBA - Formatting dates for a specific Locale - New - 2019-08-01
How to format Date/Time for a specific language and country diffrent from the current regional settings

Microsoft Access developer conferences around the world. - New - 2019-07-14
I compiled a list of significant, international Microsoft Access developer conferences.

Software Quality + Unit Tests in Access-VBA - Updated - 2019-05-06
A tiny landing page for attendees of my Software Quality talk at Access DevCon 2019

Gallery PDF for Office imageMso icons - New - 2019-04-15
A quick reference sheet to find suitable icons

A String.Format / printf implementation in VBA - New - 2019-03-16
Another very useful example for applying the ParamArray keyword

The ParamArray Keyword in VBA / How to emulate the SQL Coalesce Function - New - 2019-02-28
Another not well known but very useful part of the VBA Language

Choosing an Authentication Mechanism for Access + SQL-Server-Applications - New - 2019-02-27
Windows Authentication, SQL-Authentication, or what else is right for your application?

ChooseFont-Dialog-API for 64-Bit-VBA - New - 2019-01-26
A VBA module, based on work by Terry Kreft and Stephen Lebans, to used the ChooseFont-Dialog from 64-Bit-VBA with the Windows API.