DevCon Sneak Peek: Monaco SQL Editor for MS Access The VS Code editing experience is on its way to the Microsoft Access SQL editor. Get an early look at this exciting upcoming feature.
SQL Server Creating a Header Row in Excel from an ADO Recordset In this followup to my ADO .NextRecordset article, we explore how to create Excel column headers from recordset field names.
twinBASIC Weekly Update twinBASIC Update: 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.
Week in Review Week in Review: 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.
SQL Server How to Use the ADO NextRecordset Method The ADO .NextRecordset method allows you to handle multiple result sets from a single SQL Server stored procedure.
Commentary Premature Declaration Redux Let's revisit the argument about whether to declare variables at the top of a procedure or closest to first use. We'll ask ChatGPT to make the best case for each position.
Quick Tip Quick Tip: Instant Find in the VBA IDE Somehow I went more than 20 years writing code in VBA without knowing about this handy shortcut key.
Presentations DevCon Vienna 2024 Public Session Recordings Check out the recordings of my twinBASIC Update and Colin Riddington's Advanced Form Designs from Access DevCon Vienna 2024.
twinBASIC Weekly Update twinBASIC Update: April 29, 2024 Highlights include my DevCon Vienna twinBASIC recording, massive memory reduction in the IDE, and exciting news regarding the VB6 PhotoDemon project.
Week in Review Week in Review: April 27, 2024 Highlights include an Access roadmap update (!), compiling to .accde from VBA, managing SQL Server migrations, and SQL Express backups and restores.
Deployment HOW TO: Compile to .accde or .mde From the Command Line "The Joel Test" requires that you can "make a build in one step." With these instructions, you can create an .accde from an .accdb without even opening Access.
Code Library CompileCurrentAccessApp(): Use VBA to Create an ACCDE or MDE of the Currently Open Access File This function allows you to create an .accde or .mde file based on your current Access file with a single press of the F5 key.
Version Control Version Control and Cloud Drives: Better Keep 'em Separated 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.
Commentary Thomas Jefferson's Accidental Programming Advice Premature declaration is nothing to be embarrassed about. It can happen to anyone. You don't want to make a habit of it, though.
Bug Alert Bug Fix: RefreshLink A fix for an error that impacted some users with linked SQL Server tables was announced in Microsoft's latest monthly bug fix roundup.
twinBASIC Weekly Update twinBASIC Update: April 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!
Week in Review Week in Review: April 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.
Presentations DevCon 2024: Version Control with Access A list of resources and further reading for my 2024 DevCon Vienna mini-presentation on version control with Microsoft Access.
Presentations DevCon 2024: VBIDE Addin Creation with twinBASIC Links and resources from my talk today at Access DevCon Vienna 2024, Custom VBIDE Addin Creation with twinBASIC.
Commentary How to Tell the Technical Abilities of a User Without Asking How do you assess the technical abilities of someone who might not even know how to accurately assess themselves? By making the garden weed itself.
twinBASIC WinDevLib: A Better Way to Call Windows API Functions in twinBASIC Stop struggling to declare your Windows API calls in twinBASIC. Use the Windows Development Library twinPACK and let fafalone do all the hard work for you.
Bug Alert Bug Alert: InStr() in WHERE Crashes Access Using string expressions like InStr(), InStrRev(), and Replace() in the WHERE clause of a query can crash Access in certain recent releases.
twinBASIC Weekly Update twinBASIC Update: April 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.
Week in Review Week in Review: April 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.
COM How VBA IDE Addins Get Loaded From the Windows Registry A deep dive into how VBA IDE addins get loaded from the Windows Registry to help you avoid getting stuck in DLL hell.