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

Using an External Num-Pad for OBS Studio Hotkeys - Updated - 2021-12-23
A daisy-chain solution for my own unusual scenario.

Async File Copy with the FileCopyEx API Function - 64bit Compatible - New - 2021-10-29
A Accss/VBA-Demo of the FileCopyEx-Function with Callback.

Creating WIX File Elements from a Visual Studio Project File Using PowerShell - Updated - 2021-08-04
A simple script to auto-generate WIX XML File Elements.

Sending emails with VBA and the CDO Library - Updated - 2021-07-09
The text was extended with specific info for Office365, Gmail, HTML-Emails, Charsets, and Read-/Delivery-Receipts and on diagnosing problems.

CDO Library Constants - Download - New - 2021-07-08
A VBA module containing all the enums and constants from the CDO library.

Gallery PDF for Office imageMso icons - Updated - 2021-06-18
A quick reference sheet to find suitable icons

The 'Better VBA' video series - Updated - 2021-03-21
Better VBA is a video series on YouTube explaining techniques and tools to write better VBA code.
I just published Episode 11 - How to use On Error Resume Next?.

DevOps Server - Diff - Prevent "Cannot execute configured tool."-error - New - 2021-03-01
Two solutions for this error with showing diffs

Video Capture Settings - VB.net Demo with Video for Windows API - New - 2021-02-15
Full source code for a small demo project.