Language: Deutsch English


Home

Über mich

MS Access

Access & Email

Access-Client-Server

mySQL & Access

Visual Basic
for Applications

ASP

Random dumps of
dubious wisdom

Downloads

Windows Tipps

Links

Impressum / Kontakt

 Last Update: 2018 - 02 - 27





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 columns in a query
  • 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
  • Logical numerals sorting in Access with VBA
  • Send Outlook Emails with Flag and Reminder in 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
  • The 'Better VBA' video series
  • SQL-Server-Express-Database-Backup - Fundamentals
  • 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
  • VBA-(SQL)-String Tutorial
  • Access DevCon - Developer conference - Vienna, April 2017
  • Access DevCon 2017 - On Video


    • 4 key factors for implementing a queue based database application

    While dates in Access and VBA seem to be simple and straightforward at first sight, there are actually quite a few pitfalls connected to handling dates. I provide comprehensive information and to give you some guidance to avoid common problems when working with dates in Access and VBA.



    Back to the TOC

    Subscribe to my newsletter

    *

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



    © 1999 - 2017 by Philipp Stiefel