Mike Wolfe - No Longer Set (Page 54)

Handling Multiple Control Types in a WithEvents Class

Using WithEvents to subclass form controls is a powerful technique. Here's one way to handle multiple control types in a single class.

Advanced

Using WithEvents to Encapsulate Event Handling Code

You don't need to call the event handler for every control to handle its events. Instead, you can use WithEvents to encapsulate that code in a class module.

Conventions

Beautiful Blocks of Boilerplate

Using the colon character to join multiple lines of code all willy-nilly can lead to messy code. But, used judiciously, it can create beauty from chaos.

twinBASIC Weekly Update

twinBASIC Update: May 2, 2021

Highlights include C-style block comments, support for additional Rubberduck annotations, and With blocks for UDTs.

Events

The ArrowKeyNav Routine

Enable Excel-like navigation in your continuous forms by overriding the default behavior of the up and down arrow keys.

Basic

KeyCode and Shift Arguments

The KeyDown and KeyUp events include KeyCode and Shift arguments to identify which keys the user pressed. Let's explore those arguments in more detail.

Basic

Handling Keyboard Events in Access

This beginner article will step you through the process of how to begin writing code that runs when a user presses a key on the keyboard.

Basic

Navigating Continuous Forms

If Up is left and Down is right, you must be navigating a continuous form in Microsoft Access.

Advanced

Raising Custom Events in VBA

This quick tutorial will have you writing custom events in VBA in no time.

Basic

Event-Driven Programming in VBA

Event-driven programming may sound complicated, but the concept is really quite simple.

Basic

The DRY Journey

Don't Repeat Yourself. It's the programmer's mantra. But how do you achieve it in VBA?

Professional Development

Access DevCon 2021: Day 2

If you weren't able to make it to virtual Access DevCon Vienna 2021, here's what you missed on Day 2.

twinBASIC

DevCon 2021

Links and resources from my talk today at Access DevCon Vienna 2021, twinBASIC: The New Kid on the Block.

Professional Development

Access DevCon 2021: Day 1

If you weren't able to make it to virtual Access DevCon Vienna 2021, here's what you missed on Day 1.

twinBASIC

Multithreading in twinBASIC

We may not have the syntax to write multi-threaded code yet, but that can't stop us from creating multiple threads in the twinBASIC Debug Console.

Tools

Enable Live Transcription in MS Teams Meetings

Is the "Start transcription" option missing from your Teams menu? Is the "Join" button missing from your calendar entry? Maybe I can help (but probably not).

twinBASIC

twinBASIC Runtime Requirements

The title's a little misleading. SPOILER ALERT! There are no runtime requirements for twinBASIC.

twinBASIC

Generic Objects in twinBASIC

twinBASIC supports generic objects! Let's dig into the details with a practical example.

twinBASIC

Preview Limitations in twinBASIC

CAUTION! twinBASIC is a work-in-progress. To avoid frustration, learn what's not working *before* you start playing with it.

twinBASIC

twinBASIC's 100% Compatibility Goal

The difference between 100% compatible and 99% compatible is way more than 1%.

Intermediate

Access Web Browser Control

Documentation is scarce for the legacy Access Web Browser Control. And that makes Daniel Pineault's page a goldmine of information.

twinBASIC

New Syntax in twinBASIC: Part 3

There's even more new syntax in twinBASIC, including the IsNot operator, initializing on declare, and augmented assignment operators.

twinBASIC

Docstrings in twinBASIC

twinBASIC takes a page out of the RubberduckVBA book, using code comment "annotations" to generate real-time, IntelliSense-integrated documentation.

twinBASIC

New Syntax in twinBASIC: Part 2

Let's cover some more new syntax in twinBASIC, including parameterized class constructors, method overloading, and return syntax for functions.

twinBASIC

New Syntax in twinBASIC: Part 1

Let's cover some new syntax in twinBASIC, including "AndAlso/OrElse"; the ternary If() operator; and "Continue For" and its cousins.