No Longer Set

Week in Review: March 22, 2025

Highlights include how to search multiple fields from one text box, the release of the Access DevCon Vienna agenda, and an official list of Access bug fixes for 2025.

Email

Putting It All Together: Email Authentication Fundamentals for Access Developers

Transitioning from Outlook automation to SMTP services? Learn the fundamentals of SPF, DKIM, and DMARC to keep your Access application's emails out of spam folders.

Throwback Thursday

Throwback Thursday: March 20, 2025

In today's edition of Throwback Thursday, we explore the role of "feature gates" (aka, "feature flags") in Microsoft Access (and Microsoft Office more broadly).

twinBASIC Weekly Update

twinBASIC Update: March 19, 2025

Highlights include inline variable declaration in For...In and For...Each loops and a statement from Wayne on balancing VB6 back-compatibility and new features.

AUG Video Recap

IMEX DataTask Specifications and Extended File Properties with Colin Riddington

Managing Modern and Legacy Import/Export Specifications in Access (an Access User Group talk with Colin Riddington)

Week in Review

Week in Review: March 15, 2025

Highlights include key info for automating email sending outside of Outlook, integrating AI add-ins with Access, and returning the results of cmd commands.

Email

Why Your Emails Get Blocked: Security Protocols and Deliverability Explained

As spam filtering becomes more aggressive, understanding how SPF, DKIM, and DMARC authenticate your messages is crucial for ensuring they reach their intended recipients.

Throwback Thursday

Throwback Thursday: March 13, 2025

Today's edition of Throwback Thursday is about one of VBA's most underappreciated features: the humble Enum statement.

Email

Beyond the Send Button: How Your Emails Actually Reach Their Destination

Before implementing email APIs, Access developers should understand the fundamentals of how email works.

twinBASIC Weekly Update

twinBASIC Update: March 11, 2025

Highlights include the beta release of the first twinBASIC-compiled version of XYplorer, fixes to long-standing tB IDE regressions, and an important WinDevLib bug fix release.

AUG Video Recap

Troubleshooting Access Applications with Ben Sacherich

Systematic Approaches to Troubleshooting Access Applications: A Developer's Guide (an Access User Group talk with Ben Sacherich)

Week in Review

Week in Review: March 8, 2025

Highlights include Access performance issues in Win 11 v24H, merging PDFs with VBA, optimistic vs. pessimistic locking, and recaps of two popular Gantt Chart videos.

AUG Video Recap

Unraveling Constraints: A Case Study in Complex Scheduling with Steve Schapel and Jack Drawbridge

How to Handle Complex Scheduling When VBA Isn't Enough (an Access User Group talk with Steve Schapel)

Throwback Thursday

Throwback Thursday: March 6, 2025

Today's edition of Throwback Thursday is chock full of tips and tricks to emulate your client's production environment during development.

twinBASIC Weekly Update

twinBASIC Update: March 4, 2025

Highlights include the return of UserControls from the ACTIVE project (missing since BETA 622), an Ambient Light Monitor ported from C++, and more high-priority bug hunting.

AUG Video Recap

Gantt Charts: Part 2 with Aleksander Wojtasz

Building Dynamic Gantt Charts with GDI32: Class Architecture Deep Dive (an Access User Group talk with Aleksander Wojtasz)

AUG Video Recap

Gantt Charts: Part 1 with Aleksander Wojtasz

Build Interactive Gantt Charts in Pure Access without Third-Party Controls (an Access User Group talk with Aleksander Wojtasz)

Week in Review

Week in Review: March 1, 2025

Highlights include using the VBE_Extras addin, VBA connection string builders, an intro to bit logic, button creation and formatting, and a Named Pipes guide for Access devs.

$'np:' and '\pipe\' Explained: A Guide for Access Developers$

SQL Server

'np:' and '\pipe\' Explained: A Guide for Access Developers

Your practical guide to Named Pipes connections, especially common in legacy .ADPs, with step-by-step tips for local development setup.

Throwback Thursday

Throwback Thursday: February 27, 2025

Today's edition of Throwback Thursday is all about 64-bit VBA: updating your 32-bit code to run in 64-bit, 32 vs. 64-bit Office, and tools to help with the conversion.

AUG Video Recap

Data Analysis Tips and Techniques with Luke Chung

Random Sampling, Cross Tab Queries, and Other Power Tools for Access Analysis (an Access User Group talk with Luke Chung)

twinBASIC Weekly Update

twinBASIC Update: February 24, 2025

Highlights include an update to fafalone's twinBASIC ribbon demo sample project and a bug-hunting expedition as twinBASIC nears its v1.0 release date.

Week in Review

Week in Review: February 22, 2025

Highlights include a new release of the Access Version Control Add-in, integrating Google Forms with Access, and using VBA data structures to process JSON.

Throwback Thursday

Throwback Thursday: February 20, 2025

In today's edition of Throwback Thursday, we explore a few of my favorite AutoHotkey scripts for Access development.

AUG Video Recap

Enhanced MsgBox and Forms with Olaf Nöhring and André Minhorst

Enhanced Message Box and Professional Calendar Tools for Access Applications (an Access User Group talk with Olaf Nöhring and André Minhorst)