Language: Deutsch English

Last Update: 2021 - 12- 18

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.

(Philipp Stiefel)

The most recent updates on this website...

Subscribe to RSS-Feed 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 - Demo with Video for Windows API - New - 2021-02-15
Full source code for a small demo project.

Subscribe to my newsletter


I will never share your email with anyone. You can unsubscribe any time.
This email list is hosted at Mailchimp in the United States. See our privacy policy for further details.

© 1999 - 2021 by Philipp Stiefel - Privacy Policiy