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

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.

The Access ADP Story - New - 2018-05-15
A farewell to this important part of the Access history

3 Access and VBA Book Recommendations - New - 2018-05-12
My favorite books on general Access and VBA development

VBA Navigation History Add-In - New - 2018-03-11
Tracks your code position history in the VBA Editor

VBA-(SQL)-String Tutorial - New - 2018-02-27
Companion Text to my VBA-(SQL)-String Video-Tutorial for Beginners

Validation Rules and Check Constraints in Access - New - 2017-12-27
Declarative data validation in Access with Validation Rules and Check Constraints.