Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
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...
TDD – 004 – Passing a form to our listener part 1
Ok, so now we have just created a test for creating an instance of a FormListener class, but there's nothing in the class yet. What do we want to test next? I need to think about the next bit of functionality I will want in this class in a way that I can test it. So I...
TDD – 003 – Getting our first test to pass
So we have created our first test and it is failing. Opening up the RubberDuckVBA Test Explorer and running all the tests shows us our failing test: Now it's time to make it pass. To do this I'm going to Create a new Class Module using the Insert -> Class Module menu...
TDD – 002 – initial design and first test
Design for a form auditing object Ok, so before I can write any tests, I have to think just a little bit about what I want to create so that I can start writing meaningful failing tests that will move me toward where I want this to go. Whew! Sounds kind of confusing,...
TDD – 001 – the beginning
Why do we want to use Test Driven Development? It is less error prone, producing better code which is more reliable and able to be verified from multiple paths. It allows us to express our intent in the form of a test. This forces us to create a better design. It...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994