Topics

  • ["Access 101" tag page]: Show all articles with the tag "Access 101" (including those where "Access 101" is a secondary tag).
  • ["Advanced" tag page]: Show all articles with the tag "Advanced" (including those where "Advanced" is a secondary tag).
  • ["AI" tag page]: Show all articles with the tag "AI" (including those where "AI" is a secondary tag).
  • ["Announcement" tag page]: Show all articles with the tag "Announcement" (including those where "Announcement" is a secondary tag).
  • ["API" tag page]: Show all articles with the tag "API" (including those where "API" is a secondary tag).
  • ["Archive" tag page]: Show all articles with the tag "Archive" (including those where "Archive" is a secondary tag).
  • Archive Collection: Hidden Features: (Jan 20, 2023) I'm on vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: Hidden Features.
  • Archive Collection: Bug Types: (Jan 21, 2023) I'm on vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: Bug Types.
  • Archive Collection: twinBASIC: (Jan 22, 2023) I'm on vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: twinBASIC.
  • Archive Collection: Test-Driven Development: (Jan 23, 2023) I'm on vacation! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: Test-Driven Development (TDD).
  • Archive Collection: Tools: (Jan 24, 2023) I'm on vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: Tools.
  • Archive Collection: Defensive Programming: (Jan 25, 2023) I'm on vacation! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: Defensive Programming.
  • Archive Collection: Form Design: (Jan 26, 2023) I'm on vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: Form Design.
  • Archive Collection: Humor: (Jan 27, 2023) I'm on vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: Humor.
  • Archive Collection: Field Descriptions: (Jul 24, 2023) I'm on a short vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy this curated collection of articles. Today's topic: Field Descriptions.
  • Archive Collection: String Functions: (Jan 4, 2024) I'm on vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: String Functions.
  • Archive Collection: Combo Boxes: (Jan 5, 2024) I'm on vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: Combo Boxes.
  • Archive Collection: Window Functions: (Jan 6, 2024) I'm on vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: Window Functions.
  • Archive Collection: DevCon 2023: (Jan 7, 2024) I'm on vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: DevCon 2023.
  • Archive Collection: Design Functions: (Jan 8, 2024) I'm on vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: Design Functions.
  • Archive Collection: Debugging: (Jan 9, 2024) I'm on vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: Debugging.
  • Archive Collection: Date Functions: (Jan 10, 2024) I'm on vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: Date Functions.
  • Archive Collection: Quick Tips: (May 30, 2024) I'm on vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: Quick Tips.
  • Archive Collection: Fluent Interfaces: (May 31, 2024) I'm on vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: Fluent Interfaces.
  • Archive Collection: SQL Server: (Jun 1, 2024) I'm on vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: SQL Server.
  • Archive Collection: Nothing: (Jun 3, 2024) I'm on vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: Nothing...
  • ["AutoHotKey" tag page]: Show all articles with the tag "AutoHotKey" (including those where "AutoHotKey" is a secondary tag).
  • Debugging VBA with no Break Key: (Oct 27, 2020) 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.
  • A Mind-Reading Script: (Oct 28, 2020) What if you could highlight any text, press a hotkey, and have Windows do what you want almost every time? You'd have my top productivity hack.
  • Expand Your Access Palette: (Oct 31, 2020) Use AutoHotkey to bring consistency to your Access color schemes and save time when designing forms.
  • Size Matters: (Nov 1, 2020) Testing your program for small screens? You could change your own monitor's resolution, but that gets annoying real fast. Here's a better way.
  • "Toggle" Hotkey for the Immediate Window: (Nov 18, 2020) Am I the only one who finds it annoying that [Ctl] + [G] doesn't *toggle* between the immediate window and the code window? Let's fix that.
  • Streamlining SaveAsText / LoadFromText: (Mar 19, 2021) SaveAsText and LoadFromText are indispensable for Access version control. They're also annoying to type repeatedly. Let's fix that.
  • Toggle ODBC TraceSQLMode with an AutoHotKey Script: (Mar 14, 2022) Traditional methods of enabling and disabling ODBC TraceSQLMode are a pain in the neck. This AutoHotKey script makes it as easy as pushing a button.
  • ["Basic" tag page]: Show all articles with the tag "Basic" (including those where "Basic" is a secondary tag).
  • ["Best Of" tag page]: Show all articles with the tag "Best Of" (including those where "Best Of" is a secondary tag).
  • My Top 10 Allen Browne Posts: (Nov 11, 2022) If you're a Microsoft Access developer and you've never heard of Allen Browne, then you are in for a treat...
  • My Top 10 Joel Spolsky Posts: (Mar 8, 2023) If you are running a small (or large) software development company, Joel Spolsky should be at the top of your reading list.
  • ["Book Review" tag page]: Show all articles with the tag "Book Review" (including those where "Book Review" is a secondary tag).
  • Code that Fits in Your Head: (Aug 15, 2023) "Code that Fits in Your Head" is to senior software developers what "Code Complete" is to junior software developers. I can think of no higher praise.
  • ["Bug Alert" tag page]: Show all articles with the tag "Bug Alert" (including those where "Bug Alert" is a secondary tag).
  • ["Bug Types" tag page]: Show all articles with the tag "Bug Types" (including those where "Bug Types" is a secondary tag).
  • Syntax Errors: (Aug 5, 2021) Every programming language has its own syntactical quirks. The C family loves braces. Python loves indentation. BASIC loves words. And Perl loves #%@!{}]&.
  • Compile Errors: (Aug 6, 2021) Compile errors are easy to keep out of deployed code (just remember to Debug > Compile). Which is good because they hard crash Access in Runtime mode.
  • Misunderstood Requirements in the Project Design Phase: (Aug 7, 2021) Your client knows what's wrong. They *think* they know how to fix it. But treating symptoms is never as effective as treating the disease.
  • Automated Test Errors (aka, Failing Tests): (Aug 10, 2021) You can have a bug in your code and/or in your test. You're unlikely to have the *same* bug in your code and your test.
  • Logic Errors: (Aug 19, 2021) The logic error is the most dangerous and insidious of all software errors.
  • Runtime Errors: (Aug 20, 2021) It's impossible to predict every possible scenario that could befall our applications in the wild. But we need to at least try.
  • Misunderstood Requirements (After You've Written the Code): (Aug 21, 2021) As you install the final piece of crown molding in the dog's second bedroom, you can't help but smile at the absurdity of it all.
  • "It Runs On My Computer": (Aug 28, 2021) Here are the 7 most common reasons I've had to utter those words as an Access developer.
  • Why You Should Learn to Love Syntax Errors: (Apr 24, 2023) The immediate negative feedback loop that syntax errors provide is a powerful learning tool.
  • ["Business" tag page]: Show all articles with the tag "Business" (including those where "Business" is a secondary tag).
  • ["ChatGPT" tag page]: Show all articles with the tag "ChatGPT" (including those where "ChatGPT" is a secondary tag).
  • Copyright Implications of ChatGPT Content: (Jan 3, 2023) ChatGPT from OpenAI is taking the world by storm. Who owns the ChatGPT output? Can you pass it off as your own? Do you need to acknowledge OpenAI?
  • ChatGPT: (Jan 4, 2023) The personal computer. Google search. The smart phone. Lifelike chat bots. Another generation-defining technology has arrived.
  • My Policy on ChatGPT-Generated Content: (Jan 5, 2023) I plan to use ChatGPT to generate content at NoLongerSet.com. But I plan to do it with full transparency. Here is my pledge to you, dear reader.
  • ChatGPT: Code-Writing Intern, Code-Reading Mentor: (Feb 13, 2024) An exploration of ChatGPT's relative strengths and weaknesses when it comes to writing vs. reading code.
  • ["Class Modules" tag page]: Show all articles with the tag "Class Modules" (including those where "Class Modules" is a secondary tag).
  • ["Code Complete" tag page]: Show all articles with the tag "Code Complete" (including those where "Code Complete" is a secondary tag).
  • ["Code Library" tag page]: Show all articles with the tag "Code Library" (including those where "Code Library" is a secondary tag).
  • ["COM" tag page]: Show all articles with the tag "COM" (including those where "COM" is a secondary tag).
  • ["Combo Boxes" tag page]: Show all articles with the tag "Combo Boxes" (including those where "Combo Boxes" is a secondary tag).
  • ["Commentary" tag page]: Show all articles with the tag "Commentary" (including those where "Commentary" is a secondary tag).
  • ["Conventions" tag page]: Show all articles with the tag "Conventions" (including those where "Conventions" is a secondary tag).
  • VBA Squeeze Box: (Sep 20, 2020) I discussed previously the differences between passing by value and passing by reference. I now want to discuss how and when I use each in my own code.
  • Enum Type Naming Convention: (Oct 9, 2020) The combination of "IntelliSense overload" and "global identifier case changes" convinced me I needed a different approach.
  • Comment Continuations: (Dec 3, 2020) Using ellipses to "group" comments separated by intervening lines of code.
  • Googleable Field Names: (Feb 7, 2021) Using globally unique field and table names will make it easier to identify where such fields and tables are used throughout your application.
  • Beautiful Blocks of Boilerplate: (May 3, 2021) Using the colon character to join multiple lines of code all willy-nilly can lead to messy code. But, used judiciously, it can create beauty from chaos.
  • Database Date Field Naming Convention: (Sep 21, 2021) Naming is hard. When it comes to naming conventions, the key is to keep things simple. Here's how I like to name the date and time fields in my databases.
  • Naming Conventions Matter: Making Wrong Code Look Wrong: (Oct 14, 2021) Joel Spolsky and Antonin Scalia join forces to help illustrate the importance of sensible code naming conventions.
  • My File System Variable Naming Convention for VBA: (Aug 9, 2022) "SourcePath" may be one of the worst variable names ever written. Is it the full path to a source file? Is it the folder where my source files are located?
  • PascalCase All the Things: (Jun 30, 2023) There is only one correct capitalization convention in VBA: PascalCase.
  • ["Debugging" tag page]: Show all articles with the tag "Debugging" (including those where "Debugging" is a secondary tag).
  • ["Deployment" tag page]: Show all articles with the tag "Deployment" (including those where "Deployment" is a secondary tag).
  • ["DevCon" tag page]: Show all articles with the tag "DevCon" (including those where "DevCon" is a secondary tag).
  • ["DoEvents" tag page]: Show all articles with the tag "DoEvents" (including those where "DoEvents" is a secondary tag).
  • ["Events" tag page]: Show all articles with the tag "Events" (including those where "Events" is a secondary tag).
  • The ArrowKeyNav Routine: (May 1, 2021) Enable Excel-like navigation in your continuous forms by overriding the default behavior of the up and down arrow keys.
  • ArrowKeyNav Presentation: (May 6, 2021) A list of resources and further reading to support my presentation on Navigating Continuous Forms using WithEvents.
  • Many Objects, One Class Module: (May 8, 2021) Check out this trick for reducing boilerplate code: maintain a private collection of objects that are instances of the class itself.
  • ComboBox Dropped Down State: (May 10, 2021) Overriding the up/down arrow key behavior improves the user experience on a continuous Access form. But what if the user drops down a combo box?
  • AddNew Increments AutoNumber Fields: (May 11, 2021) Thanks to Ben Clothier, we've got another improvement to our Arrow Key Navigation class.
  • The ArrowKeyNav Journey: (May 20, 2021) A full breakdown of my weArrowKeyNav class module that uses WithEvents to override the default up and down arrow key behavior in continuous Access forms.
  • ["Fluent API" tag page]: Show all articles with the tag "Fluent API" (including those where "Fluent API" is a secondary tag).
  • ["Form Design" tag page]: Show all articles with the tag "Form Design" (including those where "Form Design" is a secondary tag).
  • ["Forms" tag page]: Show all articles with the tag "Forms" (including those where "Forms" is a secondary tag).
  • ["Holiday" tag page]: Show all articles with the tag "Holiday" (including those where "Holiday" is a secondary tag).
  • Merry Christmas: (Dec 25, 2020) "...the shepherds said to one another, 'Let’s go to Bethlehem and see this thing that has happened, which the Lord has told us about.'"
  • Happy Easter: (Apr 4, 2021) “Don’t be alarmed,” he said. "You are looking for Jesus the Nazarene, who was crucified. He has risen! He is not here."
  • Merry Christmas: (Dec 25, 2021) "But the angel said to her, 'Do not be afraid, Mary; you have found favor with God. You will conceive and give birth to a son, and you are to call him Jesus.' "
  • Happy Easter: (Apr 17, 2022) "Why do you look for the living among the dead? He is not here; he has risen!"
  • Merry Christmas: (Dec 25, 2022) "...She will give birth to a son, and you are to give him the name Jesus, because he will save his people from their sins.”
  • Happy Easter: (Apr 9, 2023) “Because you have seen me, you have believed; blessed are those who have not seen and yet have believed.”
  • Merry Christmas: (Dec 25, 2023) "The Word became flesh and made his dwelling among us. We have seen his glory, the glory of the one and only Son..."
  • Happy Easter: (Mar 31, 2024) "Do not be afraid, for I know that you are looking for Jesus, who was crucified. He is not here; he has risen, just as he said."
  • ["Humorous" tag page]: Show all articles with the tag "Humorous" (including those where "Humorous" is a secondary tag).
  • Reproducing Errors: (Oct 7, 2021) A physicist, a mechanic, and a programmer were in a car driving over a steep alpine pass when the brakes failed...
  • ["Interfaces" tag page]: Show all articles with the tag "Interfaces" (including those where "Interfaces" is a secondary tag).
  • ["Intermediate" tag page]: Show all articles with the tag "Intermediate" (including those where "Intermediate" is a secondary tag).
  • ["Leadership" tag page]: Show all articles with the tag "Leadership" (including those where "Leadership" is a secondary tag).
  • ["List Fields" tag page]: Show all articles with the tag "List Fields" (including those where "List Fields" is a secondary tag).
  • ["Long-Form" tag page]: Show all articles with the tag "Long-Form" (including those where "Long-Form" is a secondary tag).
  • ["Meta" tag page]: Show all articles with the tag "Meta" (including those where "Meta" is a secondary tag).
  • Topics Page Redesign: (Apr 22, 2022) Check out the redesigned Topics page at nolongerset.com! It's now auto-updating and optimized for discovering new content.
  • Scaling Back: (Jun 7, 2024) Publishing every day is a grind.
  • ["Migration" tag page]: Show all articles with the tag "Migration" (including those where "Migration" is a secondary tag).
  • ["Military" tag page]: Show all articles with the tag "Military" (including those where "Military" is a secondary tag).
  • ["Presentations" tag page]: Show all articles with the tag "Presentations" (including those where "Presentations" is a secondary tag).
  • Journey to Access: Part 1: (Sep 25, 2020) Many of the best Microsoft Access applications are written by people with no formal background in software development. Your origin story starts here.
  • Journey to Access: Part 2: (Sep 26, 2020) The weirdos who enjoy spending lots of time to avoid doing mundane tasks that only take a little time have their own special name: programmers. Welcome to our very weird club.
  • Journey to Access: Part 3: (Sep 27, 2020) A morass of Word documents and Excel workbooks--the invasive plant species of the Windows world--overgrowing your file system like so much digital kudzu.
  • One Step at a Time: (Jan 29, 2021) To reach great heights, take small steps.
  • Growing a Business: (Feb 13, 2021) I used to think owning a business was scary. And then I decided to start growing it.
  • Equal Parts Excited and Terrified: (Mar 29, 2021) You know you’ve found a worthy challenge when you are equal parts excited and terrified to take it on. Because that is how you grow.
  • Access DevCon 2021: Day 1: (Apr 22, 2021) If you weren't able to make it to virtual Access DevCon Vienna 2021, here's what you missed on Day 1.
  • Access DevCon 2021: Day 2: (Apr 24, 2021) If you weren't able to make it to virtual Access DevCon Vienna 2021, here's what you missed on Day 2.
  • The Gambler: (Aug 17, 2021) The most consequential piece of business advice I ever received came from the fictional owner of Pritchett's Closets & Blinds.
  • "This feels weird.": (Sep 20, 2021) My nine-year-old son got hit in the head at soccer practice the other day. His reaction reminds me of my own professional software development journey.
  • How to Write a Daily Article: (Nov 4, 2021) Publishing an article every day is not for the faint of heart. But the benefits compound if you can stick with it.
  • UNC Alias for a Local Folder: (Nov 13, 2021) The subst command lets us mimic mapped network drives. But what if your backend tables are linked using UNC paths? Don't worry. We can handle those, too!
  • $5,999: Microsoft's Insane Price for Access 2013: (Jul 20, 2022) Microsoft does not make it easy to buy old versions of Access, even though you need them to distribute compiled .accde files for *still-supported* runtimes.
  • The Robot, the Technician, and the Fixer: (Jul 28, 2022) What type of Microsoft Access developer are you? Being a robot is easy, being a technician is fun, but being a fixer is valuable.
  • Learning From Other Languages: (Nov 17, 2022) Even if you only write code professionally in a single language, learning the concepts and idioms of other languages will make you a better programmer.
  • Learning From Other Coding Styles: (Nov 18, 2022) Will learning multiple coding styles make you a better programmer? And, does it make sense to import those coding styles into your primary language?
  • ["Prompt School" tag page]: Show all articles with the tag "Prompt School" (including those where "Prompt School" is a secondary tag).
  • ["Quick Tip" tag page]: Show all articles with the tag "Quick Tip" (including those where "Quick Tip" is a secondary tag).
  • ["Quotes" tag page]: Show all articles with the tag "Quotes" (including those where "Quotes" is a secondary tag).
  • ["Recap" tag page]: Show all articles with the tag "Recap" (including those where "Recap" is a secondary tag).
  • ["Reports" tag page]: Show all articles with the tag "Reports" (including those where "Reports" is a secondary tag).
  • ["Ribbon" tag page]: Show all articles with the tag "Ribbon" (including those where "Ribbon" is a secondary tag).
  • Good. Better. Best.: (Dec 16, 2020) Take the test to see where your (or someone else's) Access application stands.
  • MS Access Risk Management: (Dec 20, 2020) Applying US Army risk management techniques to assess Microsoft Access application risk.
  • Proving the Concept with Access: (Dec 26, 2020) Committing to a major custom software development project is fraught with risk. Reduce that risk by prototyping in Access first.
  • Securing Your Data: (Feb 8, 2021) Relying on application-level security to protect your data would be like using guard rails to keep out your enemies.
  • Mail: An Allegory: (Feb 14, 2021) Behold, the world's greatest literary allegory since George Orwell penned "Animal Farm."
  • The Allegory Explained: (Feb 15, 2021) What does delivering mail have to do with writing software applications? I'm glad you asked.
  • Cowpathing with Microsoft Access: (Nov 26, 2021) How do you decide where to spend your software development dollars? Don't guess what your users need, let them show you with Access.
  • ["Series" tag page]: Show all articles with the tag "Series" (including those where "Series" is a secondary tag).
  • ["ShowForm" tag page]: Show all articles with the tag "ShowForm" (including those where "ShowForm" is a secondary tag).
  • No Longer Set: (Oct 30, 2020) Signal is information that conveys meaning. Noise obscures that information. The key to writing good software is to maximize signal and minimize noise.
  • When Good Comments Go Bad: (Nov 10, 2020) Bad actors carry out disinformation campaigns to poison our discourse. But when we write code, sometimes we're the bad actors.
  • Signal vs. Noise: Error Handling: (Nov 20, 2020) To boost our signal to noise ratio, we can increase our lines of meaningful code or decrease the lines of boilerplate.
  • Signal vs. Noise: ShowPlan.out Edition: (Mar 16, 2022) Reading showplan.out files can be intimidating for new and experienced Access developers alike. This simple rule will help get you started.
  • ["SQL" tag page]: Show all articles with the tag "SQL" (including those where "SQL" is a secondary tag).
  • ["SQL Azure" tag page]: Show all articles with the tag "SQL Azure" (including those where "SQL Azure" is a secondary tag).
  • ["SQL Server" tag page]: Show all articles with the tag "SQL Server" (including those where "SQL Server" is a secondary tag).
  • ["Subforms" tag page]: Show all articles with the tag "Subforms" (including those where "Subforms" is a secondary tag).
  • ["TempVars" tag page]: Show all articles with the tag "TempVars" (including those where "TempVars" is a secondary tag).
  • ["Testing" tag page]: Show all articles with the tag "Testing" (including those where "Testing" is a secondary tag).
  • Throwback Thursday: June 13, 2024: (Jun 13, 2024) In this inaugural installment of Throwback Thursday, we focus on the intersection of programming, business, and careers (plus some classic XKCD).
  • Throwback Thursday: June 20, 2024: (Jun 20, 2024) Today's edition of Throwback Thursday is all about query tuning in Microsoft Access.
  • Throwback Thursday: June 27, 2024: (Jun 27, 2024) Today's edition of Throwback Thursday is all about naming things, one of the two hard problems in computer science.
  • Throwback Thursday: July 4, 2024: (Jul 4, 2024) Happy Independence Day, America! (Or as my family in Scotland prefers to greet us on this glorious anniversary, "Happy Treason Day, you ungrateful colonists.")
  • Throwback Thursday: July 11, 2024: (Jul 11, 2024) For those new to databases (and seasoned pros), queries are a mind-bogglingly amazing and infuriatingly obstinate tool. These tips help tame the beast.
  • Throwback Thursday: July 18, 2024: (Jul 18, 2024) Today's edition is all about Unicode, character sets, and Windows Alt Codes. It turns out English is NOT the world's only written language. Who knew?!?!
  • Throwback Thursday: July 25, 2024: (Jul 25, 2024) Today's edition of Throwback Thursday is all about the dangers of password reuse and a couple of tools to help you avoid the temptation.
  • Throwback Thursday: August 1, 2024: (Aug 1, 2024) Today's edition of Throwback Thursday explores the paradox of reliable software: better software -> increased user trust -> more potential for harm.
  • Throwback Thursday: August 8, 2024: (Aug 8, 2024) Today's edition of Throwback Thursday is all about pricing and estimating custom software development work.
  • Throwback Thursday: August 15, 2024: (Aug 15, 2024) Teach your VBA editor new tricks: dark mode, a shortcut key for commenting blocks of code, and a probably-too-clever block-comment syntax.
  • Throwback Thursday: August 22, 2024: (Aug 22, 2024) Today's edition is all about controlling how and where Access forms open on your screen.
  • Throwback Thursday: August 29, 2024: (Aug 29, 2024) Today's edition of Throwback Thursday is all about how Access talks to SQL Server. It's much chattier than you realize.
  • Throwback Thursday: September 5, 2024: (Sep 5, 2024) How do non-programmers become Access developers? We explore a common career arc in today's edition of Throwback Thursday.
  • Throwback Thursday: September 12, 2024: (Sep 12, 2024) Today's edition of Throwback Thursday highlights my three most-used string functions: Conc(), Qt(), and Parse(), used to join words, quote words, and extract words.
  • Throwback Thursday: September 19, 2024: (Sep 19, 2024) In today's edition of Throwback Thursday, I revisit the one VBA add-in I can't live without: vbWatchdog.
  • Throwback Thursday: September 26, 2024: (Sep 26, 2024) Short on time? In today's edition of Throwback Thursday, we explore a few of my favorite articles in my Under 100 series--complex topics explained in under 100 words.
  • Throwback Thursday: October 3, 2024: (Oct 3, 2024) In today's edition of Throwback Thursday, we revisit a few of my favorite techniques to keep out of trouble when debugging code and editing live data.
  • Throwback Thursday: October 10, 2024: (Oct 10, 2024) In today's edition of Throwback Thursday, we address Access consultants' biggest fear: the dreaded software proposal.
  • Throwback Thursday: October 17, 2024: (Oct 17, 2024) Today's edition of Throwback Thursday is all about one of my two favorite programming books: "Code That Fits in Your Head," by Mark Seemannn.
  • Throwback Thursday: October 24, 2024: (Oct 24, 2024) In today's edition of Throwback Thursday, we demystify the WithEvents keyword in VBA and then dive deep into some practical uses for it.
  • Throwback Thursday: October 31, 2024: (Oct 31, 2024) In today's edition of Throwback Thursday, we revisit my RegEx wrapper functions for VBA, while looking ahead to a future without VBScript.dll.
  • Throwback Thursday: November 7, 2024: (Nov 7, 2024) Follow along to see how I used Test-Driven Development to replace hard-coded holiday dates with a robust, history-aware date engine in today's edition of Throwback Thursday.
  • Throwback Thursday: November 14, 2024: (Nov 14, 2024) In today's edition of Throwback Thursday, we explore a topic near and dear to my heart: Version Control with Microsoft Access.
  • Throwback Thursday: November 21, 2024: (Nov 21, 2024) In today's edition of Throwback Thursday, we revisit my annual twinBASIC talks at DevCon Vienna in honor of my presentation to the UK Access User Group yesterday.
  • Throwback Thursday: November 28, 2024: (Nov 28, 2024) Discover three mindset shifts that can transform you from a developer into a high-value consultant in today's edition of Throwback Thursday.
  • Throwback Thursday: December 5, 2024: (Dec 5, 2024) Learn how to enhance TempVars with type safety, IntelliSense, and compile-time checking in today's edition of Throwback Thursday.
  • ["Tools" tag page]: Show all articles with the tag "Tools" (including those where "Tools" is a secondary tag).
  • ["twinBASIC" tag page]: Show all articles with the tag "twinBASIC" (including those where "twinBASIC" is a secondary tag).
  • twinBASIC Update: May 2, 2021: (May 2, 2021) Highlights include C-style block comments, support for additional Rubberduck annotations, and With blocks for UDTs.
  • twinBASIC Update: May 9, 2021: (May 9, 2021) Highlights include support for a new Attribute syntax, ActiveX DLL registration via regsvr32, and PredeclaredID for twinBASIC classes.
  • twinBASIC Update: May 16, 2021: (May 16, 2021) Highlights include stability improvements for the twinBASIC compiler and the YouTube release of my hourlong twinBASIC presentation at DevCon Vienna.
  • twinBASIC Update: May 23, 2021: (May 23, 2021) Highlights include passing (pseudo-)command-line arguments to a twinBASIC console app and an update from Wayne on the project's progress.
  • twinBASIC Update: May 30, 2021: (May 30, 2021) Highlights include improved compiler stability, making the Optional keyword optional, and setting command-line arguments for debugging.
  • twinBASIC Update: June 6, 2021: (Jun 6, 2021) Highlights include Mid statement support, DefType support, multiple bug fixes, and a (sort of) announcement regarding unit testing support.
  • twinBASIC Update: June 13, 2021: (Jun 13, 2021) Highlights include Like statement support and a new VS Code command to create new project files (no more downloading .zip files from twinbasic.com!).
  • twinBASIC Update: June 20, 2021: (Jun 20, 2021) Highlights include custom events in twinBASIC classes, full Debug.Print syntax support, and an experimental code prettifier.
  • twinBASIC Update: June 27, 2021: (Jun 27, 2021) Highlights include support for external version control, the official launch of the code prettifier, and support for resources and visual styles via manifest files.
  • twinBASIC Update: July 4, 2021: (Jul 4, 2021) Highlights include support for EXE/DLL embedded resources plus *LOTS* of code writing experience improvements, like rename refactoring, auto-indent, etc.
  • twinBASIC Update: July 11, 2021: (Jul 11, 2021) Highlights include a sneak peek at the yet-to-be-released form editor, a teaser about possible control inheritance, and a future option for version control.
  • twinBASIC Update: July 18, 2021: (Jul 18, 2021) Highlights include continued work on the GUI plus future support for web forms and IntelliSense in the Debug Console.
  • twinBASIC Update: July 25, 2021: (Jul 25, 2021) Highlights include unique icon colors for each code file type, plus Standard vs. Professional vs. Ultimate editions, pricing, pre-orders, and early-bird discounts.
  • twinBASIC Update: August 1, 2021: (Aug 1, 2021) Highlights include VSCode CodeLens support, compiler warnings, VB_GlobalNameSpace support, and twinBASIC's debut on stackoverflow.
  • twinBASIC Update: August 8, 2021: (Aug 8, 2021) Highlights include a revamped references list UX, a 100%-twinBASIC-compatible Printers object replacement, and news on unit testing and documentation.
  • twinBASIC Update: August 15, 2021: (Aug 15, 2021) Highlights include IntelliSense improvements, a 12-month twinBASIC roadmap, and a pure Win32 API GUI application written in twinBASIC.
  • twinBASIC Update: August 22, 2021: (Aug 22, 2021) Highlights include a sneak-peek at the forthcoming integrated unit testing framework, App.ThreadID, App.hInstance, and MSVBVM60.dll redirections.
  • twinBASIC Update: August 29, 2021: (Aug 29, 2021) Highlights include Unit Testing support, conditional breakpoints, the Nz() function, and various IntelliSense improvements.
  • twinBASIC Update: September 5, 2021: (Sep 5, 2021) Highlights include IntelliSense in the Debug Console, unit testing improvements, and the addition of #Error and #Warning directives.
  • twinBASIC Update: September 12, 2021: (Sep 12, 2021) Highlights include VS Code Extensibility, RGB extraction functions, dropping Finalize(), and a discussion regarding potential typedef support.
  • twinBASIC Update: September 19, 2021: (Sep 19, 2021) Highlights include discussions around block scoping and a planned ObjRefCount() function.
  • twinBASIC Update: September 26, 2021: (Sep 26, 2021) Highlights include a sneak peek at building custom form controls, the related dynamic property sheet, and a bunch of screenshots teasing the upcoming features.
  • twinBASIC Update: October 3, 2021: (Oct 3, 2021) Highlights include a glimpse into the possible GUI release timeline and a discussion about data binding with twinBASIC forms.
  • twinBASIC Update: October 10, 2021: (Oct 10, 2021) Highlights include an extended preview of the yet-to-be-released form designer and a spirited discussion about whether to fork VS Code to create a dedicated tB IDE.
  • twinBASIC Update: October 17, 2021: (Oct 17, 2021) Highlights include the alpha release of CustomControls, a twinBASIC wiki, and a revived discussion around "Quirks Mode" in twinBASIC.
  • twinBASIC Update: October 24, 2021: (Oct 24, 2021) Highlights include the addition of 4 new custom control events, ElementTabStop/Index properties, and a Spanish presentation on twinBASIC.
  • twinBASIC Update: October 31, 2021: (Oct 31, 2021) Highlights include initial support for a Clipboard object, a new custom control sample (Wayne's TextBox), and support for Return as an alias for Exit Sub.
  • twinBASIC Update: November 7, 2021: (Nov 7, 2021) Highlights include our first look at a working twinBASIC form, the early makings of inheritance support, and the promise of custom ActiveX control development.
  • twinBASIC Update: November 14, 2021: (Nov 14, 2021) Highlights include temporary removal of the license key requirement for CustomControls and partial inheritance support using Implements ... Via.
  • twinBASIC Update: November 21, 2021: (Nov 21, 2021) Highlights include 64-bit compilation support (no license required!) and a discussion about early binding and reference handling.
  • twinBASIC Update: November 28, 2021: (Nov 28, 2021) Highlights include the first major release of file handling statements and functions in twinBASIC, along with talk of providing a tB license to the Rubberduck project.
  • twinBASIC Update: December 5, 2021: (Dec 5, 2021) Highlights include the implementation of additional File System features, improved performance for Split and Replace, and a discussion about universal binaries.
  • twinBASIC Update: December 12, 2021: (Dec 12, 2021) Highlights include the File I/O system reaching feature-complete status, an updated twinBASIC roadmap, and experimental text encoding support.
  • twinBASIC Update: December 19, 2021: (Dec 19, 2021) Highlights include support for importing VB6 project files (*.vbp), new MsgBox options, and a spirited discussion about what tB's design priorities should be.
  • twinBASIC Update: December 26, 2021: (Dec 26, 2021) Highlights include several improvements to the COM references list, a fix for the hidden dialog windows issue, and many discussions about possible tB features.
  • twinBASIC Update: January 2, 2022: (Jan 2, 2022) Highlights include a feature to generate missing implementations, minor improvements to the Reference List UX, and some spirited debates.
  • twinBASIC Update: January 9, 2022: (Jan 9, 2022) Highlights include error messages that now match VBx, a twinBASIC Discord server, and a teaser about twinBASIC's potential as a VBA replacement.
  • twinBASIC Update: January 16, 2022: (Jan 16, 2022) Highlights include the CompileIf attribute and IsObject function for generics, an experimental package manager, and 10 Guiding Principles of twinBASIC.
  • twinBASIC Update: January 23, 2022: (Jan 23, 2022) Highlights include the introduction of TWINPACKs and the TWINSERV package manager, IntelliSense improvements, and easier reporting of twinBASIC bugs.
  • twinBASIC Update: January 30, 2022: (Jan 30, 2022) Highlights include a sample project demonstrating the WaynesGrid control and a timeline update for the release of (some) native Win32 controls.
  • twinBASIC Update: February 6, 2022: (Feb 6, 2022) Highlights include the milestone release of WinForms functionality, control inheritance, ReadOnly class properties, and twinPACK updating documentation.
  • twinBASIC Update: February 13, 2022: (Feb 13, 2022) Highlights include a new Settings filter bar and WinForms Controls Package updates included by default with future twinBASIC extension updates.
  • twinBASIC Update: February 20, 2022: (Feb 20, 2022) Highlights include checkbox-style list boxes, native Winforms progress bar and image controls, and an option to align controls to grid in the form designer.
  • twinBASIC Update: February 27, 2022: (Feb 27, 2022) Highlights include multiple form designer improvements and a *BIG* announcement about the future of the twinBASIC IDE.
  • twinBASIC Update: March 6, 2022: (Mar 6, 2022) Highlights include a sneak peek at the new twinBASIC IDE (currently under development) and a brief comparison between RAD Basic and twinBASIC.
  • twinBASIC Update: March 13, 2022: (Mar 13, 2022) Highlights include another sneak peek of the upcoming twinBASIC IDE and a special announcement regarding Access DevCon Vienna 2022.
  • twinBASIC Update: March 20, 2022: (Mar 20, 2022) Highlights include a cryptic update on the new IDE's release date and a possible twinBASIC solution to the oft-delayed Access modern browser control.
  • twinBASIC Update: March 27, 2022: (Mar 27, 2022) Highlights include a release date for the twinBASIC IDE and plans to open-source the IDE's source code.
  • twinBASIC Update: April 3, 2022: (Apr 3, 2022) Highlights include the release of the new IDE and an announcement about twinBASIC's role at the upcoming Access DevCon Vienna conference.
  • twinBASIC Update: April 10, 2022: (Apr 10, 2022) Highlights include 7 (!) new releases of the twinBASIC IDE and twinBASIC solving a difficult problem for a popular MS Access open-source addin.
  • twinBASIC Update: April 16, 2022: (Apr 16, 2022) Highlights include multiple debug console performance improvements and a workaround for antivirus software flagging twinBASIC as potential malware.
  • twinBASIC Update: April 24, 2022: (Apr 24, 2022) Highlights include updated samples for building custom VBIDE tool windows and custom ActiveX controls that you can drop on Access forms and reports.
  • twinBASIC Update: May 1, 2022: (May 1, 2022) Highlights include Set Next Statement support, new code samples and templates, a roadmap update, and a 7-Zip VBA library written in twinBASIC.
  • twinBASIC Update: May 8, 2022: (May 8, 2022) Highlights include version control-friendly improvements to the new IDE, an IDE Font Size setting, and a milestone for another VBx successor language, RAD Basic.
  • twinBASIC Update: May 15, 2022: (May 15, 2022) Highlights include a modern browser control for Microsoft Access (yes, you read that right) and a spirited discussion regarding attribute syntax.
  • twinBASIC Update: May 22, 2022: (May 22, 2022) Highlights include the beginnings of a Screen object, an updated Attribute syntax, and a reimagined ending to a Disney classic (yes, it's a bit off-topic).
  • twinBASIC Update: May 29, 2022: (May 29, 2022) Highlights include new build features, a good Exit Code discussion, and a multi-threaded twinBASIC proof of concept from Ben Clothier.
  • twinBASIC Update: June 5, 2022: (Jun 5, 2022) Includes a sneak peek of the upcoming ActiveX Control Extender support in twinBASIC.
  • twinBASIC Update: June 12, 2022: (Jun 12, 2022) Highlights include ActiveX control support on twinBASIC forms and a discussion about the (accidental?) interface constructor language feature.
  • twinBASIC Update: June 19, 2022: (Jun 19, 2022) Highlights include improved support for 3rd-party ActiveX controls, a new location for tB IDE releases, and a discussion about where to put non-visual controls.
  • twinBASIC Update: June 26, 2022: (Jun 26, 2022) Highlights include container support, IDE bug fixes, and a modest request for a complete backward-compatible rewrite of MS Access in twinBASIC.
  • twinBASIC Update: July 3, 2022: (Jul 3, 2022) Highlights include added support for the VB6 `End` statement, shape controls, and double-click to change property values in the IDE.
  • twinBASIC Update: July 10, 2022: (Jul 10, 2022) Highlights include new shape controls, code-signed twinBASIC IDE and compiler executables, and twinBASIC's first appearance on HackerNews.
  • twinBASIC Update: July 17, 2022: (Jul 17, 2022) Highlights include double-click to change form/control properties in the IDE, support for the Form.Show Modal argument, and a discussion about On Error Resume Next.
  • twinBASIC Update: July 24, 2022: (Jul 24, 2022) Highlights include implementation of the form Controls collection, initial publication of the twinBASIC Guiding Principles, and the potential to write device drivers with tB.
  • twinBASIC Update: July 31, 2022: (Jul 31, 2022) Highlights include improved support for building device drivers, initial support for keyboard menu navigation, and a milestone for the twinBASIC project.
  • twinBASIC Update: August 7, 2022: (Aug 7, 2022) Highlights include a major compiler refactor to help reduce compiler memory usage and proposed support for multiple built-in rounding methods.
  • twinBASIC Update: August 14, 2022: (Aug 14, 2022) Highlights include IDE memory optimizations, build size reductions, and a discussion about a potential extensibility library for the IDE.
  • twinBASIC Update: August 21, 2022: (Aug 21, 2022) Highlights include IDE improvements, support for Excel events in COM addins, and a kernel-mode driver written in twinBASIC (yes, really).
  • twinBASIC Update: August 28, 2022: (Aug 28, 2022) Highlights include improvements to code selector boxes in the IDE, IntelliSense improvements, and better support for "kernel mode" (i.e., device drivers).
  • twinBASIC Update: September 4, 2022: (Sep 4, 2022) Highlights include new IDE shortcut keys, an awesome new IDE History panel, and a project from fafalone that showcases twinBASIC's interface definition feature.
  • twinBASIC Update: September 11, 2022: (Sep 11, 2022) Highlights include 4 new form controls (TreeView, DriveListBox, DirListBox, FileListBox), an impromptu Q&A with Wayne, and WinNativeForms source.
  • twinBASIC Update: September 18, 2022: (Sep 18, 2022) Highlights include the initial implementation of a PictureBox control and a custom Windows Event Viewer written in twinBASIC.
  • twinBASIC Update: September 25, 2022: (Sep 25, 2022) Highlights include long-awaited VB6 form import support (experimental) and a community-led GitHub project to provide official documentation for twinBASIC.
  • twinBASIC Update: October 2, 2022: (Oct 2, 2022) Highlights include a pile of new form and control properties, a form menu designer, visual tab stop indicators in design view, and a new twinBASIC LinkedIn group.
  • twinBASIC Update: October 9, 2022: (Oct 9, 2022) Highlights include support for control and menu arrays, a Type Library Viewer (Object Browser equivalent), and a video interview with twinBASIC creator Wayne Phillips.
  • twinBASIC Update: October 16, 2022: (Oct 16, 2022) Highlights include two new ways to open the twinBASIC IDE (via .twinproj files and Windows shortcuts), better performance for IDE panels, and more GUI progress.
  • twinBASIC Update: October 23, 2022: (Oct 23, 2022) Highlights include many IDE improvements, better support for high-performance code, and a sample Task Dialog project from fafalone.
  • twinBASIC Update: October 30, 2022: (Oct 30, 2022) Highlights include better PNG handling, improvements to the custom menu builder, and support for a NumbersOnly textbox property.
  • twinBASIC Update: November 6, 2022: (Nov 6, 2022) Highlights include native CoClass support and a TWINPACK package from fafalone with definitions for all the standard common controls.
  • twinBASIC Update: November 13, 2022: (Nov 13, 2022) Highlights include drag and drop support, an innovative IDE feature known as "Type Hints", and a proof-of-concept twinBASIC multithreading project.
  • twinBASIC Update: November 20, 2022: (Nov 20, 2022) Highlights include several bug fixes, a new method to clear the debug console, and a discussion about the difference between Drag and OLEDrag methods.
  • twinBASIC Update: November 27, 2022: (Nov 27, 2022) Highlights include support for graphical buttons, OLE drag and drop, and some exciting news about the upcoming release of Rubberduck VBA 3.0.
  • twinBASIC Update: December 4, 2022: (Dec 4, 2022) Highlights include initial support for importing VB6 forms with ActiveX controls, GoSub syntax support, and context-sensitive custom help support.
  • twinBASIC Update: December 11, 2022: (Dec 11, 2022) Updates include a version 1 release date, twinBASIC roadmap update, and several bug fixes.
  • twinBASIC Update: December 18, 2022: (Dec 18, 2022) Highlights include initial support for user controls, a new list view option for the form designer toolbox, and another sample twinBASIC project from fafalone.
  • twinBASIC Update: December 26, 2022: (Dec 26, 2022) Highlights include the smallest bug report in twinBASIC history, a repository of twinBASIC sample projects, and a tB-based VBA DocTest runner from Ben Clothier.
  • twinBASIC Update: January 1, 2023: (Jan 1, 2023) Highlights include a redesigned form preview button, a file watcher sample application from fafalone, and a holiday message from Wayne Phillips.
  • twinBASIC Update: January 8, 2023: (Jan 8, 2023) Highlights include .vbp UserControl import support, a twinBASIC VBCCR demo project, live variable hover tips in the IDE, and a discussion of post-v1 breaking changes.
  • twinBASIC Update: January 15, 2023: (Jan 15, 2023) Highlights include a new VBCCR-based GUI project type, a VBCCR TWINSERV package, and a discussion about support for block-level scope in twinBASIC.
  • twinBASIC Update: January 29, 2023: (Jan 29, 2023) Highlights include an updated roadmap and v1 release date, new UserControl events support, and several new tB sample projects from fafalone and Ben Clothier.
  • twinBASIC Update: February 5, 2023: (Feb 5, 2023) Highlights include a major rewrite of the ActiveX implementation, updates to two community projects, and a discussion about the business side of twinBASIC.
  • twinBASIC Update: February 12, 2023: (Feb 12, 2023) Highlights include an improved UX for selecting one control from a group of controls, an update to the ActiveX Control project type, and some IID advice.
  • twinBASIC Update: February 19, 2023: (Feb 19, 2023) Highlights include an option to customize fonts in the IDE, newly implemented OLE Drag/Drop methods and events, and a new vbNullPtr constant.
  • twinBASIC Update: February 26, 2023: (Feb 26, 2023) Highlights include a big announcement for twinBASIC in the world of Access and the release of ZoneStripper, another of fafalone's VB6 twinBASIC ports.
  • twinBASIC Update: March 5, 2023: (Mar 5, 2023) Highlights include the addition of MonthView and DatePicker controls, new methods, properties, and events, and a note about the twinBASIC splash screen.
  • twinBASIC Update: March 12, 2023: (Mar 12, 2023) Highlights include IDE bookmarks, improvements to the debugging experience, and a sampling of how twinBASIC is being used today.
  • twinBASIC Update: March 19, 2023: (Mar 19, 2023) Highlights include a compilation of 60 of twinBASIC's existing improvements over VB6, mouse scroll events, a Last Position feature, and other IDE improvements,
  • twinBASIC Update: March 26, 2023: (Mar 26, 2023) Highlights include a New Project settings dialog and a screenshot of a sample twinBASIC project showing its existing capabilities.
  • twinBASIC Update: April 2, 2023: (Apr 2, 2023) Highlights include an experimental ListView control, read-only JSON view for tbform and tbcontrol files, and a mention of twinBASIC in The Register.
  • twinBASIC Update: April 10, 2023: (Apr 10, 2023) Highlights include the addition of SendKeys support, CDecl support for certain types of API callbacks, and a vigorous discussion about possible tB namespace support.
  • twinBASIC Update: April 16, 2023: (Apr 16, 2023) Highlights include a steady dose of bug fixes and and a brief recap of twinBASIC's standing in slant.co's list of "best BASIC-like programming languages."
  • twinBASIC Update: April 23, 2023: (Apr 23, 2023) Highlights include a status update from Wayne Phillips, extended discussion of twinBASIC on two web forums, and updates to fafalone's ucExplorer control.
  • twinBASIC Update: April 30, 2023: (Apr 30, 2023) Highlights include twinBASIC's annual DevCon Vienna appearance and fafalone's ucExplorer control running in 64-bit MS Access.
  • twinBASIC Update: May 7, 2023: (May 7, 2023) Highlights include a new Access library from Ben Clothier built with twinBASIC, a project status update from Wayne, and a couple of tB mentions in Reddit.
  • twinBASIC Update: May 14, 2023: (May 14, 2023) Highlights include the return of regular twinBASIC releases, the twinBASIC Update video from Access DevCon Vienna, and multiple tB appearances on Hacker News.
  • twinBASIC Update: May 21, 2023: (May 21, 2023) Highlights include a twinBASIC port of the classic Lemmings PC game, the potential sale of Wayne's MDE conversion service, and a mention in the 8bitnews Newsletter.
  • twinBASIC Update: May 28, 2023: (May 28, 2023) Highlights include a new home for twinBASIC documentation (docs.twinbasic.com) and an update on twinBASIC's slant.co language ranking.
  • twinBASIC Update: June 4, 2023: (Jun 4, 2023) Highlights include a search option to match whole words only, some handy ways to generate GUIDs, and a clever way to deploy and register custom ActiveX controls.
  • twinBASIC Update: June 11, 2023: (Jun 11, 2023) Highlights include a new target release date for version 1, an accompanying roadmap update, and support for Control Arrays.
  • twinBASIC Update: June 18, 2023: (Jun 18, 2023) Highlights include bug fixes related to timer events, argument/property handling, and IntelliSense, plus a screenshot of a simple browser written in twinBASIC.
  • twinBASIC Update: June 25, 2023: (Jun 25, 2023) Highlights include experimental data-binding support, a new Q&A channel in the twinBASIC Discord server, and coming 64-bit support for Kr00l's VBFlexGrid control.
  • twinBASIC Update: July 2, 2023: (Jul 2, 2023) Highlights include support for vbaObjAddRef, improvements to the Problems pane, and twinBASIC moving up the BASIC-like language rankings.
  • twinBASIC Update: July 9, 2023: (Jul 9, 2023) Highlights include a supercharged Collection class (that also replaces Scripting.Dictionary for most use cases) and several exciting community projects.
  • twinBASIC Update: July 16, 2023: (Jul 16, 2023) Highlights include twinPACK publisher support in the new IDE, indenting of pasted code, inline code hints, and the release of a 64-bit tB version of Kr00l's FlexGrid control.
  • twinBASIC Update: July 23, 2023: (Jul 23, 2023) Highlights include an update on Wayne's LLVM progress and a demonstration of how to integrate the Windows Ribbon Framework into twinBASIC.
  • twinBASIC Update: July 30, 2023: (Jul 30, 2023) Highlights include experimental code optimization via LLVM (boosting performance and reducing executable size) and a new Discord LLVM channel.
  • twinBASIC Update: August 6, 2023: (Aug 6, 2023) Highlights include a big boost to IntelliSense performance, a "Paste Code as Comment" shortcut key, and discussion around inline assembly support.
  • twinBASIC Update: August 13, 2023: (Aug 13, 2023) Highlights include brand new add-in support for the twinBASIC IDE, plus a short Q&A about setting an application icon in twinBASIC.
  • twinBASIC Update: August 20, 2023: (Aug 20, 2023) Highlights include support for embedding Monaco editors and Chart.js in IDE tool windows, plus the tB port of a C++ 3D image rendering sample project.
  • twinBASIC Update: August 27, 2023: (Aug 27, 2023) Highlights include multiple improvements to the debug console, including performance improvements that affect the entire IDE.
  • twinBASIC Update: September 3, 2023: (Sep 3, 2023) Highlights include two new twinBASIC IDE Addin samples, a Property Sheet demo project from fafalone, and a brief discussion of DPI scaling.
  • twinBASIC Update: September 10, 2023: (Sep 10, 2023) Highlights include a global search IDE addin sample, addin extensibility access to the filesystem, and a discussion about inheritance in twinBASIC.
  • twinBASIC Update: September 17, 2023: (Sep 17, 2023) Highlights include inline editor widget support for tB IDE addins, a sample TODO addin, keyboard shortcut registration, and a preview of a UserControl Builder addin.
  • twinBASIC Update: September 24, 2023: (Sep 24, 2023) Highlights include a twinBASIC services status bar, a tB implementation of the Geometrize software, and a user activity monitoring class from fafalone.
  • twinBASIC Update: October 1, 2023: (Oct 1, 2023) Highlights include the release of the first community-built twinBASIC IDE Add-in and an update to fafalone's cTaskDialog project to add 64-bit VBA support.
  • twinBASIC Update: October 8, 2023: (Oct 8, 2023) Highlights include debug-time evaluation of expressions on mouse hover and an x64-compatible version of sokinkeso's tB IDE addin, Usercontrol Builder.
  • twinBASIC Update: October 15, 2023: (Oct 15, 2023) Highlights include a new TextHint property for text boxes, an easier way to apply license keys, and updates to the official twinBASIC wiki documentation.
  • twinBASIC Update: October 22, 2023: (Oct 22, 2023) Highlights include experimental vbWatchdog support, a CheckBitness utility from fafalone, and a VB6 OSInfo class ported to twinBASIC.
  • twinBASIC Update: October 29, 2023: (Oct 29, 2023) Highlights include two new methods for tB IDE Add-in development and an upcoming rewrite of the standard library implementation.
  • twinBASIC Update: November 5, 2023: (Nov 5, 2023) Highlights include a major overhaul of twinBASIC's internals, support for "destructuring assignment", and a VBA UserForm to tB converter.
  • twinBASIC Update: November 12, 2023: (Nov 12, 2023) Highlights include more VB6-like IntelliSense added to the debug console, upcoming help improvements, and a twinBASIC follower milestone.
  • twinBASIC Update: November 19, 2023: (Nov 19, 2023) Highlights include an overhaul of the IntelliSense system, a project to get full paths of all running processes, and a new Kernel Mode Support Package.
  • twinBASIC Update: November 26, 2023: (Nov 26, 2023) Highlights include foundational work on the forthcoming Edit & Continue feature and a new wiki page documenting the twinBASIC compiler constants.
  • twinBASIC Update: December 3, 2023: (Dec 3, 2023) Highlights include an update on "Edit & Continue" development progress, a new Auto-Save tB add-in, and the discovery of twinBASIC's potential downfall.
  • twinBASIC Update: December 10, 2023: (Dec 10, 2023) Highlights include an extended discussion on the possibility of open-sourcing some or all of twinBASIC in the future, plus a Linebreak Repair utility from fafalone.
  • twinBASIC Update: December 17, 2023: (Dec 17, 2023) Highlights include a new twinBASIC project to allow easy input filtering of text boxes and the renaming of the tbShellLib project to reflect its expanded scope.
  • twinBASIC Update: December 24, 2023: (Dec 24, 2023) Highlights include an updated twinBASIC roadmap, a sneak peek at upcoming IDE menu and docking improvements, and RadioMan - a new tB project from fafalone.
  • twinBASIC Update: December 31, 2023: (Dec 31, 2023) A quiet week of development with a fascinating conversation on Wayne's decision to write a custom compiler rather than transpile twinBASIC into C/C++.
  • twinBASIC Update: January 14, 2024: (Jan 14, 2024) Highlights include a dedicated twinBASIC forum at VBForums, new teaser images from this Friday's upcoming beta release, and several projects from fafalone.
  • twinBASIC Update: January 21, 2024: (Jan 21, 2024) Highlights include a minor delay of the long-awaited twinBASIC IDE update, a new twinBASIC FAQ page, and several new and updated tB projects from fafalone.
  • twinBASIC Update: January 28, 2024: (Jan 28, 2024) Highlights include ... ah, never mind. The new twinBASIC IDE is here!!!! Plus: static linking, experimental type inference, 20-30% reductions in exe sizes, and more!
  • twinBASIC Update: February 4, 2024: (Feb 4, 2024) Highlights include two newly commissioned features (BigNumber support and a web page IDE panel) and a tB IDE comment/uncomment add-in.
  • twinBASIC Update: February 11, 2024: (Feb 11, 2024) Highlights include the option to restore a traditional title bar to the twinBASIC IDE, a new lifetime license offer, and a lively discussion about attribute syntax.
  • twinBASIC Update: February 18, 2024: (Feb 18, 2024) Highlights include progress on the IDE memory leaks, object models for automating Excel's Solver, and discussion regarding a taskbar icon monitor issue.
  • twinBASIC Update: February 25, 2024: (Feb 25, 2024) Highlights include reduced IDE memory consumption, two new projects from fafalone, and jpbro's clever solution to the biggest twinBASIC dev bottleneck.
  • twinBASIC Update: March 3, 2024: (Mar 3, 2024) Highlights include rebranding the Problems panel as "Diagnostics" with expanded functionality, placeholders for the Description attribute, and tB v1 blockers.
  • twinBASIC Update: March 10, 2024: (Mar 10, 2024) Highlights include a new Trace Mode debugging feature, improved IntelliSense performance, and details of my upcoming twinBASIC presentation at Access DevCon.
  • twinBASIC Update: March 17, 2024: (Mar 17, 2024) Highlights include independent TypeLibrary versioning and a detailed explanation of the new Runtime Tracing feature.
  • twinBASIC Update: March 24, 2024: (Mar 24, 2024) Highlights include the return of support for twinBASIC IDE Add-ins, global search in the IDE, two new projects from fafalone, and an eye-opening twinBASIC poll.
  • twinBASIC Update: April 1, 2024: (Apr 1, 2024) Highlights include dozens of bug fixes, a new MsgBox builder IDE addin, and a GitHub project for automatically setting PE image header properties.
  • twinBASIC Update: April 7, 2024: (Apr 7, 2024) Highlights include the ability to embed code in tB IDE keyboard shortcuts, a consolidated page of sokinkeso's tB IDE addins, and a new App object package.
  • twinBASIC Update: April 14, 2024: (Apr 14, 2024) Highlights include improved performance and stability, error codes for compile errors, a sneak peek at sokinkeso's External Tools plugin, and version control for twinBASIC.
  • twinBASIC Update: April 21, 2024: (Apr 21, 2024) Highlights include word wrap toggling, twinBASIC returns to Vienna, a WinDevLib quick start guide, and a major milestone as twinBASIC now runs PhotoDemon!
  • twinBASIC Update: April 29, 2024: (Apr 29, 2024) Highlights include my DevCon Vienna twinBASIC recording, massive memory reduction in the IDE, and exciting news regarding the VB6 PhotoDemon project.
  • twinBASIC Update: May 6, 2024: (May 6, 2024) Highlights include support for the [NonBrowsable] attribute for ActiveX controls and discussions on Implements Via and ByVal/ByRef for tB vs. VB6 events.
  • twinBASIC Update: May 13, 2024: (May 13, 2024) Highlights include reduced RAM usage by the compiler and an update to fafalone's Drag & Drop Demo project.
  • twinBASIC Update: May 20, 2024: (May 20, 2024) Highlights include the long-awaited arrival of MDI forms, OS targeting, an animated GIF project, and the first commercially available project built with twinBASIC.
  • twinBASIC Update: May 29, 2024: (May 29, 2024) Highlights include a new ImageList control, Opacity and TransparencyKey properties, and a new Sample Project demonstrating these added features.
  • twinBASIC Update: June 5, 2024: (Jun 5, 2024) Highlights include a new experimental Project Explorer IDE panel, a proposal for "Unsafe" block syntax, and tB-compatible sample code for getting the external IP.
  • twinBASIC Update: June 17, 2024: (Jun 17, 2024) Highlights include a twinBASIC for Applications proof of concept (🤯), a new Tab Order IDE addin, and a Memory List Manager sample project.
  • twinBASIC Update: June 24, 2024: (Jun 24, 2024) Highlights include a new multi-line caption-editing dialog, implementation of several missing VB6 control properties, and advanced pointer handling via CType(Of ).
  • twinBASIC Update: July 3, 2024: (Jul 3, 2024) Highlights include initial Printer object support, a new PDF Merge utility from fafalone, and an answer to one redditor's burning question.
  • twinBASIC Update: July 8, 2024: (Jul 8, 2024) Highlights include a sneak preview of a coming report writer, plus support for accessing the Printers collection by printer name.
  • twinBASIC Update: July 15, 2024: (Jul 15, 2024) Highlights include another week of progress on the upcoming report writer, including another sneak peek video of the feature.
  • twinBASIC Update: July 22, 2024: (Jul 22, 2024) Highlights include two blockbuster features that Access developers will instantly recognize: an Access-style report writer and a lightweight expression service.
  • twinBASIC Update: July 29, 2024: (Jul 29, 2024) Highlights include in-place editing of label captions and a mini toolbar for quick formatting of font properties for form and report controls.
  • twinBASIC Update: August 5, 2024: (Aug 5, 2024) Highlights include improved array features (better non-Variant support, compile-time type checking, and assignment syntax) and a command line arg handling discussion.
  • twinBASIC Update: August 13, 2024: (Aug 13, 2024) Highlights include predefined caption/text when adding controls, a progress update on form control implementation, and how to set the icon for your tB apps.
  • twinBASIC Update: August 19, 2024: (Aug 19, 2024) Highlights include...a periodic reminder that the twinBASIC project typically keeps an insane release frequency.
  • twinBASIC Update: August 25, 2024: (Aug 25, 2024) Highlights include a couple of teasers regarding forthcoming twinBASIC releases, a possible VIP "Silver" package, and bug fixes for fafalone's WinDevLib twinPACK.
  • twinBASIC Update: September 2, 2024: (Sep 2, 2024) Highlights include bated breath, cautious optimism, sayings of sooth, and pithily proffered prognostications.
  • twinBASIC Update: September 8, 2024: (Sep 8, 2024) Highlights include new releases focused on improved performance and VB6/VBA compatibility, along with Microsoft's latest attack on its own tech stack.
  • twinBASIC Update: September 16, 2024: (Sep 16, 2024) Highlights include support for the .Image property on Form/PictureBox/MDIForm objects, two new static analysis warnings, and inline assembly language support.
  • twinBASIC Update: September 23, 2024: (Sep 23, 2024) Highlights include big plans for the future of UDTs in twinBASIC and an in-person presentation on twinBASIC at Oxford University in England.
  • twinBASIC Update: September 30, 2024: (Sep 30, 2024) Highlights include an updated 12-month roadmap, initial delegate support, improvements to AddressOf, and a facelift for twinbasic.com.
  • twinBASIC Update: October 7, 2024: (Oct 7, 2024) Highlights include a SQLite COM wrapper twinPACK from Krool, tB documentation updates, a WinDevLib bug fix release, and Got/Lost Focus behavior fixes.
  • twinBASIC Update: October 14, 2024: (Oct 14, 2024) Highlights include a 64-bit Quick Rename Shell Extension project from fafalone and perpetual licenses offered to longtime early subscribers.
  • twinBASIC Update: October 22, 2024: (Oct 22, 2024) Highlights include a new tB-based Magnifier Windows utility from fafalone, a project status update from Wayne, and a metaphor involving rubber ducks, hippos, and oxpeckers.
  • twinBASIC Update: October 29, 2024: (Oct 29, 2024) Highlights include more info on my upcoming visit to Oxford University to present the latest twinBASIC developments, including twinBASIC for Applications (tBA).
  • twinBASIC Update: November 5, 2024: (Nov 5, 2024) Highlights include a twinBASIC-built utility to strip the Mark of the Web (MOTW) from files and an upcoming feature to check packages for updates.
  • twinBASIC Update: November 12, 2024: (Nov 12, 2024) Highlights include a video player sample project from fafalone, a trick for exporting .tlb files from tB builds, and a recap of twinBASIC highlights from 2024.
  • twinBASIC Update: November 18, 2024: (Nov 18, 2024) Highlights include step-by-step instructions for building PhotoDemon with twinBASIC, a timeline update for the next BETA release, and the passing of a BASIC icon.
  • twinBASIC Update: November 26, 2024: (Nov 26, 2024) Highlights include my presentation to the UK Access User Group and a .CAB file packaging utility built with twinBASIC by HackerVlad.
  • twinBASIC Update: December 2, 2024: (Dec 2, 2024) Highlights include a sale on *perpetual* twinBASIC licenses, a tB OCR project, a no-cloud tB Chat LLM project, and a preview of the release notes for the next BETA.
  • twinBASIC Update: December 9, 2024: (Dec 9, 2024) Highlights include a proof of concept Excel XLL add-in written in twinBASIC, the TBMAN toolkit twinPACK, and a successful port of the OrdoPdfReader OCX.
  • ["Under 100" tag page]: Show all articles with the tag "Under 100" (including those where "Under 100" is a secondary tag).
  • ["Unicode" tag page]: Show all articles with the tag "Unicode" (including those where "Unicode" is a secondary tag).
  • Unicode MsgBox Revisited: (Sep 15, 2022) A small improvement to my Unicode-friendly MsgBox and a handy trick for avoiding compile errors across Word/Excel/Access/etc.
  • ["UX" tag page]: Show all articles with the tag "UX" (including those where "UX" is a secondary tag).
  • ["VBA" tag page]: Show all articles with the tag "VBA" (including those where "VBA" is a secondary tag).
  • High Wire Walking With No Net: (Sep 4, 2020) In those early days, our method of "source control" was making regular copies of the front-end database and appending a date to the filename. This was....less than ideal. The problem is best illustrated with a quick story.
  • An Homage to Mercurial: (Sep 7, 2020) I believe without a doubt--even knowing what I know now--that I made the right decision at the time. If I could go back to 2009 and do it over again, I would still go with Mercurial. If I were starting from scratch in 2020...that's a different story.
  • No Longer Set: (Sep 8, 2020) Using version control is the most impactful change you can make to improve the quality of your Microsoft Access applications. Here is a quick list of just some of the benefits you gain using version control.
  • The Starting Point: (Sep 9, 2020) Before we can use a DVCS with our Access application, we need to convert the binary Access file into a series of text files. The best place to start (and where my journey began) is with this StackOverflow answer.
  • No Longer Set: (Sep 10, 2020) How do we save database properties to text? By iterating through the database's .Properties collection, of course. Here is some sample code...
  • Tables to Text: Do it for the DVCS!: (Sep 13, 2020) Anything that can lead to a bug in your software belongs in version control. That includes local tables with design-time data.
  • Referencing references: (Sep 14, 2020) While we can use the VBA user interface to display the references, we can't rely on that approach if we want to automate exporting our Access binary file to text files. Luckily, there is a solution.
  • Tracking Table Structure Changes: (Sep 15, 2020) Another potential source of bugs is changes to the structures of our tables. This includes both local tables and linked tables that reside in our back-end.
  • Exporting Queries for Version Control: (Sep 16, 2020) SaveAsText will export queries to text files, but calling those files "human-readable" is a stretch.
  • Putting It All Together: (Sep 17, 2020) I expanded on the original decompose.vbs script. The code below is the culmination of more than 50 individual changes and tweaks over 10+ years.
  • Access Version Control: My Philosophy: (Sep 18, 2020) These rules are intended as a guiding philosophy. If I'm getting closer to meeting this vision, I know I'm moving in the right direction.
  • Scraps of Wood and Code: (Oct 13, 2020) Resisting the packrat mentality.
  • Migrating Mercurial: (Nov 25, 2020) I had to update the settings file for 120 Mercurial repositories. I saved hours of tedium using a regex in the "Find in Files" feature of Notepad++.
  • Tracking Schema Changes: (Jan 28, 2021) If it can cause a bug in your software, you should be tracking it in version control. Database schema changes absolutely fall into that category.
  • Peace of Mind from Version Control: (Mar 9, 2021) "Do you want to save your changes?" No, not if I just added temporary debugging code. But, Yes, if I also added production code. What to do?
  • It's All About the Diff: (Mar 17, 2021) How can you figure out what you changed on a form when you can't remember changing anything on that form? Version control, of course.
  • Reverting Unwanted Changes: (Mar 18, 2021) Using Version Control in Access is like having a time machine that makes it easy to undo design mistakes. Here's a quick overview of the process.
  • A Quick, Free Way to Try Version Control with Microsoft Access: (Jul 9, 2021) Curious about getting started with version control in Microsoft Access, but don't want to commit a lot of time or money? This could be just the solution for you.
  • Learn to Love Text-Based Version Control with "Highlights for Children": (Jul 29, 2021) Why use text-based version control for visual objects like forms and reports? I'll tell you why, but first, find all the differences between these two pictures...
  • Make Your Access App More Resilient with Version Control: (Sep 25, 2023) Reassembling the pieces of a fragile system is a fool's (horse's?) errand. Turning back the clock is a more reliable fix.
  • Git vs. Mercurial in 2024: (Jan 23, 2024) This classic article from fifteen years ago contains one of the most impressively specific (and accurate) technology predictions I've ever read.
  • Mercurial: The Road Less Traveled: (Feb 1, 2024) Unfortunately, choosing the less popular version control system has some important real-world drawbacks.
  • What's the Purpose of an Access Version Control Add-in?: (Mar 5, 2024) Access version control add-ins are not a replacement for Git, Subversion, or Mercurial.
  • Installing the Access Version Control Add-in: Step-by-Step: (Mar 6, 2024) Looking to try version control with Microsoft Access? Start here by installing Adam Waller's free and open-source Version Control Addin for MS Access.
  • Five Types of Files to Exclude From MS Access Version Control: (Mar 8, 2024) The provided sample .hgignore and .gitignore files are good starting points when setting up new Microsoft Access version control repositories.
  • Access Version Control: A Quick Start Guide: (Mar 14, 2024) With this step-by-step guide, you'll be using version control with Access in under 20 minutes.
  • Hosting Mercurial Repositories Online with Helix TeamHub: (Mar 19, 2024) Helix TeamHub is the obvious choice for Mercurial repository hosting for solo Access developers and small teams.
  • Version Control and Cloud Drives: Better Keep 'em Separated: (Apr 24, 2024) Git and Mercurial repositories don't mix well with cloud drives like OneDrive and Dropbox. Here are two alternative approaches to keep you out of trouble.
  • ["Video" tag page]: Show all articles with the tag "Video" (including those where "Video" is a secondary tag).
  • VIDEO: Modern On Off Buttons in Access: (Jul 27, 2022) I recorded a YouTube video that demonstrates how to implement the Modern On/Off button feature that I wrote about yesterday.
  • Access Job Interview Questions: (Aug 26, 2022) Richard Rost--today's most prolific creator of Microsoft Access video tutorials--has put together a great baseline of questions and answers that test your Access knowledge.
  • Access Job Interview Questions: Follow-up Q&A: (Aug 30, 2022) Topics covered include Access security best practices, "deploying" trusted locations to users, and avoiding reserved words when naming database objects.
  • VIDEO: Sorting Continuous Forms: (Sep 2, 2022) A 12-minute video that shows you how to implement my NewSort and UseHand functions for sorting continuous forms in MS Access.
  • VIDEO: "Codifying" Long Names: (Sep 12, 2022) Former Access MVP Jack Stockton translates my SQL Server "Codify()" function to work with Microsoft Access backend databases.
  • VIDEO: Design Patterns with Access: (Sep 29, 2022) "I fear not the man who has practiced 10,000 kicks once, but I fear the man who has practiced one kick 10,000 times." How Bruce Lee's advice applies to MS Access.
  • VIDEO: twinBASIC Update at DevCon Vienna 2023: (May 8, 2023) Learn about what the future of twinBASIC and Microsoft Access might look like from my Access DevCon Vienna 2023 presentation.
  • ["Watches" tag page]: Show all articles with the tag "Watches" (including those where "Watches" is a secondary tag).
  • Watch Expression: (Mar 6, 2021) A deeper than necessary dive into the exact expression evaluation behavior of the basic "Watch Expression" in VBA.
  • Break When Value Is True: (Mar 7, 2021) When debugging VBA, you can watch an expression and halt code execution as soon as it evaluates to True. Let's explore exactly how that works.
  • Break When Value Changes: (Mar 8, 2021) When debugging VBA, you can watch an expression and halt code execution whenever its value changes. Let's explore exactly how that works.
  • Week in Review: May 7, 2022: (May 7, 2022) Highlights include an IE integration article from Daniel Pineault, an Access tool from Crystal Long, and a PowerApps User Group video.
  • Week in Review: May 14, 2022: (May 14, 2022) Highlights include the Access Dataverse Connector *finally* reaching General Availability, the public release of 3 DevCon videos, and another big Access bug.
  • Week in Review: May 21, 2022: (May 21, 2022) Highlights include a Microsoft Access Roadmap update, sample code for trig functions, and a discussion about preserving Access tips of yore.
  • Week in Review: May 28, 2022: (May 28, 2022) Highlights include two new Access bugs, a modern On/Off toggle control, setting list box font colors by column, and resurrected videos from the Access forums vault.
  • Week in Review: June 4, 2022: (Jun 4, 2022) Highlights include major changes to the Access roadmap, Richard Rost's Beginner Access video course is now free, and research on developer interviews.
  • Week In Review: June 11, 2022: (Jun 11, 2022) Highlights include a better date picker control, dashboard-style gauges, and drawing shapes in Access reports.
  • Week in Review: June 18, 2022: (Jun 18, 2022) Highlights include building custom progress bars, creating organizational charts, and yet another Access bug [sigh].
  • Week in Review: June 25, 2022: (Jun 25, 2022) Highlights include an elegant solution to synchronized scrolling, a novel approach to db schema versioning, and a deep dive into recovering deleted db objects.
  • Week in Review: July 2, 2022: (Jul 2, 2022) Highlights include a deep dive into the Autoexec macro, compacting the current database via VBA, and a massive Access drawing reference.
  • Week in Review: July 9, 2022: (Jul 9, 2022) Highlights include code to activate a specific ribbon tab, a deep dive into the innards (and dangers) of multivalue fields, and--yes--more Access bugs.
  • Week in Review: July 16, 2022: (Jul 16, 2022) Highlights include 5 things NOT to do when writing code, embedding videos on Access forms, and--of course--more bugs. :-(
  • Week in Review: July 23, 2022: (Jul 23, 2022) Highlights include the latest edition of Karl Donaubauer's Access News, creating a custom splash form, and the public release of the SSMS-style "Access Studio" tool.
  • Week in Review: July 30, 2022: (Jul 30, 2022) Highlights include tips for designing Access apps for tablet use, sorting forms by combo box columns, and CUPID--an alternative to SOLID principles.
  • Week in Review: August 6, 2022: (Aug 6, 2022) Highlights include the list of Access fixes for Version 2206, a deep dive into how Access stores queries, and a rant against today's overly complicated forums.
  • Week in Review: August 13, 2022: (Aug 13, 2022) Highlights include Peter Cole's 32 to 64-bit conversion presentation, a deep dive into how Access stores queries, and a sad announcement from MVP Daniel Pineault.
  • Week in Review: August 20, 2022: (Aug 20, 2022) Highlights include Colin Riddington's Nav Pane Helper, Richard Rost's Access Developer Interview Questions, and Rick Hanson's Used Book Business Access App.
  • Week in Review: August 27, 2022: (Aug 27, 2022) Highlights include a dedicated web page for the Access Europe User Group, a Nav Pane Helper Add-in, and a deep dive into database theory.
  • Week in Review: September 3, 2022: (Sep 3, 2022) Highlights include an add-in to check Access/Windows/Office versions, a query metadata viewer, and multiple ways to change the mouse cursor in MS Access.
  • Week in Review: September 10, 2022: (Sep 10, 2022) Highlights include a major milestone for (and giveaway from) Richard Rost, a data classification guide, and an Access QR code generator.
  • Week in Review: September 17, 2022: (Sep 17, 2022) Highlights include a new YouTube channel from Daniel Pineault, modern chart reference, and form resizing and "profiles" videos.
  • Week in Review: September 24, 2022: (Sep 24, 2022) Highlights include bug fixes in Access v2208, Microsoft's new Office update strategy, creating ACCDB/ACCDE files using code, and a series on TempVars.
  • Week in Review: October 1, 2022: (Oct 1, 2022) Highlights include Pivot Tables and Pivot Charts, exporting all Access tables into Excel, and many changes to future Access User Group presentations.
  • Week in Review: October 8, 2022: (Oct 8, 2022) Highlights include using Base64 encoding to embed images in Thunderbird, seven(!) IslaDogs articles, and episode 4 of Karl Donaubauer's Access NewsCast.
  • Week in Review: October 15, 2022: (Oct 15, 2022) Highlights include changes to the Access team's development priorities, adding spell check to Access, and generating Excel charts via automation from Access.
  • Week in Review: October 22, 2022: (Oct 22, 2022) Highlights include a reserved word checker utility, executing PowerShell cmdlets from VBA, using Access in an Azure VM, and 5 types of control tips.
  • Week in Review: October 29, 2022: (Oct 29, 2022) Highlights include a data macros how-to, time zone-aware dates, automating the Access nav pane, and collapsing/expanding the ribbon.
  • Week in Review: November 5, 2022: (Nov 5, 2022) Highlights include a new Access MVP (congrats Juanjo Luna!), a deep dive into the FileSystemObject, and using UIAutomation to interact with the ribbon.
  • Week in Review: November 12, 2022: (Nov 12, 2022) Highlights include two new Access User Group recordings, a WizHook sample database and reference, and a couple of videos on macro blocking.
  • Week in Review: November 19, 2022: (Nov 19, 2022) Highlights include multiple ways to hide sensitive data, a CDO email tester, an improved SQL editor, and updates from the Access dev team.
  • Week in Review: November 26, 2022: (Nov 26, 2022) Highlights include a sneak preview of Rubberduck 3.0, multiple articles on Access keyboard shortcuts, and aligning text with monospaced fonts.
  • Week in Review: December 3, 2022: (Dec 3, 2022) Highlights include the WizHook TwipsFromFont function, an enhanced message box, and drawing dynamic meters on Access reports.
  • Week in Review: December 10, 2022: (Dec 10, 2022) Highlights include Access disappearing from the Microsoft 365 Roadmap, bug fix release 2211 details, maps, maps, and more maps.
  • Week in Review: December 17, 2022: (Dec 17, 2022) Highlights include Access's new code signing feature, rotating and scaling images, drawing snowflakes (festive!), and a BRAND NEW Access blog.
  • Week in Review: December 24, 2022: (Dec 24, 2022) Highlights include tentative dates for Access DevCon Vienna, the evils of split forms, listing complex fields, and more festive Access art from Crystal Long.
  • Week in Review: December 31, 2022: (Dec 31, 2022) Highlights include a deep dive into creating a customer follow-up database, automatic form resizing, and a risk-minimizing approach to app rewrites.
  • Week in Review: January 7, 2023: (Jan 7, 2023) Highlights include 15 tips & tricks from Karl Donaubauer, the new digital signing feature for Access databases, and how to hash a string in VBA.
  • Week in Review: January 14, 2023: (Jan 14, 2023) Highlights include using an ActiveX control to collect handwritten signatures, multiple options for getting special folders in VBA, and managing old data.
  • Weeks in Review: January 28, 2023: (Jan 28, 2023) I'm back! Highlights from the past two weeks include using web APIs in Access, Rubberduck 3.0 news, using the registry from VBA, and more on ChatGPT.
  • Week in Review: February 4, 2023: (Feb 4, 2023) Highlights include a tool to localize Access applications (coming soon) and a couple of good (if slightly off-topic) articles on management and pricing.
  • Week in Review: February 11, 2023: (Feb 11, 2023) Highlights include a video showing how to integrate charts.js in Access, calling the Windows Color Picker Dialog from VBA, and an Access CalendarMaker.
  • Week in Review: February 18, 2023: (Feb 18, 2023) Highlights include a video on the current state of Microsoft Access, closing open Access objects (reports, etc.), and using temp tables to boost performance.
  • Week in Review: February 25, 2023: (Feb 25, 2023) Highlights include a modern date-time picker proof of concept, using SQL Server views from Access, and writing code other people can read.
  • Week in Review: March 4, 2023: (Mar 4, 2023) Highlights include a trick to update parent form calculations without using subform events, translation tools in Access, and early/late binding declarations.
  • Week in Review: March 11, 2023: (Mar 11, 2023) Highlights include a deep dive into form events, optimizing queries in SQL Server, dealing with split forms, and how to embed QR codes in a Word mail merge.
  • Week in Review: March 18, 2023: (Mar 18, 2023) Highlights include automating Word to create a font list, Name AutoCorrect, horizontal continuous forms, and the new Edge-based browser control.
  • Week in Review: March 25, 2023: (Mar 25, 2023) Highlights include integrating better Access charts, a Table Analyzer and Viewer utility, SQL Server security deep dive, and opening external files and URLs from VBA.
  • Week in Review: April 1, 2023: (Apr 1, 2023) Highlights include how to find a control associated with a label, Access's surprising folder-locking behavior, and a new setting to make your database self-destruct.
  • Week in Review: April 8, 2023: (Apr 8, 2023) Highlights include a reliable way to bypass AutoExec in VBA, a Pro version of the IslaDogs Table Analyzer, and the new Rubberduck VBA Swag Shop.
  • Week in Review: April 15, 2023: (Apr 15, 2023) Highlights include drawing stoplights and dials on reports, a SQL-to-VBA-to-SQL utility, creating calendar reports, and migrating Access tables to SQL Server.
  • Week in Review: April 22, 2023: (Apr 22, 2023) Highlights include episode 5 of Karl Donaubauer's Access News video update, how to sell Access services with Juan Soto, and lightweight MVVM in VBA.
  • Week in Review: April 29, 2023: (Apr 29, 2023) Highlights include the release of the Northwind 2.0 database templates, automatic form resizing, and a deep dive into VBA events with a.p.r. pillai.
  • Week in Review: May 6, 2023: (May 6, 2023) Highlights include automating DSN-less links to SQL Server, a deep dive on the form delete events, and the full release of the new Edge-based browser control.
  • Week in Review: May 13, 2023: (May 13, 2023) Highlights include 3 publicly released videos from DevCon 2023 and an a.p.r. pillai article/Eric Blomquist video on using class modules to reduce form code.
  • Week in Review: May 20, 2023: (May 20, 2023) Highlights include a series on building a calculator in Access, selling Access solutions with Juan Soto, and creating an HTML table from an Access table.
  • Week in Review: May 27, 2023: (May 27, 2023) Highlights include a Windows registry class module from Philipp Stiefel, a deep dive into the new browser control, and Access news from the recent MVP Summit.
  • Week in Review: June 3, 2023: (Jun 3, 2023) Highlights include integrating online licensing via KeyGen, more info on the new browser control, and exploring whether AI will replace programmers.
  • Week in Review: June 10, 2023: (Jun 10, 2023) Highlights include a new batch of Access bug fixes, a video with tips for migrating a backend from Access to SQL Server, and a deep dive into the Rubberduck Style Guide.
  • Week in Review: June 17, 2023: (Jun 17, 2023) Highlights include an article about the future of AI and work, inventory management and string functions in Northwind 2.0, and form templates.
  • Week in Review: June 24, 2023: (Jun 24, 2023) Highlights include another installment of a.p.r. pillai's excellent series on streamlining form module code and videos on crosstab queries and temp tables.
  • Week in Review: July 1, 2023: (Jul 1, 2023) Highlights include an AI-focused episode of the quarterly Access News webcast, the release of Rubberduck 2.5.9, and tips on importing web data into Access.
  • Week in Review: July 8, 2023: (Jul 8, 2023) Highlights include the next installment of a.p.r. pillai's class-based form code series, AI regulations, and understanding project requirements.
  • Week in Review: July 15, 2023: (Jul 15, 2023) Highlights include the return of DevHut.net, generating hashes in VBA, bypassing the trusted domains "feature," and an eye-opening video on great interface design.
  • Week in Review: July 22, 2023: (Jul 22, 2023) Highlights include the seventh installment of a.p.r. pillai's class-based form code series, building Gantt charts in Access, and a deep dive into SQL subqueries.
  • Week in Review: July 29, 2023: (Jul 29, 2023) Highlights include Richard Rost's series on tracking account balances, barcode scanning via PowerApps, improving image quality, and a SQL formatting add-in.
  • Week in Review: August 5, 2023: (Aug 5, 2023) Highlights include the WiR debut of two new YouTube channels, monthly bug fixes from the Access team, and an introduction to using modern Combo Charts.
  • Week in Review: August 12, 2023: (Aug 12, 2023) Highlights include global error handling, creating applications in Blazor, exporting Unicode characters to text files, and validating email addresses.
  • Week in Review: August 19, 2023: (Aug 19, 2023) Highlights include a modern browser YouTube series from Daniel Pineault, the German Access Conference AEK25, and password hashing in Access.
  • Week in Review: August 26, 2023: (Aug 26, 2023) Highlights include tips to automate the new browser control, sending WhatsApp messages from Access, Python in Excel, and AI-driven help via Microsoft Q&A Assist.
  • Week in Review: September 2, 2023: (Sep 2, 2023) Highlights include a video series on Colin Riddington's Access Analyzer Pro tool, plus introductory videos on Eval, Data Macros, and the Form Detail On Paint event.
  • Week in Review: September 9, 2023: (Sep 9, 2023) Highlights include a new beta release of the Access version control addin, trends in the Access job market, and API calls to get a list of open programs.
  • Week in Review: September 16, 2023: (Sep 16, 2023) Highlights include a long-overdue update to the Access roadmap (LAA is coming!), an underrated new feature (thanks, Anders!), and a video on event-driven programming.
  • Week in Review: September 23, 2023: (Sep 23, 2023) Highlights include the death of COM/VBA in New Outlook (?!?!), a web-based image editor for Access, and a deep dive into string-building performance in VBA.
  • Week in Review: September 30, 2023: (Sep 30, 2023) Highlights include an in-person UK User Group Conference Nov 22-23, Advanced Database Design with Armen Stein, and a list of undocumented SysCmd values.
  • Week in Review: October 7, 2023: (Oct 7, 2023) Highlights include a free file manager class from Alessandro Grimaldi, an update on the forthcoming Rubberduck 3.0 VBA addin, and well-tested Access file limits.
  • Week in Review: October 14, 2023: (Oct 14, 2023) Highlights include a video on the future of Access with cameos from the Microsoft Access engineering team, a Decision Tree database, and Shared VBA Libraries.
  • Week in Review: October 21, 2023: (Oct 21, 2023) Highlights include updateable cross-tab forms with Pat Hartman, George Hepworth's Searchable Catalog project, and Richard Rost's Decision Tree database.
  • Week in Review: October 28, 2023: (Oct 28, 2023) Highlights include integrating ChatGPT into Access, the new Access Program Manager (Linda Cannon) at Access Lunchtime, and the Access team weighs in on New Outlook.
  • Week in Review: November 4, 2023: (Nov 4, 2023) Highlights include Karl's Access News update, Access learning resources, SQL Server with geography data, and the coming death of VBScript.
  • Week in Review: November 11, 2023: (Nov 11, 2023) Highlights include an update to the Access development priorities, a no-code way to highlight the current control, and a talk on classes and event-driven programming.
  • Week in Review: November 18, 2023: (Nov 18, 2023) Highlights include ChatGPT in Access, Test Driven Development, implementing dictation, and a new Office default font and theme.
  • Week in Review: November 25, 2023: (Nov 25, 2023) Highlights include the arrival of LAA in Access, adding gradients to forms, using named arguments in VBA, and multi-field search with only two controls.
  • Week in Review: December 2, 2023: (Dec 2, 2023) Highlights include a new direct SQL view feature in Access, 7 issue fixes, a new release of the Rubberduck VBA project, and how to count "checkbox" fields.
  • Week in Review: December 9, 2023: (Dec 9, 2023) Highlights include new (undocumented) functions for working with DateTimeExtended, an AI Builder for Access, and Jon Halder's TDD journey.
  • Week in Review: December 16, 2023: (Dec 16, 2023) Highlights include my recent talk on using classes with import/export specs, many 64-bit VBA guides, and a new release of Adam Waller's version control add-in.
  • Week in Review: December 23, 2023: (Dec 23, 2023) Highlights include an MZ-Tools tour from developer Carlos Quintero, an Edge browser control video series, and multi-select filtering of a continuous form.
  • Week in Review: December 30, 2023: (Dec 30, 2023) Highlights include a 4-part Oasis SVN walkthrough, 3 new Edge browser control videos, VBA class basics, and a deep dive into Access's Filter By Form feature.
  • Weeks in Review: January 13, 2024: (Jan 13, 2024) Highlights include the release of "Access on Steroids", a Rubberduck v3 update, a CDO StartTLS deep dive, and two presentations on classes in VBA.
  • Week in Review: January 20, 2024: (Jan 20, 2024) Highlights include creating Windows taskbar notifications with VBA, FMS Access tools demo, and conditionally hiding buttons on continuous forms.
  • Week in Review: January 27, 2024: (Jan 27, 2024) Highlights include an intro to star schemas, highlighting controls and columns in continuous forms, and auto-resizing subforms to fill available space.
  • Week in Review: February 3, 2024: (Feb 3, 2024) Highlights include the demystification of MS 365 Update Channels, a Rubberduck v3 status update, and adding speech recognition to Access.
  • Week in Review: February 10, 2024: (Feb 10, 2024) Highlights include the v4 release of the Access Version Control add-in, practical RegEx examples, and the top 10 advanced features of MZ-Tools.
  • Week in Review: February 17, 2024: (Feb 17, 2024) Highlights include generating hashes with the Windows API, designing datasheets in VBA, creating custom checkboxes, and hiding subforms until the parent has data.
  • Week in Review: February 24, 2024: (Feb 24, 2024) Highlights include a video review of recent Access bug fixes and 2024 priorities, hiding duplicate values in continuous forms, and an intro to form subclassing.
  • Week in Review: March 2, 2024: (Mar 2, 2024) Highlights include the configuration of multiple VBA editor themes, how to create custom form navigation buttons, and moving/resizing continuous form columns.
  • Week in Review: March 9, 2024: (Mar 9, 2024) Highlights include the new and improved Better Access Charts, combo box record lookup techniques, and an authoritative list of known MS Access bugs.
  • Week in Review: March 16, 2024: (Mar 16, 2024) Highlights include continuous form tricks from IslaDogs, hiding the Access interface, sharing data outside your local network, and a Trust Center settings deep dive.
  • Week in Review: March 23, 2024: (Mar 23, 2024) Highlights include VBA RegEx options with the coming death of VBScript, adding users to an Azure SQL database, and an interview with the author of a new Access book.
  • Week in Review: March 30, 2024: (Mar 30, 2024) Highlights include recent Access bug fixes, a zoom box replacement, a RubberDuck 3 update, and integrating ChatGPT into Access.
  • Week in Review: April 6, 2024: (Apr 6, 2024) Highlights include another episode of Karl Donaubauer's Access NewsCast, building a custom date picker, and the return of the venerable VBA add-in, Smart Indenter.
  • Week in Review: April 13, 2024: (Apr 13, 2024) Highlights include videos on the MS Access Version Control add-in, Google Maps driving directions to multiple sites, and SQL Server audit tables.
  • Week in Review: April 20, 2024: (Apr 20, 2024) Highlights include the monthly bug fix post from Microsoft, a rant against typed Arrays, polymorphism in VBA, extracting OLE images, and another modern browser bug.
  • Week in Review: April 27, 2024: (Apr 27, 2024) Highlights include an Access roadmap update (!), compiling to .accde from VBA, managing SQL Server migrations, and SQL Express backups and restores.
  • Week in Review: May 4, 2024: (May 4, 2024) Highlights include the public release of two DevCon Vienna presentations, sending emails via REST API, and how to zip and unzip files in VBA.
  • Week in Review: May 11, 2024: (May 11, 2024) Highlights include preview videos of two new upcoming Access features, how to create billing statements, and using Graph REST API to create Outlook.com events.
  • Week in Review: May 18, 2024: (May 18, 2024) Highlights include bug fixes from Microsoft, the Access Italy User Group launch, migrating foreign keys with SSMA, and MS Access usage numbers.
  • Week in Review: May 25, 2024: (May 25, 2024) Highlights include a new place to chat about Access, the "Clean Project" feature of MZ-Tools, and the impact of VBScript deprecation on VBA developers.
  • Week in Review: June 4, 2024: (Jun 4, 2024) Highlights include text box hints, tips on selling Access services, using the Graph REST API, and an open-source project to decompile .accde files.
  • Week in Review: June 8, 2024: (Jun 8, 2024) Highlights include a deep dive into ImEx DataTask specs, processing credit cards in Access via PayPal, 4 pricing techniques, and two new features in the Beta channel.
  • Week in Review: June 15, 2024: (Jun 15, 2024) Highlights include the pros and cons of fixed price and hourly billing, troubleshooting Access applications, and modernizing the Access interface.
  • Week in Review: June 22, 2024: (Jun 22, 2024) Highlights include a new bug causing crashes in Access version 2405, a primer on integrating ImageMagick into Access, and a new VBA IDE on the horizon(?!).
  • Week in Review: June 29, 2024: (Jun 29, 2024) Highlights include data analysis tips and techniques from MVP Luke Chung, a modern VBA-based slider control, and a wrapper class template wizard.
  • Week in Review: July 6, 2024: (Jul 6, 2024) Highlights include a better way to see your queries, adapting your Access apps to improve gender/sex inclusivity, and a plea to Microsoft to keep VBScript.
  • Week in Review: July 13, 2024: (Jul 13, 2024) Highlights include a talk on enhancing message boxes and forms, fun with text boxes, resizing list box columns to fit the content, and a deep dive into New Outlook.
  • Week in Review: July 20, 2024: (Jul 20, 2024) Highlights include my VBA logging framework, a visual explanation of bubble sort, and how to properly relate students and parents in a relational database.
  • Week in Review: July 27, 2024: (Jul 27, 2024) Highlights include using a framework in Access, one Redditor's quixotic quest for an Access replacement, and localization efforts leading to British waterautumns.
  • Week in Review: August 3, 2024: (Aug 3, 2024) Highlights include a tablet-friendly UI technique, fetching current weather via a free web API, and a text file logger for my VBA logging framework.
  • Week in Review: August 10, 2024: (Aug 10, 2024) Highlights include a free tool for building database diagrams, an intro to SaveAs/LoadFromText, and a showdown between hourly billing and value-based pricing.
  • Week in Review: August 17, 2024: (Aug 17, 2024) Highlights include an intro to treeview controls, working with the Windows Registry, Access best practices, and understanding VBA libraries.
  • Week in Review: August 24, 2024: (Aug 24, 2024) Highlights include using curl to download from the web, using PowerShell to send emails, exporting an Access query to a Word table, and kicking all users out of SQL Server.
  • Week in Review: August 31, 2024: (Aug 31, 2024) Highlights include primers on two new Access features (the Monaco SQL Editor and Modern Chart Improvements), using curl to FTP from VBA, and when to use Access vs. Excel.
  • Week in Review: September 7, 2024: (Sep 7, 2024) Highlights include a new bug causing msaccess.exe to hang on exit, how to export to PDF/A from Access, and the launch of an Access "developer research panel."
  • Week in Review: September 14, 2024: (Sep 14, 2024) Highlights include runtime ribbon updates, locking records in continuous forms, FTP operations via curl, and the inaugural meeting of the Australia Access User Group.
  • Week in Review: September 21, 2024: (Sep 21, 2024) Highlights include the relaunch of the UK Access User Group, working with the MS Graph API from VBA, and advanced interactive Gantt chart techniques.
  • Week in Review: September 28, 2024: (Sep 28, 2024) Highlights include adding a multi-file drag-and-drop control to your Access forms, improved control tips, and accessing the call stack at runtime with vbWatchdog.
  • Week in Review: October 5, 2024: (Oct 5, 2024) Highlights include the official release of the new modern chart feature, the release of Access 2024, and dynamically loading a DLL without registering it first.
  • Week in Review: October 12, 2024: (Oct 12, 2024) Highlights include disabling shortcut menus on reports, drag and drop with Alessandro Grimaldi, and single sign-on cached ODBC connections.
  • Week in Review: October 18, 2024: (Oct 19, 2024) Highlights include a deep dive into parentheses in VBA, ChatGPT's new canvas feature, and the official bug fix list for Access versions 2408 and 2409.
  • Week in Review: October 26, 2024: (Oct 26, 2024) Highlights include a video intro to the new Modern Charts feature, combination query techniques, and handling bit fields in SQL Server.
  • Week in Review: November 2, 2024: (Nov 2, 2024) Highlights include the Monaco SQL Editor release, TDD implementation techniques, intro to Cross Joins in SQL, and the inaugural meeting of the Access Beginners User Group.
  • Week in Review: November 9, 2024: (Nov 9, 2024) Highlights include updated development priorities from the Access team, adding a row number to queries, and a treasure trove of VBA content at Awesome VBA.
  • Week in Review: November 16, 2024: (Nov 16, 2024) Highlights include measuring the height of CanGrow controls, exporting an Access chart to PNG/GIF/JPG, building a photo cataloguer, and tabbing to the form footer.
  • Week in Review: November 23, 2024: (Nov 23, 2024) Highlights include a new episode of Access News from Karl Donaubauer, a video walkthrough of the new Monaco SQL Editor, and a form resizing solution.
  • Week in Review: November 30, 2024: (Nov 30, 2024) Highlights include key insights on Access-to-SQL Server migration, the pros and cons of the new Monaco SQL Editor, and practical VBA tutorials for dates and combo boxes.
  • Week in Review: December 7, 2024: (Dec 7, 2024) Highlights include critical info for the migration to New Outlook, a detailed Access image gallery tutorial, and perspectives on pair programming benefits.
  • ["WizHook" tag page]: Show all articles with the tag "WizHook" (including those where "WizHook" is a secondary tag).

All original code samples by Mike Wolfe are licensed under CC BY 4.0