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

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.

Windows 10 – Synaptics Touchpad – Solution for Click not working - New - 2018-12-28
A weird and simple solution to Synaptics Touchpad click not working in Windows 10

Access-SyncScrollBarsSample - Updated - 2018-09-23
I upgraded this Access-VBA-Sample to synchronize the scroll bars of two Access Forms to include a reusable component. (There is a linked video showing me implementing the upgrade, as well!)

News on Access 2019 and Office 2019 - Updated - 2018-07-21
Modern Charts demo video available.

DFirst/DLast and the Myth of the Sorted Result Set - Updated - 2018-07-06
Common questions answererd, common myth debunked!

Access - Calculated Fields in a Query - Updated - 2018-06-11
How to use calculated columns in Access queries. This article shows simple mathematical calculations as well as the use of custom VBA functions.
- Now with video tutorials.