Quick Tip - No Longer Set

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.

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.

Quick Tip

QuickTip: Reproducible SELECT Results

Reproducing behavior is the essential first step to debugging problems. Save yourself future SQL debugging headaches with this quick tip.

Quick Tip

Clearing the Windows 10 "White Bar of Doom"

A quick fix for the "White Bar of Doom" that occasionally appears on maximized windows in Windows 10. No reboot required!

Quick Tip

HOW TO: Access the Windows Startup Folder

In previous versions of Windows, the Startup folder was easy to find from the Start Menu. This quick tip makes the Startup folder easy to find again.

Quick Tip

QuickTip: Navigation Captions

Even after 17 years of developing in Microsoft Access, I'm still learning about features that have been there the whole time...

Quick Tip

Quick Tip: Preventing Accidental Double-Clicks

Pop quiz, hotshot: What would happen if a user double-clicked every button in your Access application? Would there be any unintended consequences?

Quick Tip

Quick Tip: Code Comment Breadcrumbs

This quick tip is a great way to boost the signal-to-noise ratio of your code without sacrificing valuable context from your decision-making process.

Quick Tip

Quick Tip: 4 Ways to Select the Bottom Control in a Stack

There are many situations that call for two (or more) controls to be stacked on top of each other. In those situations, how does one select the bottom control?

Quick Tip

How to Duplicate a Line of Code in VBA

It's not quite a single shortcut key, but it's nearly as efficient.

Quick Tip

Micro-Efficiency: Duplicating Line(s) of Code in VBA

With this technique, you'll save enough time to steal two and a half extra glances at your watch each day. Use it wisely.

Quick Tip

Adding References from VBA

Did you ever wish you could bypass the Tools > References dialog entirely when adding references in Access? Automate the process with some simple VBA.

Quick Tip

Quick Tip: Set Next Statement with Mouse

Try this tip the next time you use the Edit & Continue feature when debugging. After more than 15 years of developing VBA, I'm still learning new things.

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.

Quick Tip

Preventing Line Break After Debug.Print Statement

Every time you call Debug.Print in VBA it outputs to a new line in the Immediate Window. ... But what if it didn't?!?!

Quick Tip

Quick Tip: Force IntelliSense to Appear When Writing VBA

Does the IntelliSense dropdown ever disappear when you're writing VBA? Do you backspace and re-type the dot to get it back? There's a better way.

Quick Tip

Inserting a Blank Line in the VBA Immediate Window

Did you know you can insert a newline character in the Immediate Window without executing the current line of code?

Quick Tip

Quick Tip: Alt Codes in Windows

Checkmarks, bulleted lists, section symbols, pi, daggers, copyrights, etc. Each of these symbols can be entered in Windows using an easy keyboard shortcut.

Quick Tip

Quick Tip: Emoji Lookup in Windows

Looking for the fastest way to look up and insert emojis in Windows? This shortcut makes it quick and easy.

Code Library

RegOp Quick Tip

Be respectful of your user's registry. Store all your applications' settings in a dedicated publisher subkey.