Quick Tip - No Longer Set

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.