Week in Review Week in Review: July 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.
Commentary The Curse of Knowledge Even the world's worst programmer knows more about programming than most small business owners or department managers.
Deployment Creating Pre-packaged Software with Microsoft Access Microsoft Access is a poor choice for creating pre-packaged software applications. But does it really have to be that way?
Professional Development $5,999: Microsoft's Insane Price for Access 2013 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.
Tools Changing Internet Explorer Options in IE Mode of Microsoft Edge Did you try to change Internet Explorer options from IE Mode in Edge only to realize that you can't get to them? Luckily, there's an easy workaround.
twinBASIC twinBASIC Weekly Updates The twinBASIC weekly updates now have their own dedicated tag on nolongerset.com, making it easier to find the other twinBASIC articles.
twinBASIC Weekly Update twinBASIC Update: July 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.
Week in Review Week in Review: July 16, 2022 Highlights include 5 things NOT to do when writing code, embedding videos on Access forms, and--of course--more bugs. :-(
Code Library IMPROVED: SelectedListBoxItems() Function A clearer and (very slightly) more performant version of my SelectedListBoxItems function.
Code Library SelectedListBoxItems() Function It's not difficult to get the selected items from a multi-select list box, but it is tedious. This function makes it simple and easy.
Bug Alert WARNING: Do NOT Declare DAO Fields As Field2, Field3, etc. While declaring DAO Field objects as Field2 will get you additional IntelliSense, it comes at the risk of breaking working code when MS releases a new Field type.
Code Library 3 Ways to Get and Set the TitleBar Text for an MS Access Application Here are three ways to set the Application Title for an MS Access application. My preferred method allows getting and setting with a single line of code.
Code Library clsApp: My Application-Wide MS Access Singleton Class Module I use many class modules in my applications, but this is the one I cannot live without.
twinBASIC Weekly Update twinBASIC Update: July 10, 2022 Highlights include new shape controls, code-signed twinBASIC IDE and compiler executables, and twinBASIC's first appearance on HackerNews.
Week in Review Week in Review: July 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.
Deployment Distributing One-Time Data "Hot Fixes" Rolling out changes to *production data* when you don't have direct access to that data can be tricky. This tip makes the process easier.
Announcement Microsoft Backtracks (Temporarily?) on Policy to Block All Macros with Mark of the Web Microsoft official announces in blog comments (!) that they are rolling back their recently implemented VBA-blocking policy.
Presentations Building Ribbons in Code A list of resources and further reading to go with my Access User Group presentation on Building Ribbon Interfaces in Code.
Reports Access Shape Drawing Reference With a bit of creativity, you can draw just about anything on an Access report. Everything you need to know is in Crystal Long's definitive guide.
twinBASIC Weekly Update twinBASIC Update: July 3, 2022 Highlights include added support for the VB6 `End` statement, shape controls, and double-click to change property values in the IDE.
Week in Review Week in Review: July 2, 2022 Highlights include a deep dive into the Autoexec macro, compacting the current database via VBA, and a massive Access drawing reference.
Hidden Features VBA Immediate Window Line and Character Limits Don't take my word for it (or anyone else's on the internet, for that matter). Prove the limits to yourself with some simple VBA.
Announcement Office Apps Won't Run on Windows Server After October 2025 Earlier this month, Microsoft quietly announced the end of support for running (most) Office apps on Windows Server at the end of 2025.
Presentations twinBASIC en EspaƱol My presentation on twinBASIC to the Spanish Access User Group is now available on YouTube. Go check it out!