by Jonathan Halder | Apr 22, 2025 | Blogging, MS Access, MS Access VBA Coding
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...
by Jonathan Halder | Apr 21, 2025 | Blogging, MS Access, MS Access VBA Coding, Versioning
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...
by Jonathan Halder | Apr 18, 2025 | Blogging, MS Access
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...
by Jonathan Halder | Apr 17, 2025 | Blogging, MS Access
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...
by Jonathan Halder | Apr 16, 2025 | Blogging, MS Access, MS Access Tables
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...
by Jonathan Halder | Apr 15, 2025 | Blogging, MS Access, MS Access Forms, MS Access Queries, MS Access Tables, MS Access VBA Coding
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...
