by Jonathan Halder | Apr 22, 2024 | MS Access, TDD
After 70 short 25 minute or so sessions of TDD with Access and RubberDuck VBA, what have I learned? I have definitely learned that this is a really big subject and a big paradigm shift in my current programming style. Thinking about how to write code to keep it under...
by Jonathan Halder | Apr 19, 2024 | MS Access, MS Access Forms, MS Access VBA Coding
Tracking deletions to a continuous subform can be tricky. The Delete Confirmation event does NOT fire for subforms. Only the OnDelete Event. This allows you to Cancel the event, but does not allow you to leave the subform to run any code affecting the parent form and...
by Jonathan Halder | Apr 18, 2024 | MS Access, MS Access VBA Coding
Ok, maybe hate is a strong word, but I generally try to avoid commenting my code. Why? I want to try to make the code I write understandable and read like well written prose. Does all of my code look like that? No, but I wish it did. If I feel a line of code needs a...
by Jonathan Halder | Apr 15, 2024 | MS Access, MS Access Forms, MS Access Queries, MS Access VBA Coding
Occasionally, I run into an issue where I am using some function within a BeforeUpdate event in an Access form which goes and updates the table with a SQL statement or query. This can produce some unwanted and messages about someone else editing the record and do you...
by Jonathan Halder | Apr 12, 2024 | MS Access, MS Access VBA Coding
I came across this fantastic code on DevHut by Daniel Pineault. I was doing file hashing and found Daniel’s script here: Get a File Hash using VBA | DEVelopers HUT (devhut.net) This in turn uses the PS_GetOutput script he explains here: VBA – Run...
by Jonathan Halder | Apr 10, 2024 | MS Access, MS Access VBA Coding
What is polymorphism? It’s a concept in object oriented programming that allows you to define different versions of objects that all share some of the same characteristics. In language, an example would be two different cars. A Lamborghini is a car, as is a...
