Mike Wolfe - No Longer Set (Page 29)

Why Use Subs at All?

Almost every Sub could be a Function...but that doesn't mean it's a good idea.

Subs vs. Functions in VBA

What is the difference between a Sub and a Function and why would you use one or the other? I'll give you the short answer...and then we can explore the long answer.

Intermediate

Open the Windows Color Dialog from VBA

If you need to get Access color values from your users, this is the easiest way to do it.

twinBASIC Weekly Update

twinBASIC Update: February 5, 2023

Highlights include a major rewrite of the ActiveX implementation, updates to two community projects, and a discussion about the business side of twinBASIC.

Week in Review

Week in Review: February 4, 2023

Highlights include a tool to localize Access applications (coming soon) and a couple of good (if slightly off-topic) articles on management and pricing.

VBA

Enums in VBA: A Great 10-Minute Introductory Video

Excel MVP Paul Kelly packs a bunch of great information (including a well-hidden feature) into this ten-minute video introducing Enums in VBA.

VBA

Idempotence vs. Determinism

Idempotent functions can safely be run multiple times. Deterministic functions always return the same output given the same inputs. Let's explore further.

Defensive Programming

3 Techniques for Programming Reversible Processes

How would you recover from a large accidental UPDATE operation? You'd better be able to answer that question *before* it happens.

Intermediate

5 Types of Settings for Microsoft Access Applications

How you store settings in Microsoft Access depends on their scope. Understanding the scope of your settings is critical to ensure you store them the right way.

Quick Tip

Quick Tip: 4 Ways to Select the Bottom Control in a Stack

There are many situations that call for two (or more) controls to be stacked on top of each other. In those situations, how does one select the bottom control?

twinBASIC Weekly Update

twinBASIC Update: January 29, 2023

Highlights include an updated roadmap and v1 release date, new UserControl events support, and several new tB sample projects from fafalone and Ben Clothier.

Week in Review

Weeks in Review: January 28, 2023

I'm back! Highlights from the past two weeks include using web APIs in Access, Rubberduck 3.0 news, using the registry from VBA, and more on ChatGPT.

Archive

Archive Collection: Humor

I'm on vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: Humor.

Archive

Archive Collection: Form Design

I'm on vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: Form Design.

Archive

Archive Collection: Defensive Programming

I'm on vacation! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: Defensive Programming.

Archive

Archive Collection: Tools

I'm on vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: Tools.

Archive

Archive Collection: Test-Driven Development

I'm on vacation! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: Test-Driven Development (TDD).

Archive

Archive Collection: twinBASIC

I'm on vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: twinBASIC.

Archive

Archive Collection: Bug Types

I'm on vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: Bug Types.

Archive

Archive Collection: Hidden Features

I'm on vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: Hidden Features.