by Jonathan Halder | Feb 15, 2024 | MS Access, MS Access Features, Versioning
What is Access JumpStart? Thanks for asking. Access JumpStart is our collective work as a two man programming outfit to share common code for our apps across multiple clients, architectures, and configurations. Steve and I call it a framework. It originally was named...
by Jonathan Halder | Jan 24, 2024 | MS Access, MS Access VBA Coding, TDD
I was watching a video with Kent Beck speaking somewhere, I’m not sure which one because there were like 3 different videos. But he was categorizing coders into “lumpers” and “splitters”. I apparently am a “splitter” because...
by Jonathan Halder | Dec 18, 2023 | MS Access, MS Access Features, MS Access Forms, MS Access Queries, MS Access Reports, MS Access Tables, MS Access VBA Coding
Refactoring code is something I do often. Trying to find ways to make things simpler and more readable are two reasons of many that I do this. As I work on code and refactor it, I find myself continually, daily, using tools to find and replace code, and not quite as...
by Steven Halder | Dec 5, 2022 | MS Access, MS Access Features, MS Access VBA Coding
You can control how your project is compiled. Have one “source base” that you use for multiple purposes, environments, or in multiple “modes” of operation. You can use Microsoft defined Compiler Constants and you can define your own....
by Jonathan Halder | Mar 7, 2022 | MS Access Forms, MS Access Queries
This error occurs because, drum-roll please…. The setting for this property is too long. So in this particular case, the developer was trying to create a long SQL string using multiple UNIONs with a complex query and trying to set this string to the RowSource...