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...
by Jonathan Halder | Oct 7, 2024 | Blogging, MS Access, MS Access Queries, MS Access Tables
This morning I was working on a query for a customer report that took me longer than I expected and produced more problems than I expected. I actually had 3 tables named customers, orders, and payments. Customers can have multiple orders, and have a one to many...
by Jonathan Halder | Oct 4, 2024 | Blogging, MS Access, MS Access Queries, MS Access Tables, MS Access VBA Coding
The Access 97 database I was trying to get working on my 365 Access was written to scramble data in existing tables in a destructive way so that users of a forum or other developers could look at code without seeing sensitive data. I copied some large tables I had...
by Jonathan Halder | Oct 3, 2024 | Blogging, MS Access, Versioning
Thanks to a reader of Jon’s Access List, Xevi from Girona in Spain, I received a converted version of the Access 97 Data Scrambler database. The reader used Access 2010 to update the database to a format that could be read by the most recent versions of Access,...
