Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
Why use code katas?
I enjoyed doing yesterday's code kata. See that here: https://www.accessjumpstart.com/super-simple-code-kata/ So the goal was to write a function to convert an integer into a string and had 3 different situations to test. The majority of the code in yesterday's...
Version Control Systems allow quick pivots in design
I am pivoting directions on a project. After producing what the customer asked for, he realized it was making the whole system more complicated than he wanted, but may want to revisit it in the future. Thankfully, since I use versioning, it was trivial to move back to...
SQL Server – don’t forget your indexes!
As I was working in my dev copy of the client's database today, I was using SQL Server quite a bit via SQL Server Management Studio SSMS. I noticed some slower performance on a couple of features I added multiple months ago that utilized new tables. So as I usually...
Access DevCon 9 (2025) Day 2 my reaction
SessionTitlePresenter6Proven Sales StrategiesJuan Soto7The Battle of the VCS Add-InsPhilipp Stiefel, Adam Waller8Power Automate with VBAYnte Jan Kuindersma9twinBASIC+AI in Access DevelopmentMike Wolfe10Access Tools for DevelopersColin Riddington Session 6 was a very...
Super Simple Code Kata
Here is a starter code kata... This is practically nothing in VBA since types get auto-converted, but how might you do this taking a variable of type integer and write a function to convert it to a string type. Here is the code kata requirements along with tests we...
Running parallel SQL server databases for testing
Today I spent much of my coding time on building a second database to run parallel copies of a new feature so that I could make sure the overlapping areas of output were remaining the same from the original process to the modified process that could do more. Although...
Logic errors – the ugly step cousin of compilation and run time errors
Today's work was to fix logic errors in my application. The problem is that overlapping data in files that normally deletes the older data and replaces it with the newer data is replacing all the older data even though it is earlier than what appears in the file....
Access DevCon 9 (2025) Day 1 my reaction
Day 1 Agenda: 1Access Community UpdateKarl Donaubauer2Programming Modern ChartsColin Riddington3Microsoft Graph APIMaria Barnes4VBE_ExtrasJohn Mallinson5News from the Access TeamMicrosoft Session 1 was a little scary, Frankly, Microsoft does not seem to want Access to...
What are code katas, and how can you use classes in real world scenarios?
I was looking around at some code katas today. Code katas are an exercise in coding that one can do on a repeated basis similar to practicing a move in martial arts. If you've seen the movie Karate Kid or any of it's sequels or remakes, you might remember "wax on, wax...
Are you stressed when you’re not coding?
Today was one of those days where my schedule decided to play a game of "let's see how many curveballs we can throw." First up, tackling my monthly bills took way longer than expected. Navigating new payment systems felt like trying to decode ancient hieroglyphics,...
Squashing the error 3167 “This record has been deleted” bug
Today's adventure was to fix a bug in a menu form in which the user was getting a "This record has been deleted" error message. What was happening was that the navigation form was based on a local temp table that gets rebuilt whenever the application is opened. There...
From Errors to Solutions: Implementing Transactions in Complex Database Imports
Today I started working through using a transaction to cover another complex series of database transactions. One of my customers was receiving an error message that a record was already deleted during an import. In this case, the import process takes a while and if...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994
info@halderconsulting.com