No Longer Set (Page 51)

The internet's top source for all things Access and VBA.

"This feels weird."

Professional Development

"This feels weird."

My nine-year-old son got hit in the head at soccer practice the other day. His reaction reminds me of my own professional software development journey.

twinBASIC Update: September 19, 2021

twinBASIC Weekly Update

twinBASIC Update: September 19, 2021

Highlights include discussions around block scoping and a planned ObjRefCount() function.

Linking to SQL Server Date Fields from Microsoft Access

Linking to SQL Server Date Fields from Microsoft Access

I always avoided SQL Server's DATE type in favor of the DATETIME type's better compatibility with MS Access. A newer ODBC driver has me changing my mind.

VBA to T-SQL via TDD: Step 10

VBA to T-SQL via TDD

VBA to T-SQL via TDD: Step 10

Step 10. Repeat steps 8 & 9 until all tests pass

VBA to T-SQL via TDD: Step 9

VBA to T-SQL via TDD

VBA to T-SQL via TDD: Step 9

Step 9. Execute the test query in SQL Server

VBA to T-SQL via TDD: Step 8

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: Step 7

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: Step 6

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 Update: September 12, 2021

twinBASIC Weekly Update

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: Step 5

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: Step 4

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: Step 3

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: Step 2

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

Expressions vs. Code: Implicit Type Conversion

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: Step 1

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 Update: September 5, 2021

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.

Trust But Verify

Trust But Verify

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

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

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

How to Customize the Access Ribbon on a Developer Machine

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.

Mystery of the Ancients

Mystery of the Ancients

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

Lazy Loading a Tabbed Form in Microsoft Access

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.

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

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 Update: August 29, 2021

twinBASIC Weekly Update

twinBASIC Update: August 29, 2021

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

"It Runs On My Computer"

"It Runs On My Computer"

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

4 Ways to Automate Sending Emails from Microsoft Access

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.

All original code samples by Mike Wolfe are licensed under CC BY 4.0