Debugging - No Longer Set (Page 2)

Find the Yellow Highlighted Line When Debugging in VBA

Did you ever lose your place while debugging in VBA? Here's an easy way to find it.

Troubleshooting SQL Server Connection Errors

"SQL Server does not exist or access denied." One error. Dozens of possible causes. Read on for a bunch of practical troubleshooting tips.

Hidden Features

Access Error Number Message Lookup

Did you ever come across an error number in your Access code--maybe in an If or Select Case statement--and wonder what it was for? Wonder no longer.

Debugging

Checking Specific TCP Port Access to a Remote Machine

Troubleshooting network connections is tough. Generic error messages make it hard to identify the root of the problem. This PowerShell cmdlet can help.

SQL Server

Quick Way to Troubleshoot SQL Server ADO Connections

This simple trick provides you with plenty of clues when debugging a failed SQL Server connection on a user's computer.

Debugging

How to Set a Breakpoint in Startup Code in VBA

Ever set a breakpoint in your Access application's startup code, only to have it get cleared before it got hit? There's a simple workaround.

Code Library

Quickly List the Properties of an Object in Access

Here's a quick and dirty procedure to iterate through an Access object's Properties collection.

Basic

Poor Man's Status Bar in VBA

If you're looking for a quick and dirty way to keep track of a long-running process while developing, this VBA one-liner will do the trick.

Tools

3 Ways to Run the Best Low-Level Windows Debugging Tool

A surprising number of thorny Access performance issues can be resolved with this venerable tool. Here's how to get started with Process Monitor.

Tools

Customizing the VBA Debug Toolbar

There are some very handy commands that VBA does not expose by default. Here's a step-by-step guide to customizing the Debug toolbar in VBA.

Hidden Features

Debugging Private Procedures

After more than 14 years as a VBA developer, I recently discovered that you can debug private procedures without temporarily making them public!

Watches

Watch Expression

A deeper than necessary dive into the exact expression evaluation behavior of the basic "Watch Expression" in VBA.

Basic

Watching and Waiting

Careful what you watch for! Monitoring changes to a slow expression can grind your debug session to a halt.

Code Library

How to Set a Breakpoint Inside of an Access Query

Did you ever want to set a breakpoint inside of an executing query? How about inside a form event property? This trick lets you do it.

Debugging

Debugging Automation Errors

Come join me on a journey debugging hard-to-reproduce "Automation error" bugs.

SQL Server

Cloning a SQL Server Database

The fastest, simplest, and cheapest way to clone a SQL Server database for debugging or testing. Even works with SQL Server Express!

AutoHotKey

Debugging VBA with no Break Key

Ever use a keyboard without a Pause/Break key? It's no big deal for most people, but if you develop in VBA it's a huge deal.