Language: Deutsch English















Last Update: 2017 - 07 - 09





Access DevCon Banner

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

Subscribe to RSS-Feed RSS-Feed

Case Study: SQL Stored Procedure vs. .net Class Library for Complex Data Aggregation - New - 2017-07-09
Improved Testability was my main reason to rewrite an complex stored procedure in VB.net.

Change Access 2010 PivotChart-Form Recordsource with VBA - New - 2017-06-27
How to how to change the RecordSource of an Access 2010 Form in PivotChart-View with VBA.

Send Outlook Emails with Flag and Reminder in VBA - New - 2017-06-10
An explanation of the usability of Outlook Follow-Up-Flags, Reminders and how to create these in VBA-Code for outgoing emails.

Why DropBox, OneDrive and Offline-Folders will destroy your database. - New - 2017-05-09
An extensive explanation why Access databasese in shared folders will suffer from freuqent data loss and corruption.

Access DevCon 2017 - On Video - New - 2017-05-07
Watch some of the world´s best MS Access Experts present advanced Access and VBA topics.

Access DevCon - Developer conference - Vienna, April 2017 - Revised - 2017-05-02
Personal experience report from the Access DevCon Conference in Vienna in April 2017.

Check if an Access Form is open in Dialog Mode - New - 2017-03-23
An Access form can be opened normal or as dialog. How to find out the current state of the form?

The 'Better VBA' video series - Revised - 2017-03-16
Better VBA is a video series on YouTube explaining techniques and tools to write better VBA code.
I just published Episode 9 - Improve code readability with procedures<

Restore SQL Server Express Database from backup - New - 2017-03-09
The 3rd article about backups of Microsoft SQL Express databases explains how to restore your database.

Subscribe to my newsletter

*

I will never share your email with anyone. You can unsubscribe any time.



© 1999 - 2017 by Philipp Stiefel