Mike Wolfe - No Longer Set (Page 7)

Week in Review: May 4, 2024

Highlights include the public release of two DevCon Vienna presentations, sending emails via REST API, and how to zip and unzip files in VBA.

SQL Server

How to Use the ADO NextRecordset Method

The ADO .NextRecordset method allows you to handle multiple result sets from a single SQL Server stored procedure.

Commentary

Premature Declaration Redux

Let's revisit the argument about whether to declare variables at the top of a procedure or closest to first use. We'll ask ChatGPT to make the best case for each position.

Quick Tip

Quick Tip: Instant Find in the VBA IDE

Somehow I went more than 20 years writing code in VBA without knowing about this handy shortcut key.

Presentations

DevCon Vienna 2024 Public Session Recordings

Check out the recordings of my twinBASIC Update and Colin Riddington's Advanced Form Designs from Access DevCon Vienna 2024.

twinBASIC Weekly Update

twinBASIC Update: April 29, 2024

Highlights include my DevCon Vienna twinBASIC recording, massive memory reduction in the IDE, and exciting news regarding the VB6 PhotoDemon project.

Week in Review

Week in Review: April 27, 2024

Highlights include an Access roadmap update (!), compiling to .accde from VBA, managing SQL Server migrations, and SQL Express backups and restores.

Deployment

HOW TO: Compile to .accde or .mde From the Command Line

"The Joel Test" requires that you can "make a build in one step." With these instructions, you can create an .accde from an .accdb without even opening Access.

Code Library

CompileCurrentAccessApp(): Use VBA to Create an ACCDE or MDE of the Currently Open Access File

This function allows you to create an .accde or .mde file based on your current Access file with a single press of the F5 key.

Version Control

Version Control and Cloud Drives: Better Keep 'em Separated

Git and Mercurial repositories don't mix well with cloud drives like OneDrive and Dropbox. Here are two alternative approaches to keep you out of trouble.

Commentary

Thomas Jefferson's Accidental Programming Advice

Premature declaration is nothing to be embarrassed about. It can happen to anyone. You don't want to make a habit of it, though.

Bug Alert

Bug Fix: RefreshLink

A fix for an error that impacted some users with linked SQL Server tables was announced in Microsoft's latest monthly bug fix roundup.

twinBASIC Weekly Update

twinBASIC Update: April 21, 2024

Highlights include word wrap toggling, twinBASIC returns to Vienna, a WinDevLib quick start guide, and a major milestone as twinBASIC now runs PhotoDemon!

Week in Review

Week in Review: April 20, 2024

Highlights include the monthly bug fix post from Microsoft, a rant against typed Arrays, polymorphism in VBA, extracting OLE images, and another modern browser bug.

Presentations

DevCon 2024: Version Control with Access

A list of resources and further reading for my 2024 DevCon Vienna mini-presentation on version control with Microsoft Access.

Presentations

DevCon 2024: VBIDE Addin Creation with twinBASIC

Links and resources from my talk today at Access DevCon Vienna 2024, Custom VBIDE Addin Creation with twinBASIC.

Commentary

How to Tell the Technical Abilities of a User Without Asking

How do you assess the technical abilities of someone who might not even know how to accurately assess themselves? By making the garden weed itself.

twinBASIC

WinDevLib: A Better Way to Call Windows API Functions in twinBASIC

Stop struggling to declare your Windows API calls in twinBASIC. Use the Windows Development Library twinPACK and let fafalone do all the hard work for you.

Bug Alert

Bug Alert: InStr() in WHERE Crashes Access

Using string expressions like InStr(), InStrRev(), and Replace() in the WHERE clause of a query can crash Access in certain recent releases.

twinBASIC Weekly Update

twinBASIC Update: April 14, 2024

Highlights include improved performance and stability, error codes for compile errors, a sneak peek at sokinkeso's External Tools plugin, and version control for twinBASIC.

Week in Review

Week in Review: April 13, 2024

Highlights include videos on the MS Access Version Control add-in, Google Maps driving directions to multiple sites, and SQL Server audit tables.

COM

How VBA IDE Addins Get Loaded From the Windows Registry

A deep dive into how VBA IDE addins get loaded from the Windows Registry to help you avoid getting stuck in DLL hell.

VBA

The Windows Registry: A Deep Dive for VBA Developers

Everything you need to know to get started reading and writing to the Windows Registry from VBA without breaking into a cold sweat.

twinBASIC

Version Control with twinBASIC in 2024

Step-by-step instructions for integrating version control into your twinBASIC development operations in 2024.

Quick Tip

Quick Tip: Connect Multiple Outlook Accounts to Zapier

Automatic login is convenient most of the time, but it can be frustrating when trying to configure multiple accounts for Zapier application integrations.