Mike Wolfe - No Longer Set (Page 37)

Why Does My Access Web Browser Control Default to IE 7?

If web pages don't look right on your Access web browser control, it might be due to a little-known registry setting.

HOW TO: Create a Tool Window in the VBIDE with twinBASIC

Move over Rubberduck VBA and MZ-Tools. The next great VBE addin is going to be built with twinBASIC. Here are step-by-step instructions to get you started.

COM

Loading VBE Addins - A Windows Registry Tour

Let's pull back the curtain and see how VBA loads VBE COM add-ins via a series of registry calls.

twinBASIC Weekly Update

twinBASIC Update: April 24, 2022

Highlights include updated samples for building custom VBIDE tool windows and custom ActiveX controls that you can drop on Access forms and reports.

twinBASIC

HOW TO: Create a Custom ActiveX Control with twinBASIC

Did you ever wish you could build a custom control for Microsoft Access forms and reports? With twinBASIC, that's a 15-minute project.

Topics Page Redesign

Check out the redesigned Topics page at nolongerset.com! It's now auto-updating and optimized for discovering new content.

Migration

Convert Common Access Field Defaults to SQL Server

Here's the Select Case statement I use to convert common Access field default calculations--Now(), Date(), etc.--to their SQL Server equivalents.

VBA

Static Functions and Subs

After fifteen years of writing VBA, I'm still learning new features of the language. Even if they're not particularly useful features...

Code Library

Printf Function

User @wqweto's string interpolation VBA function has some neat tricks, like using Unicode's Private Use Area to get safe temporary placeholder characters.

Quick Tip

Shortcut Key to Comment/Uncomment Blocks of Code in VBA

You don't need 3rd-party tools to add keyboard shortcuts for commenting and uncommenting code blocks in VBA with this trick.

Holiday

Happy Easter

"Why do you look for the living among the dead? He is not here; he has risen!"

twinBASIC Weekly Update

twinBASIC Update: April 16, 2022

Highlights include multiple debug console performance improvements and a workaround for antivirus software flagging twinBASIC as potential malware.

SQL

T-SQL ISNULL() vs. VBA IsNull() vs. Jet IS NULL vs. Access VBA Nz()

How do I check thee for NULL? Let me count the ways.

Code Library

Displaying Very Long Human Readable Time Spans

With 29-million-year time spans, you can handle almost any task (besides evolution, continental drift, and adding the LAA flag to MS Access).

Code Library

Displaying Human Readable Time Spans

The HumanizedSeconds() and ConvertToSeconds() functions work hand-in-hand to provide a general solution for storage and display of time spans.

UX

4 Approaches to Storing and Displaying Time Spans in Microsoft Access

As an Access developer, how do you store and display time spans like "3 days" or "2 weeks"? Let's cover the pros and cons of four different approaches.

Hidden Features

How to Show Hidden Items in the VBA Object Browser

One possible fix for the "Cannot jump to '|' because it is hidden" error is to show hidden members in the VBA object browser.

twinBASIC Weekly Update

twinBASIC Update: April 10, 2022

Highlights include 7 (!) new releases of the twinBASIC IDE and twinBASIC solving a difficult problem for a popular MS Access open-source addin.

Advanced

References, Protocols, and Language Specifications

They're not always easy to read, but when you are looking for official answers, it's hard to beat these low-level protocol and language specifications.

Basic

Learn VBA From a Master

Philipp Stiefel is on a very short list of people who I would pay to teach my employees how to write VBA.

Debugging

Troubleshooting the "Unable to create target directory" Error in PDQ Deploy with ProcMon

Let's use my jack-of-all-trades troubleshooting tool--Process Monitor--to find the root cause of a recurring PDQ Deploy error.

SQL Server

Save $3,500 by Creating Scheduled Backups Using SQL Server Express

You don't need to spend big bucks to get automated database backups with SQL Server. This simple step-by-step process is nearly foolproof.

Class Modules

Great Intro to Class Programming in VBA

Former Access MVP Ben Clothier's primer on class programming in VBA should be required reading for all Access developers.

Announcement

twinBASIC DevCon Vienna: Volume 2

It's back! This year's Access DevCon Vienna will feature twinBASIC for the second year in a row. This time around the focus is on practical uses for Access developers.

twinBASIC Weekly Update

twinBASIC Update: April 3, 2022

Highlights include the release of the new IDE and an announcement about twinBASIC's role at the upcoming Access DevCon Vienna conference.