Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
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...
Count Distinct in SQL Server and Access
In SQL Server you can count up the distinct values in a column of a query using syntax like: SELECT SalesPersonID, COUNT(DISTINCT CustomerID) As NumberOfDistinctCustomersServed FROM ClosedSales GROUP BY SalesPersonID This will give you the number of unique customers...
When to quit
First of all I am notoriously bad at knowing when to quit. I keep trying things thinking I'm almost there and that I'll get that code working in the next 5 minutes. Then 3 hours later I have a huge mess and it's not done yet with me scratching my head. So when should...
End to end problem solving
Today's adventure in Access was a problem my customer was having with an imported file. Their shipment requests were being supplied via electronic delivery and then they send a confirmation via the same electronic delivery system. The recipient of the shipments asked...
Upgrading our AJS template
In today's adventure, I have a complex application I am updating from an older version of our Access Jump Start application template from when we were calling it RDF (Rapid Development Framework). I am doing this so I will have access to some of the newer features as...
Test Driven Development and Changing Code
I've been a relatively recent newcomer into Test Driven Development, only starting to implement it into my projects and been working on learning it since 2023 or so. Today, my Access adventuring leads me to work on changing the behavior of custom rule of the system....
Be careful! Don’t fall down the rabbit hole.
Today's adventure in Access involved discovering I'd been working on behavior in an application that although is recognized that it needs fixing, was not what my customer wanted me focusing on. You fall down the rabbit hole (as I did) when you become singularly...
Unintended Changes Deployed in an Access program
Today I got an email from a customer that they couldn't enter information into a certain form and asked me if I had it locked. Immediately, I knew I had messed up because I had made a change in my development database in which I changed that's form recordset to...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994