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...
by Jonathan Halder | Oct 18, 2024 | Blogging, MS Access, MS Access Queries, MS Access VBA Coding
If you’ve ever wondered whether a SQL statement you executed actually modified any records, there is a property of the DAO database object that can help you. You can get the number of affected records of a DELETE, UPDATE, or INSERT type query immediately after...
by Jonathan Halder | Oct 17, 2024 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding, TDD, Versioning
Back 6 months ago I was asked to add new fields to check for the validity of a line item on an order. This caused me to go through a rather extensive process to break dependencies on an Access form so that I could test it without having to launch the form and build an...
by Jonathan Halder | Oct 14, 2024 | Blogging, MS Access, MS Access Queries, MS Access VBA Coding
Despite my best efforts, sometimes I end up with complicated code. The logic snakes and wraps around like crazy river rapids. Today, I had such a part of my customer’s database that I was working in and it was not easy. Most of the time this problem occurs...
by Jonathan Halder | Oct 9, 2024 | Blogging, MS Access, MS Access Forms, MS Access Reports, MS Access VBA Coding
When implementing logging in your Access app, some of the things you might want to log are: Opening and closing of objects which have VBA associated with them. Typically Forms and Reports. Try to add a log message which includes the primary key when you edit or add a...
by Jonathan Halder | Oct 8, 2024 | MS Access, MS Access VBA Coding, TDD
If you haven’t had the pleasure of Uncle Bob Martin books or videos, you’re missing out. I’d recommend a search on YouTube for Uncle Bob’s Clean Code. I watched a lot of his videos when I had an O’Reilly subscription and that led me to...
