Mike Wolfe - No Longer Set (Page 19)

Evolution of a Function: ShowForm()

Code is a living thing. Letting it grow organically over time helps ensure that you get exactly the features you need. My ShowForm() function is a prime example.

UX

Countering Automation Bias

Those handy default values you provide your users could be doing more harm than good.

twinBASIC Weekly Update

twinBASIC Update: July 9, 2023

Highlights include a supercharged Collection class (that also replaces Scripting.Dictionary for most use cases) and several exciting community projects.

Week in Review

Week in Review: July 8, 2023

Highlights include the next installment of a.p.r. pillai's class-based form code series, AI regulations, and understanding project requirements.

Code Library

4 Keys to Building Generic Solutions in Code

Building and maintaining a library of custom code procedures is an investment that provides compounding benefits over time.

Debugging

Written Rubberducking: A Practical Example

A practical example of the written rubberducking technique taken straight from our FogBugz issue tracking software.

Debugging

Written Rubberducking: My Debugging Superpower

While rubber ducks make good code buddies, they make even better pen pals.

Commentary

Priorities and Time Management for Microsoft Access Consultants

Whether you realize it or not, every decision you make about how to manage your time is a result of what you prioritize.

Form Design

Avoid Double Negatives for a Better User Experience

Double negatives are highly effective--if your goal is to introduce confusion--as my Beast Barracks story shows. They have no place in a user interface, though.

twinBASIC Weekly Update

twinBASIC Update: July 2, 2023

Highlights include support for vbaObjAddRef, improvements to the Problems pane, and twinBASIC moving up the BASIC-like language rankings.

Week in Review

Week in Review: July 1, 2023

Highlights include an AI-focused episode of the quarterly Access News webcast, the release of Rubberduck 2.5.9, and tips on importing web data into Access.

Conventions

PascalCase All the Things

There is only one correct capitalization convention in VBA: PascalCase.

Under 100

What is cyclomatic complexity?

The concept of cyclomatic complexity explained in under 100 words. #Under100

Debugging

SSE Setup: Fix for Error -2147024671

This is a great example of how we can break down seemingly random Windows error codes to guide our debugging efforts.

Database Design

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.