Mike Wolfe - No Longer Set (Page 50)

Combo Boxes: Use Responsibly

Comic book legend Stan Lee captured the essence of the Microsoft Access combo box control in six words, "With great power, comes great responsibility."

Combo Boxes

Combo Boxes and Target Sizes

Just like in darts, it's easier to hit a larger target when using the mouse. With this in mind, let's make our combo boxes more user-friendly.

twinBASIC Weekly Update

twinBASIC Update: June 6, 2021

Highlights include Mid statement support, DefType support, multiple bug fixes, and a (sort of) announcement regarding unit testing support.

Basic

Combo Box: Behavior Deep Dive

Join me as I take you on an animated gif guided tour of the default behavior of the Microsoft Access combo box, with emphasis on the autocomplete feature.

Announcement

Combo Boxapalooza!

Join me at 9 AM EDT on Friday, June 18th, where I'll help you unlock the true potential of my favorite Access control: the combo box.

Intermediate

Come Here Often?

When designing a user experience (UX), the single most important question to ask yourself is this: How often will this feature be used?

Basic

Field Comments on Linked Tables

In this 6-part series, I cover everything you need to know about field descriptions for linked tables with Access and SQL Server back-end databases.

SQL Server

Pushing Field Comments to SQL Server

A VBA routine that takes field comments from a front-end linked table and pushes them to the corresponding back-end table in SQL Server.

Bug Alert

Bug Alert: vbWatchdog

How to fix the E_VBWATCHDOG_UNSUPPORTED_VBAVERSION error.

twinBASIC Weekly Update

twinBASIC Update: May 30, 2021

Highlights include improved compiler stability, making the Optional keyword optional, and setting command-line arguments for debugging.

Basic

Easy Access to Field Descriptions

The ExtractFieldComments() function returns a dictionary of field names and their descriptions from a TableDef object.

SQL Server

Setting Field Descriptions on Linked SQL Server Tables

What good are field descriptions in SQL Server if you don't see them in your Access front-end? Here's some code to bring those comments forward into Access.

SQL Server

UPSERT a Column Description in SQL Server

Let's combine the stored procedures to Update and Insert SQL Server field comments into a single, all-encompassing solution.

SQL Server

Setting SQL Server Field Descriptions

There are two basic ways to set field descriptions in SQL Server: via SSMS and T-SQL. Let's explore both.

Basic

Field Comments on Linked Access Tables

In part 1 of this series on field comments, we discuss maintaining column descriptions on tables linked to MS Access back-end files.

twinBASIC

twinBASIC: Setting Cmd Line Args in Debug Mode

The VB6 Command$() function returns command line arguments in twinBASIC. But, for now, we still need a workaround to set cmd line args while debugging.

twinBASIC Weekly Update

twinBASIC Update: May 23, 2021

Highlights include passing (pseudo-)command-line arguments to a twinBASIC console app and an update from Wayne on the project's progress.

twinBASIC

Pseudo-Command Line Args in twinBASIC

I couldn't figure out how to pass command line arguments to a twinBASIC console application. So I improvised a solution.

Tools

AccessUI - Data Source Manager

Tired of dealing with the limitations and poor UI of Access's built-in linked table manager? Try this FREE improved version from Kevin Bell.

Events

The ArrowKeyNav Journey

A full breakdown of my weArrowKeyNav class module that uses WithEvents to override the default up and down arrow key behavior in continuous Access forms.

Advanced

Approximate String Matching Workshop

Access wizard Alessandro Grimaldi is offering a paid workshop where he will teach how to implement the Levenshtein Distance algorithm in Access.

Code Library

weArrowKeyNav Class

Do you want the up and down arrow keys to move to the previous and next records in a continuous Access form? Here's how to do that with only two lines of code.

Code Library

Get Top Form By Control

How do you return the top form for an arbitrary control instead of the first subform that comes your way?

twinBASIC Weekly Update

twinBASIC Update: May 16, 2021

Highlights include stability improvements for the twinBASIC compiler and the YouTube release of my hourlong twinBASIC presentation at DevCon Vienna.

Code Library

Microsoft Access: Check if Form Object is a Subform

How do you check if the form object is a subform in Access without triggering a runtime error? Hint: this is a trick question.