No Longer Set (Page 54)

VBA to T-SQL via TDD: Step 6

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

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 Weekly Update

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 Weekly Update

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 Weekly Update

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.

Bug Types

Misunderstood Requirements (After You've Written the Code)

As you install the final piece of crown molding in the dog's second bedroom, you can't help but smile at the absurdity of it all.

Bug Types

Runtime Errors

It's impossible to predict every possible scenario that could befall our applications in the wild. But we need to at least try.