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 - 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.

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

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

News on Access 2019 and Office 2019 - Updated - 2018-04-16
Modern Charts in Access 2019.

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

Book Recommendations for Software Developers - Updated - 2017-12-27
Evergreen books that will never become obsolete! - Added ‘The Unwritten Laws of Business’

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