Code Library ShiftDate() Function: Intelligent Date Adjustments The ShiftDate() function provides intelligent date handling for your application by helping preserve month-end dates.
Code Library ptReplaceDeclaredValues(): A VBA Function to Update SQL in Pass-Through Queries Use this function to reliably replace declared values in a pass-through query.
Quick Tip Quick Tip: Preventing Accidental Double-Clicks Pop quiz, hotshot: What would happen if a user double-clicked every button in your Access application? Would there be any unintended consequences?
Reader Challenge Logic Puzzle Solution Part 2: Testing the neighborhood Class Module In part 2 of my Access solution for the five-house logic problem, we test the neighborhood class module.
Reader Challenge Logic Puzzle Solution Part 1: The oNeighborhood Class Module In part 1 of my Access solution for the five-house logic problem, I demonstrate the class module I used to model a neighborhood configuration.
twinBASIC Weekly Update twinBASIC Update: May 28, 2023 Highlights include a new home for twinBASIC documentation (docs.twinbasic.com) and an update on twinBASIC's slant.co language ranking.
Week in Review Week in Review: 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.
Quick Tip Quick Tip: Code Comment Breadcrumbs This quick tip is a great way to boost the signal-to-noise ratio of your code without sacrificing valuable context from your decision-making process.
Reader Challenge Solving the Five-House Logic Problem by Hand In this follow-up to my post on the classic Five-House Logic Problem, I provide the solution to the riddle plus a few tips for finding it.
Reader Challenge Reader Challenge: Einstein's Five-House Logic Problem In part 1 of this series, I introduce a classic logic problem that took me nearly two hours to solve by hand. Later in the series, we'll use Access to program a solution.
Business Reader Question: How Do I Make Value-Based Pricing Work? Value-based pricing is not a synonym for fixed-bid pricing. To make it work, you need to focus on the business value you can generate for the client.
Hidden Features Understanding the Access ColumnWidth VBA Property The ColumnWidth property of an Access datasheet has some strange behavior, especially when it comes to its special values: Default Width and Size to Fit.
twinBASIC Weekly Update twinBASIC Update: 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.
Week in Review Week in Review: 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.
Basic Should you install 32-bit or 64-bit Access in 2023? Which version of Access (and/or Office) should you install: 32-bit or 64-bit? We go way deep into the differences and similarities between the two options.
Commentary VBA Cracks RedMonk's Stack Overflow Top 15 for 2023 VBA may never be a GitHub heavyweight, but it holds its own among other top languages in terms of Stack Overflow popularity.
Announcement UPDATE: Office Apps WILL Run on Windows Server After October 2025 Earlier this year, Microsoft quietly reversed its decision to end support for running Office apps on Windows Server at the end of 2025.
Commentary Documentation-First Development The act of writing end-user documentation before software development offers a host of surprising benefits.
Tools Instantly "Copy" Huge Files Using Hard Links in Windows Hard links are a well-hidden feature of the Windows file system. Don't let Linux users have all the fun!
twinBASIC Weekly Update twinBASIC Update: 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.
Week in Review Week in Review: 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.
Reports HELP! My Access Report is Missing Information When my Users Run It Your Access report runs fine on your computer, but it's broken when an end user runs it. What gives?
Business The Value Matrix: A Framework for Prioritizing Development Software developers are content writing great applications, but consultants understand the importance of delivering big business impact.
Form Design The Hard Truth About Message Boxes in Microsoft Access Just because you know it's true, that doesn't make it any less frustrating.
DevCon Northwind 2.0: The Access Database Template You've Been Waiting For It only took 30 years, but Microsoft Access finally has a set of templates showcasing the best of what Access and its community of experts have to offer.