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

"Query is corrupt"-error after Microsoft Access November 2019 Update - Updated - 2019-11-28
Update: Access 2010 and 2013 patches for this error available!

Logical numerals sorting in Access with VBA - Updated - 2019-10-31
Sort numbers in text fields in Access by their numerical order.
Updated: Bugfix in the demo code

Microsoft Access developer conferences around the world. - Updated - 2019-10-31
I compiled a list of significant, international Microsoft Access developer conferences.
Updated with some new information.

Field report from Netherlands Access Developers Day 2019 - New - 2019-10-09
My personal perception of the NADD-2019 conference

Software Quality + Unit Tests in Access-VBA - Updated - 2019-10-05
Landing page for attendees of my talks on Software Quality and Automatic Testing at Access DevCon 2019 and NADD 2019

VBA Class Module to access the clipboard - New - 2019-09-03
This slighly unfinished class module can retrieve file content from the clipboard

VBA-Bug introduced with the latest (2019-08) Windows Update - Updated - 2019-09-02
August 2019 Windows Update causes VBA applications to fail with an "invalid procedure call error"
UPDATE: Patches available for all 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

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