No Longer Set (Page 20)

Reader Question: How to Match Names from Multiple Systems

It's a common data cleansing challenge: how do you eliminate duplicate data from multiple systems without accidentally deleting unique data?

Announcement

DevHut.Net Goes Dark

Much like the legendary Keyser Soze, Daniel Pineault's renowned Microsoft Access website--DevHut.net--suddenly disappeared last week.

twinBASIC Weekly Update

twinBASIC Update: June 25, 2023

Highlights include experimental data-binding support, a new Q&A channel in the twinBASIC Discord server, and coming 64-bit support for Kr00l's VBFlexGrid control.

Week in Review

Week in Review: June 24, 2023

Highlights include another installment of a.p.r. pillai's excellent series on streamlining form module code and videos on crosstab queries and temp tables.

Hidden Features

Quick & Dirty Block Comments in VBA

Everybody knows there's no block comment character in VBA, right? Or is there...

Commentary

The Rule of Thrice: Know When to Build Generic Solutions in Code

Once is a fluke. Twice is a coincidence. Thrice is a pattern.

DevCon

Access in an Azure VM

Denver Area Access User Group president, George Young, provides a blueprint for how to move your existing Access applications to the cloud.

Form Design

Accessible Design Resources from Goldman Sachs

Building accessibility into your applications improves the user experience for all users, not just those that are visually impaired.

VBA

Tools > References... Safe List

A list of references that may be safely included with your VBA projects without requiring any extra effort during deployment.

twinBASIC Weekly Update

twinBASIC Update: June 18, 2023

Highlights include bug fixes related to timer events, argument/property handling, and IntelliSense, plus a screenshot of a simple browser written in twinBASIC.

Week in Review

Week in Review: June 17, 2023

Highlights include an article about the future of AI and work, inventory management and string functions in Northwind 2.0, and form templates.

Code Library

MergeLines(): A Handy Function for Building Address Blocks

This handy little function takes care of the tedious chore of creating multi-line strings devoid of blank lines.

Presentations

Form Templates Presentation to the Denver Area Access User Group

A list of resources and further reading for my presentation on Form Templates in Microsoft Access.

Database Design

When Should You Include an Autonumber Column in a Table?

Surrogate vs. Natural Keys. GUIDs vs. Autonumbers. What factors dictate whether to include an autonumber column in your table? When should you do it?

Form Design

Reducing Cognitive Load: The Benefits of Consistent UI Design

Reducing cognitive load through consistent UI design offers numerous benefits for both users and developers.

Code Library

FirstValidPath()

Simplify your VBA code with the versatile FirstValidPath convenience function, which efficiently determines the first valid path from a list of potential matches.

twinBASIC Weekly Update

twinBASIC Update: June 11, 2023

Highlights include a new target release date for version 1, an accompanying roadmap update, and support for Control Arrays.

Week in Review

Week in Review: June 10, 2023

Highlights include a new batch of Access bug fixes, a video with tips for migrating a backend from Access to SQL Server, and a deep dive into the Rubberduck Style Guide.

Announcement

Upcoming Presentation: Form Templates

Join me online on Thursday, June 15, for my presentation, "Form Templates in Microsoft Access," to the Denver Area Access User Group.

Tools

Using Hard Links to Help Mimic a Client Network Environment

Need to mimic data environments for multiple clients? Hate managing the resulting data sprawl? Hard links can help.

Edge Browser Control

Resources for the Modern Edge-Based Browser Control in Microsoft Access

Looking for information or help with the modern Edge-based browser control in Microsoft Access? You've come to the right place.

Debugging

Using PowerShell to Provide TCP Port Details of Running SQL Server Instances

A PowerShell script that returns useful debugging information about the TCP port details of running instances of SQL Server.

Reader Challenge

Logic Puzzle Solution Bonus: SQL Server Edition

Reader Johann Preissl writes in with a pure T-SQL solution to the Five-House Logic Puzzle. No tables or VBA required!

twinBASIC Weekly Update

twinBASIC Update: June 4, 2023

Highlights include a search option to match whole words only, some handy ways to generate GUIDs, and a clever way to deploy and register custom ActiveX controls.

Week in Review

Week in Review: June 3, 2023

Highlights include integrating online licensing via KeyGen, more info on the new browser control, and exploring whether AI will replace programmers.