Language: Deutsch English















Last Update: 2024 - 05 - 21








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
  • VBA - Create ZIP-Archives with VBA and the Shell32 library
  • 7 reasons to use source code control for Microsoft Access development
  • 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.
  • Aliases in SQL – Essential little helpers
  • How to create a calculated field in a Microsoft Access table
  • Case Study: SQL Stored Procedure vs. .net Class Library for Complex Data Aggregation
  • Change Access 2010 PivotChart-Form Recordsource with VBA
  • SQL-Server-Express-Database-Backup - Fundamentals
  • The 'Better VBA' video series
  • How to convert Windows API declarations in VBA for 64-bit
  • Automate SQL Express Database Backups
  • Restore SQL Server Express Database from backup
  • Book Recommendations for Software Developers
  • Check if an Access Form is open in Dialog Mode
  • Signing Access VBA Code in .accdb databases
  • An excursion into raw COM API Programming with VBA
  • Export a filtered Access Report to PDF using VBA
  • 4 key factors for implementing a queue based database application
  • How to convert string pointers to VBA Strings
  • The Date/Time Data Type in VBA and Access
  • Validation Rules and Check Constraints in 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
  • The Microsoft TreeView Control in 64bit Access
  • Access DevCon - Developer conference - Vienna, April 2017
  • 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
  • Date and Time in Multiple Time Zones
  • Update Parent Form with Sub Form References
  • Registry VBA Class Module for Download
  • Outlook Automation – Showing the Outlook Main Window
  • MD5, SHA-1, and SHA-512 Hashes in VBA - Module Download
  • The Mystery of the STARTTLS in the CDO library - Finally Resolved
  • Extracting Connection Info from ADP Projects (Server and Database Name)
  • Warnings and Trust – Trust Center Settings in Microsoft Office
  • Generating PDF/A Compliant PDF Files with Microsoft Access



  • 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