by Jonathan Halder | May 20, 2024 | MS Access, MS Access VBA Coding
I’ve probably clicked on this button before, but I must say, I have absolutely no idea off the top of my head what this does: I noticed it today in the VBE editor. “Clean Project”. No 3 dots. I’m going to try to click it and see what happens!...
by Jonathan Halder | May 17, 2024 | MS Access, MS Access Features, MS Access Queries
One great thing about Access is all the various ways it can connect to data in tables. Using ODBC, Access can connect to anything with an ODBC driver that you can install. I’ve done connections using datasource names as well as DSN-less connections to SQL...
by Jonathan Halder | May 16, 2024 | MS Access, MS Access Features, MS Access Forms
I have been slack in writing for the past week. The main obstacle is that I had a great suggestion about writing more to my target market in terms of Access JumpStart. This turned out to be a big pivot in my thought process, and I’m not sure I’m there yet....
by Jonathan Halder | May 8, 2024 | MS Access, MS Access Forms, MS Access VBA Coding, TDD
I have not written anything for a week. Bad me. So, the nice thing about testing is that I was able to fire up my tests and run them and I see right where I was working when I left off last time. Continuing from last time, I am going to add the same form getting...
by Jonathan Halder | May 1, 2024 | MS Access, MS Access Forms, MS Access VBA Coding, TDD
In my application I have a class object called “ECI_POLineController” with a method called “IsLineValid”. My job was to be able to write a test for this and I have done that. It needs to set some different values on the line to verify the...
by Jonathan Halder | Apr 30, 2024 | MS Access, MS Access Forms, MS Access VBA Coding, TDD
I had a pretty “simple” change to an application in a IsLineValid function that checks the active record on a subform to see if that line is valid. A new requirement in the application meant that the conditions changed slightly. Originally, I just added...
