by Jonathan Halder | Oct 29, 2024 | Blogging, MS Access, MS Access VBA Coding
When I was younger, I was a staunch DIYer (Do-it-yourself) programmer. Granted, this was a great advantage in many ways in those days. I didn’t have to spend money on add-ins or have to spend time to learn how to use them. I also didn’t have to spend money...
by Jonathan Halder | Oct 28, 2024 | Blogging, MS Access, MS Access VBA Coding, TDD
You write a test for the behavior you want. So far so good. You have to figure out how to interface with your system to write the test though. Today, I was adding a new type of status called “Internal Hold” for an order, and the line items each can also...
by Jonathan Halder | Oct 25, 2024 | Blogging, MS Access, MS Access Tables
SQL Server Express is a version of SQL server you can install on a computer available to all your Access Front End users that will provide a more robust back end than using Access accdb files. How much does it cost? It’s free! So what’s the catch?...
by Jonathan Halder | Oct 24, 2024 | Blogging, MS Access, MS Access Forms, MS Access Reports, MS Access VBA Coding
First of all, it’s good to know that you can add a report to a sub-report control on a form. If you need to display multiple groups of data for informational purposes on the form, this can be a real game changer! I have a routine I use that’s in my library...
by Jonathan Halder | Oct 23, 2024 | Blogging, MS Access, MS Access Features
Had an interesting little bug in Office today in which a solid 2px black (#000000) border does not appear around a subform control (and this ends up applying to many other controls and shapes as well) I was really scratching my head, until I went online to find out if...
by Jonathan Halder | Oct 21, 2024 | Blogging, MS Access, MS Access VBA Coding, Versioning
When working with a particular customer, it is very beneficial to have a plan on working on their database and being able to implement your new database changes effectively. Ideally, you might have a fully automated pipeline that would allow you to test and deploy a...
