by Jonathan Halder | Oct 15, 2024 | Blogging
When the customer is having a problem with the output of the system, my first reaction is to check the logs and try to recreate the problem. In this case, the customer has a number of employees who use the system. He didn’t know why something wasn’t...
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 10, 2024 | Uncategorized
You can find the previous parts of this message here: Copying Access Tables / Data using VBA Real World Case – Part 1 | Access JumpStart Copying Access Tables / Data using VBA Real World Case – Part 2 | Access JumpStart In Part 3 I discovered that the copied tables...
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...
