Quick Tip - No Longer Set

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.