Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
Access Programming – What I do and Why (source control part 4)
I’ve been discussing how I use version control in 3 previous emails / articles which you can find here: Access Programming – What I do and Why (source control) | Access JumpStart Access Programming – What I do and Why (source control part 2) | Access JumpStart Access...
Access Programming – What I do and Why (source control part 3)
I've been discussing how I use version control in 2 previous emails / articles which you can find here: Access Programming – What I do and Why (source control) | Access JumpStart Access Programming – What I do and Why (source control part 2) | Access JumpStart This is...
TDD – 012 – Passing Code vs Overthinking
A big part of Test Driven Development is to write code that passes a test without overthinking things. In my last test I wrote, it's pretty clear it will not stand up to the next couple of tests one might think of. The test is making sure that the count of updates to...
TDD – 011 – Testing variable types and refactoring
I am currently in a failing test state: I see that the expected and actual values are not the same type in the test. This means that I asserted a 1 of type Long would be a 1 of type Integer. I believe that's the default type of 1. VBA is usually pretty nice in that it...
Access Programming – What I do and Why (source control part 2)
What is my process for working with a customer database? Let's say I get a new database to start working with. Before I make any changes, I want to put the database into version (source) control. Why? I want to make sure I have any changes I make to the database...
TDD – 010 – Design and the next test
It is time to think about the next test. What I'd like to do is start capturing changes to the form fields. Probably the simplest and easiest way to do that is to create a collection of form field information inside the FormListener object to start storing changes...
TDD – 009 – Test is passing, now refactor
The test-driven development cycle is: Create failing test for the behavior you are wanting. Create just enough code for the test to pass. Refactor - meaning reorganize the code without changing any functionality. And you just keep repeating that over and over again...
TDD – 008 – Passing the BeforeUpdate event test
So far, the test Creates a new Form Listener object Creates a new Form object as a Test Form Opens the Test Form Runs the Setup method of the Form Listener object Updates a field on the Test Form Saves the Test Form Record Checks the BeforeUpdateTriggered Property of...
TDD – 007 – Shaken, not stirred
Sorry, had to recognize the 007 reference with in my title. James Bond. Anyway, I am working on a test to check whether the TestForm's BeforeUpdate event is getting fired and the FormListener object is seeing it. My initial thought here is to add testable responses...
TDD – 006 – Mocks and Fakes and Tests, oh my!
Could I do less to check for acceptance of a form object? So, out of morbid curiosity, I am going to see if I can just create a new Access.Form object again and open it and then pass that to the function. It would be easier for this initial test if I can and the idea...
TDD – 005 – Passing a form to our listener part 2
Hmmm... So it turns out you can't just create a form using: Dim aNewForm As New Access.Form I was trying to simply pass a new form object to a class I eventually want to hook into it's event forms. So, next I tried to actually create a blank form in the database. Then...
Access Programming – What I do and Why (source control)
So in terms of Access Programming, I have over the years, built up tools and practices I use which help me develop better, faster, and more efficiently. Many of these tools and practices were developed specifically in order to solve recurring problems. Ok, so let's...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994