Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
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...
DevHut’s Daniel Pineault’s VBA PowerShell Function with Update
I came across this fantastic code on DevHut by Daniel Pineault. I was doing file hashing and found Daniel's script here: Get a File Hash using VBA | DEVelopers HUT (devhut.net) This in turn uses the PS_GetOutput script he explains here: VBA - Run PowerShell Command |...
Polymorphism in VBA
What is polymorphism? It's a concept in object oriented programming that allows you to define different versions of objects that all share some of the same characteristics. In language, an example would be two different cars. A Lamborghini is a car, as is a Ford. Both...
Access ListBox Row Source and Type
I have been working on updating code for a customer form with a list box control storing a long list of files in various folders. There are filters on this form that can limit the files available to choose from. During my coding I noticed some performance problems....
Using A Form, Classes, and an Event to Pass Status Messages
The other day I was coding an Access Form which displays a file list to choose files to import into the database. I had created the following components: An Access Form named: ImportForm A Class Module to handle a full list of files available for importing and...
TDD – 070 – Changing the class to load a user specified form
It's time to add a new test: '@TestMethod("Initialize") Private Sub WhenThereIsAForm_ThenItCanBeAssigned() Dim testFormAuditor As FormAuditor Set testFormAuditor = New FormAuditor testFormAuditor.Init Forms("TestForm") End Sub This test is in my new RubberDuck test...
Access Error 2455 Referencing Subform Form Control
One of my clients was occasionally getting a 2455 error in Access: Run-time error '2455': You entered an expression that has an invalid reference to the property Form/Report. What was happening in this case was that the user had minimized Access and then closed Access...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994