Language: Deutsch English

Last Update: 2024 - 05 - 21

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

An excursion into raw COM API Programming with VBA - Updated - 2024-05-20
Using the ITaskbarList COM Interface with VBA and the Win32-API. - Now fully 64bit compatible!

Export a filtered Access Report to PDF using VBA - Updated - 2024-05-19
Added an alternative solution optimized for performance.

Color Gradient as Form Background - Donwload - 64bit Compatible - New - 2024-04-21
An old Windows API sample by Stephen Lebans converted to VBA7.

Warnings and Trust – Trust Center Settings in Microsoft Office - New - 2024-03-15
All the filthy details.

MD5, SHA-1, and SHA-512 Hashes in VBA - Module Download - Updated - 2024-02-17
Update: Simplified extensibility and added SHA-512 support.

Extracting Connection Info from ADP Projects (Server and Database Name) - New - 2024-02-15
Reverse engineered with love.

The Mystery of the STARTTLS in the CDO library - Finally Resolved - New - 2024-01-12
Or: SmtpUseSsl Explained.

Sending emails with VBA and the CDO Library - Updated - 2024-01-11
The text was generally revised and extended, and the *definitive* information on STARTTLS encryption was added.

Outlook Automation – Showing the Outlook Main Window - New - 2023-06-01
Explanations and sample code.

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.

Benefits of the newsletter subscription

© 1999 - 2024 by Philipp Stiefel - Privacy Policiy