No Longer Set

VBA to T-SQL via TDD

VBA to T-SQL via TDD: Step 8

Step 8. Alter the scalar function to address failures

VBA to T-SQL via TDD

VBA to T-SQL via TDD: Step 7

Step 7. Execute the test query in SQL Server to verify it fails

VBA to T-SQL via TDD

VBA to T-SQL via TDD: Step 6

Step 6. Build a test query in SQL Server to return failing tests

twinBASIC

twinBASIC Update: September 12, 2021

Highlights include VS Code Extensibility, RGB extraction functions, dropping Finalize(), and a discussion regarding potential typedef support.

VBA to T-SQL via TDD

VBA to T-SQL via TDD: Step 5

Step 5. Create a dummy scalar function in SQL Server

VBA to T-SQL via TDD

VBA to T-SQL via TDD: Step 4

Step 4. Use the results of your Access query to populate the test table

VBA to T-SQL via TDD

VBA to T-SQL via TDD: Step 3

Step 3. Create a temporary test table in SQL Server

VBA to T-SQL via TDD

VBA to T-SQL via TDD: Step 2

Step 2. Build a "test table population query" in Microsoft Access

Hidden Features

Expressions vs. Code: Implicit Type Conversion

In Microsoft Access, is a whole number literal implicitly treated as a Long or an Integer or a Double? As it turns out, it depends on where you ask.

VBA to T-SQL via TDD

VBA to T-SQL via TDD: Step 1

Step 1. Identify or create test data in Microsoft Access

twinBASIC

twinBASIC Update: September 5, 2021

Highlights include IntelliSense in the Debug Console, unit testing improvements, and the addition of #Error and #Warning directives.

SQL Server

Trust But Verify

What Ronald Reagan's Words Can Teach Us About the Sample Code We Find on the Internet

VBA to T-SQL via TDD

How to Convert a VBA Function to a SQL Server Scalar Function

MS Access Developers Can Remove All the Risk From This Complex Process With These 3 Words

Basic

How to Customize the Access Ribbon on a Developer Machine

This step-by-step guide shows you how to customize the Microsoft Access ribbon and add missing commands.

Migration

Mystery of the Ancients

The Ultimate Guide to Recovering Password-Protected, Access 97 Format .MDB Files

Forms

Lazy Loading a Tabbed Form in Microsoft Access

How to use "just-in-time population" to dramatically decrease the load times of complex Access forms.

Hidden Features

How to Check if a User Clicked [Cancel] on an InputBox in VBA

It's possible to distinguish between a user clicking [OK] on an empty box or clicking [Cancel]. You just need to use this simple trick.

twinBASIC

twinBASIC Update: August 29, 2021

Highlights include Unit Testing support, conditional breakpoints, the Nz() function, and various IntelliSense improvements.

Bug Types

"It Runs On My Computer"

Here are the 7 most common reasons I've had to utter those words as an Access developer.

Intermediate

4 Ways to Automate Sending Emails from Microsoft Access

Manually sending a single email from an email client is easy. Automating email sending, by contrast, is deceptively hard.

Under 100

What is a Covering Index?

The concept of "covering indexes" explained in under 100 words. #Under100

Under 100

What is a Database Index?

The concept of database indexes explained in under 100 words. #Under100

Under 100

Much Ado About Little: The #Under100 Series

Brevity is the soul of wit.

Code Library

Quickly List the Properties of an Object in Access

Here's a quick and dirty procedure to iterate through an Access object's Properties collection.

twinBASIC

twinBASIC Update: August 22, 2021

Highlights include a sneak-peek at the forthcoming integrated unit testing framework, App.ThreadID, App.hInstance, and MSVBVM60.dll redirections.