Access JumpStart 2.0 | Email Archive
A Rapid Development Framework for Microsoft Access
Email Archive
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...
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...
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...
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...
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,...
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...
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....
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...
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...
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...
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...
Polymorphism in Action: Refactoring File Processing Routines in Access
Today's Access adventure involved refactoring code as an evolution from getting a particular set of line item records associated with a file to be processed when that file was selected from another form. In the first iteration of the code for testing, I was using a...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994