Archive Archive Collection: Nothing 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...
Archive Archive Collection: SQL Server 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 Archive Collection: Fluent Interfaces 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 Archive Collection: Quick Tips 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.
twinBASIC Weekly Update twinBASIC Update: May 29, 2024 Highlights include a new ImageList control, Opacity and TransparencyKey properties, and a new Sample Project demonstrating these added features.
Business Choosing and Executing a Strategy: A 4-Step Approach Forget the military analogies. What do strategy, operations, and tactics look like inside a software development company?
Business Tactics vs. Operations vs. Strategy Want to build a successful long-term business? Take the time to understand these concepts (and apply them in the right order!).
Week in Review Week in Review: 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.
Commentary Will OfficeScripts Replace VBA? As always, reports of VBA's demise are greatly exaggerated.
Announcement Microsoft Announces End of RegEx Support for VBA We finally have an official timeline for when Microsoft will be dropping support for VBScript--and what impact that will have on VBA developers.
Hidden Features Three Reasons to Use Named Arguments in VBA This relatively unknown (and massively underused) syntax can make your VBA code much more readable in certain situations.
COM Invisible Instances of Office Applications: Who is to Blame? These two words can help you determine whether a hanging copy of Word, Excel, Access, or Outlook is a bug in Office...or a problem with your own VBA code.
twinBASIC Weekly Update twinBASIC Update: 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.
Week in Review Week in Review: 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.
Bug Alert Bug Alert: Scroll Wheel Causes Annoying Ding Did you ever notice Microsoft Access occasionally "dings" when you scroll with the mouse wheel in datasheets and continuous forms? You're not going crazy!
Commentary How Many People Use Microsoft Access? Anecdotal estimates vary wildly. After scouring the internet, I've only found one (semi-) official number. And it's probably a lot higher than you think.
Announcement Sun, Sand, and Access: The 2024 Developer Conference in Valencia, Spain The key to a great conference is a great host. Stories from my time at the 2023 MVP Summit with Juanjo Luna show he's the perfect man for the job.
Defensive Programming "Hiding" Global Data in VBA How to implement Steve McConnell's sage advice for handling global data, with techniques for both global constants and global variables.
twinBASIC Weekly Update twinBASIC Update: May 13, 2024 Highlights include reduced RAM usage by the compiler and an update to fafalone's Drag & Drop Demo project.
Week in Review Week in Review: 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.
DevCon Sneak Peek: Modern Access Charts A slew of new chart options is coming soon to Microsoft Access. Check out this video excerpt from DevCon Vienna 2024 to learn more.
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.