No Longer Set (Page 51)

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

Floating Point Arithmetic in VBA vs. SQL Server

Floating Point Arithmetic in VBA vs. SQL Server

VBA and SQL Server do not perform floating-point operations the same way. Being aware of this difference could save you hours of frustration someday.

The Software Reliability Paradox

The Software Reliability Paradox

The most reliable software holds the potential to cause the greatest harm. Examples abound, from my own $86K mistake to a devastating Russian hack.

Database Date Field Naming Convention

Database Date Field Naming Convention

Naming is hard. When it comes to naming conventions, the key is to keep things simple. Here's how I like to name the date and time fields in my databases.

"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.

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