Tools RegEx101.com Writing and reading regular expressions is like speaking a foreign language. Think of regex101.com like Google Translate for regexes.
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.
Tools Commento vs. Cove Comments Commento and Cove are both third-party comment hosting platforms. Which one works best with Ghost CMS?
Tools AccessUI - Data Source Manager Tired of dealing with the limitations and poor UI of Access's built-in linked table manager? Try this FREE improved version from Kevin Bell.
Tools Enable Live Transcription in MS Teams Meetings Is the "Start transcription" option missing from your Teams menu? Is the "Join" button missing from your calendar entry? Maybe I can help (but probably not).
Tools KnowledgeBase Mausoleum Looking for that long-lost KnowledgeBase article from 2003 but only finding a 404 error? This website brings dead KB articles back to life.
Tools Rainbow CSV If you work with delimited text files of any kind, you need to be using this VS Code extension.
Tools Hiding Shortcuts in Everything Here's a quick tip from Tom Wickerath for hiding shortcut files from your Everything file search results.
Tools vbWatchdog Webinar Peter Cole of ThemeMyDatabase.co.uk presents a demonstration of vbWatchdog in action. Come for the info, stay for the discount code.
Tools Bad Words in Access Note, Caption, Format, Pages, Sequence. All reasonable-sounding field names, but all should be avoided.
Tools Installing and Updating Access Applications Want to be a professional Access developer? Then you can't ask your clients to copy and paste .accdb files to their computers. What do you do instead?
Tools 21st Century Visual Basic Microsoft stopped supporting VB6 in 2008. Here are some modern options for migrating those old apps or developing new ones in 2020 and beyond.
Intermediate VBA Code Generation Trick Using Notepad++ to transform existing code into a VBA string that generates itself.
Advanced JetShowPlan: A Primer You may be familiar with JetShowPlan, but I guarantee you've never read an article about it quite like this one.
SQL Server Tuning Access Query Performance The four best tools/techniques for tuning Access query performance: JetShowPlan, Process Monitor, TraceSQLMode, and SQL Profiler.
SQL Server All Hail Ola! If you're managing SQL Server and you're not using Ola Hallengren's scripts, then you're doing it wrong.
Tools My Favorite Things Here is a list of my favorite utilities, add-ins, OCX controls, and applications that I use when developing Microsoft Access applications.