by Jonathan Halder | Jun 26, 2024 | MS Access, MS Access Forms, MS Access VBA Coding, TDD
I now have a real-world scenario for requirements for this class. Requirements are coming from customer requests and then interpreted into a list for myself. Test Driven Development then takes requirements and you translate them into tests (one at a time). Just...
by Jonathan Halder | Jun 17, 2024 | MS Access, MS Access Forms, MS Access VBA Coding
I had an application today with lots of flickering on a form containing two subforms in continuous mode. When I first load the main form it flickers a little bit, sometimes longer than others (seemingly depending on where my mouse is sitting). Often moving the mouse...
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 | Mar 19, 2024 | MS Access, MS Access VBA Coding, TDD
First I need to review a test that is failing: That test was not the last test I wrote which was the Verify Info Fields category test to return the new ControlSource property I added. The failing test was actually another test I wrote to see if two fields bound to the...
by Jonathan Halder | Mar 14, 2024 | MS Access, MS Access VBA Coding, TDD
I’m going to add a data element to our collection so that the user of our Form Auditor class will have the bound field name from the ControlSource property. First I will add a new test to check for this additional field in order to have a failing test, then I...