Mike Wolfe - No Longer Set (Page 49)

How to Remove the Time Portion From a Date Variable in VBA

In this article, I run a series of experiments to explore how different time-stripping approaches work in VBA.

A Function to Quote Literal Dates When Building SQL in VBA

This improved version of my date-quoting convenience function eliminates a common source of date-handling ambiguity via the ISO date format.

twinBASIC Weekly Update

twinBASIC Update: December 12, 2021

Highlights include the File I/O system reaching feature-complete status, an updated twinBASIC roadmap, and experimental text encoding support.

Code Library

A Safer Alternative to BETWEEN When Filtering Dates

This convenient function generates defensive SQL statements to help you avoid the subtle dangers of the BETWEEN statement when filtering dates.

SQL Server

3 Gotchas of the SQL BETWEEN Statement

The SQL BETWEEN statement produces very readable condition expressions. But developers of all skill levels can still get into trouble with it.

Tools

Advanced Data Generator 4: First Look

Looking to generate lots of test data in your backend Access databases? Advanced Data Generator 4 may be exactly what you are looking for.

Advanced

Using Windows Authentication to Connect to SQL Server from Outside the Domain

You don't need to join your computer to a domain to be able to connect to SQL Server using Windows Authentication. You just need to know this simple trick.

Code Library

Preventing File-Writing Race Conditions in VBA

If you're waiting on an external process to write a file to disk, how can you be sure it's really done? This routine helps avoid (or at least rule out) some race conditions in VBA.

Advanced

Side-by-Side Installs of 32-bit and 64-bit Versions of Access

You can't install two different Office bitnesses side by side on the same computer. Or can you? ...

twinBASIC Weekly Update

twinBASIC Update: December 5, 2021

Highlights include the implementation of additional File System features, improved performance for Split and Replace, and a discussion about universal binaries.

Debugging

How to Set a Breakpoint in Startup Code in VBA

Ever set a breakpoint in your Access application's startup code, only to have it get cleared before it got hit? There's a simple workaround.

COM

Microsoft Office COM Automation Libraries

The VBA developer's guide to automating Microsoft Office applications: early vs late binding; CreateObject vs GetObject; and tips on cleaning up after yourself.

Hidden Features

Hidden Feature: Drag and Drop Access Objects Between Files

Skip the "Import Access Objects" dialog screens and use your mouse to move Tables, Queries, Forms, Reports, and code modules between Access files.

Announcement

Access Dataverse Connector Presentations

A list of past and upcoming presentations on the Access Dataverse connector with Access Program Manager Michael Aldridge.

Commentary

The State of Access Today

What's the state of Microsoft Access in 2021: thriving, alive, dying, or dead? If you only know Access by reputation, the answer may surprise you.

Commentary

The Key to Navigating Unfamiliar Territory Without a Map

How I successfully led a 60-vehicle military convoy at 23 years old without knowing what I was doing or where I was going.

twinBASIC Weekly Update

twinBASIC Update: November 28, 2021

Highlights include the first major release of file handling statements and functions in twinBASIC, along with talk of providing a tB license to the Rubberduck project.

COM

Early Binding vs. Late Binding: The Essential Guide for VBA Developers

The Absolute Minimum Every VBA Developer Absolutely, Positively Must Know About Early and Late Binding in COM (No Excuses!)

Risk Management

Cowpathing with Microsoft Access

How do you decide where to spend your software development dollars? Don't guess what your users need, let them show you with Access.

Database Design

When to Store Numbers as Text

Introducing the "Numeroliteral Test," a one-question heuristic for deciding whether to store numeric data in a character-based field.

Commentary

3 Benefits of Writing Code Backwards

Ignore those compile errors and start writing your calling code before your routines. This approach has many benefits.

Commentary

Access Dataverse Connector

Did you ever think to yourself, "I wish there was a way to make my back-end data less flexible *and* less powerful?" Good news; your wait is over!

Advanced

64-bit Unsigned Integers in VBA

VBA is missing a data type. The workaround--while not pretty--is at least straightforward.

twinBASIC Weekly Update

twinBASIC Update: November 21, 2021

Highlights include 64-bit compilation support (no license required!) and a discussion about early binding and reference handling.

COM

High Level Overview of COM

This whirlwind tour of the Component Object Model technology will jump start your journey of automating Excel from VBA in Access.