Language: Deutsch English















Last Update: 2022 - 04 - 15








Random dumps of dubious wisdom

Table of Contents

  • Source Code Control Systems and Microsoft Access
  • Access/VBA - How to output data from a column as comma separated string
  • Access/VBA - How to create HTML-emails with Microsoft Access and Outlook automation
  • Access/VBA - How to output data from an ADO-Recordset-Column as comma separated string using local sorting and filtering
  • 3 tools I would not want to work without in Microsoft Access
  • VBA - Handling events from an indefinite number of event sources
  • Access/VBA - Event handling Tutorial (Part 1) - First steps for beginners
  • Sending emails with VBA and the CDO Library
  • Compiling an Access AccDE with VB-Script
  • Access SQL - Select Top X records - With no ties
  • Access - How to use transactions in VBA
  • Access - Create email with a mailto-Hyperlink
  • 7 reasons to use source code control for Microsoft Access development
  • VBA - Create ZIP-Archives with VBA and the Shell32 library
  • Performance differences counting records in an Access Database
  • How to choose a source code control system for Access development
  • The Hyperlink data type in Microsoft Access
  • Access - Calculated Fields in Queries
  • Send serial email with Microsoft Access, VBA and Outlook
  • Introduction to Classes and Objects in VBA
  • Access - Let external users review and edit data
  • Sort and index binary data in an Access database
  • Send Outlook Emails with Flag and Reminder in VBA
  • Logical numerals sorting in Access with VBA
  • Why DropBox, OneDrive and Offline-Folders will destroy your database.
  • How to create a calculated field in a Microsoft Access table
  • Aliases in SQL – Essential little helpers
  • Case Study: SQL Stored Procedure vs. .net Class Library for Complex Data Aggregation
  • SQL-Server-Express-Database-Backup - Fundamentals
  • The 'Better VBA' video series
  • Change Access 2010 PivotChart-Form Recordsource with VBA
  • Automate SQL Express Database Backups
  • How to convert Windows API declarations in VBA for 64-bit
  • Book Recommendations for Software Developers
  • Restore SQL Server Express Database from backup
  • Check if an Access Form is open in Dialog Mode
  • An excursion into raw COM API Programming with VBA
  • Signing Access VBA Code in .accdb databases
  • Export a filtered Access Report to PDF using VBA
  • How to convert string pointers to VBA Strings
  • 4 key factors for implementing a queue based database application
  • Validation Rules and Check Constraints in Access
  • The Date/Time Data Type in VBA and Access
  • VBA Navigation History Add-In
  • News on Access 2019 and Office 2019
  • Windows 10 – Synaptics Touchpad – Solution for Click not working
  • Why software developers should embrace the GDPR and a helpful guide to doing so
  • 3 Access and VBA Book Recommendations
  • The Access ADP Story
  • VBA-(SQL)-String Tutorial
  • DFirst/DLast and the Myth of the Sorted Result Set
  • Choosing an Authentication Mechanism for Access + SQL-Server-Applications
  • The ParamArray Keyword in VBA / How to emulate the SQL Coalesce Function
  • A String.Format / printf implementation in VBA
  • Gallery PDF for Office imageMso icons
  • Microsoft Access developer conferences around the world.
  • Software Quality + Unit Tests in Access-VBA
  • Access/VBA - Formatting dates for a specific Locale
  • VBA-Bug introduced with the latest (2019-08) Windows Update
  • VBA Class Module to access the clipboard
  • Field report from Netherlands Access Developers Day 2019
  • "Query is corrupt"-error after Microsoft Access November 2019 Update
  • Access DevCon - Developer conference - Vienna, April 2017
  • The Microsoft TreeView Control in 64bit Access
  • Access DevCon 2017 - On Video
  • How to Create and Install a SSL/TLS Certificate for SQL Server
  • Sort a Form Bound to an ADO.Recordset using Access UI Features
  • Access Bug - Assigning a Recordsource at runtime disables ODBC Multi-Row-Fetch for continuous form
  • The /LARGEADDRESSAWARE (LAA) flag demystified - Remedy for out-of-memory errors
  • Recursion in VBA – Example: Listing the Outlook Folder Hierarchy
  • Resize an Access DataSheet Form to Fit all Columns
  • Recap of Access news in 2020 and a Peek at 2021
  • Query Performance Tuning
  • ODBC Linked Tables in Access - Mechanisms and Peformance
  • Video Capture Settings - VB.net Demo with Video for Windows API
  • DevOps Server - Diff - Prevent "Cannot execute configured tool."-error
  • Creating WIX File Elements from a Visual Studio Project File Using PowerShell
  • Using an External Num-Pad for OBS Studio Hotkeys
  • What is the /decompile switch for Microsoft Access?
  • Microsoft Access - Error 3048 - Cannot open any more databases
  • Codekabinett VBA Online Courses
  • 5 Reasons To Learn VBA Programming in 2022
  • New Bug in Access 365 V2205 - #Deleted in ODBC tables with NVarchar PK



  • 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 - 2022 by Philipp Stiefel - Privacy Policiy