Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
Access and ODBC: a quick overview
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 Server. A...
Getting back on the horse, and form layout label auto configure issue
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. Daily...
TDD – 077 – Breaking Dependencies for Testing (part 4)
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...
TDD – 076 – Breaking Dependencies for Testing (part 3)
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 function returns a correct...
TDD – 075 – Breaking Dependencies for Testing (part 2)
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 the checks...
TDD – 074 – Breaking Dependencies for Testing
After reviewing the code further I have planned out how to break the form dependency in my code that I wish to test. The code I wish to test IsLineValid currently depends on a function inside the same class called thisForm which returns a specific type of Access form...
TDD – 073 – This Might Get Messy!
I have a class called PoLineController which has a public IsLineValid method. I made a change to this method in my previous TDD article, but I didn't test it first. I did end up refactoring it a bit. So looking back, I am going to think about how I could have done...
TDD – 072 – Real World Example
I want to start doing TDD when doing anything new on a client project, or even when debugging. I'm trying to use principles from "Working Effectively With Legacy Code" by Michael C Feathers, although I haven't finished reading the book yet. For this example I am...
TDD – 071 – What have I learned so far…?
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...
Deleting / Cutting Records on a Continuous Form
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...
VBA Comments And Why I Hate Them
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...
Access Events: BeforeUpdate and Changing Data
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...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994