Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
Figuring out when to do TDD vs simple form design
I've been sick for the past two days, and kept getting too tired to create a post for the day. So I did what I could for my clients first, then slept. 😛 I'm feeling much better today, so I'm back in the messaging chair. I ended up scrapping my idea from yesterday:...
Automated testing strategy – TDD – Unit Testing
Today I was struggling with trying to come up with tests for a new feature for an existing Access database. The feature is changing the way addresses are entered for work jobs. Basically the job structure which has had embedded address fields like street, city, state,...
2025 – Access reintegrating source control
Karl Donaubauer hosted the Access development team at his German Access Developers Conference and there are some cool things coming down the pipe for us. One of them is re-integrating source code control back into Access: https://youtu.be/dP-YljKct5M?t=943 At one time...
Access plugin SDOpenAI and OpenAI API setup
In my message yesterday, I installed the SDOpenAI plugin: Pair programming with AI – SDOpenAI – installing the plugin Today I setup an OpenAI API account (I had already done this in the past so I was beyond the free trial). I purchased $10 worth of resource. The...
Pair programming with AI – SDOpenAI – installing the plugin
I am going to test out the free version of the SDOpenAI Access plugin to see how well it works to pair program with. The web site is in German, but I had no problem downloading the executable file (albeit with multiple warning prompts from Edge about being a file that...
Formatting Forms for different screen sizes
A common Access problem when rolling out Access applications to users is differences in screen sizes and monitor resolutions. I have one client in particular that generally uses 1920 x 1080 resolution for most of their users, but the boss uses multiple monitors at an...
Remotely Accessing Access
There are a few strategies you can use to extend the life of Access and make the app available outside of a LAN. Utilizing Remote Desktop of some kind: One way is to use Remote Desktop services. I often just use a VPN to get into a particular LAN where Microsoft...
Double vision – what might a pair programming session look like?
Pair or Mob programming is a collaborative technique where two or more developers work together at one workstation. One writes the code (the Driver) while the other(s) review each line of code as it’s written (the Navigator). Here’s how one might structure an...
What is pair or mob programming? Why do it at all?
Pair Programming and Mob Programming are collaborative approaches to software development that emphasize teamwork and shared responsibility. What is Pair Programming? Pair programming involves two developers working together at one workstation. One developer, known as...
Some vanilla VBA error handling scenarios
Error handling in VBA is crucial for managing runtime errors and ensuring your code runs smoothly. Here's how it works in a couple of different common scenarios: Standard Error in a Single Procedure:When an error occurs in a single procedure, you can use the On Error...
Error Handling in Access JumpStart
How do we deal with Error Handling in a library? This came up because of the NiceDlookup function I've published previously. In that function, the Err object is used to "Raise" errors. The reasoning behind this for this particular function was to make the function...
Pair Programming basics
If you have a project you are working on in Access and are looking for another pair of eyes or some advice on how to work through adding a new feature to your system, you might find pair programming a valuable asset. In order to pair program, you have a few options....
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994