Language: Deutsch English















Last Update: 2017 - 03 - 20





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

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.

MS Office Automation - VBA-Modules with constants - Revised - 2017-02-28
VBA-Modules with all Enums/Constants from the Microsoft Office Object Libraries.
Finally added: The Microsoft Excel Object Library

How to create a calculated field in a Microsoft Access table - New - 2017-02-21
An in depth discussing of calculated fields in Access tables and when to use them. This includes an step-by-step sample for creating a calculated field to display the quarter of a date in a table.

Automate SQL Express Database Backups - New - 2017-02-09
How to automate database backups on Microsoft SQL Server Express Edition.

Subscribe to my newsletter

*

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



© 1999 - 2017 by Philipp Stiefel