Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
Choosing to write ~daily~
I have just returned from a 12 day absence from my business. One week at a conference, the second with family in another state. I only wrote once during this absence. In my case this was already calculated. I knew I wasn't going to write much and chose not to try to...
TDD – 078 – Updating Form Auditor class requirements
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...
Solving Access Subform flickering woes
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...
Fixed Price billing (Cost plus margin) Pros & Cons for Programming
Defnition of Fixed Price billing (Cost plus margin) This I believe is the next favorite behind hourly billing. Typically a consultant will try to determine the features the customer is asking for, then determine a fixed cost based on their costs plus a margin of some...
Refactoring in VBA with RubberDuck: Introduce Parameter
According to the RubberDuck refactoriings page, the definition of the Introduce Parameter refactoring is: Introduce Parameter Select a local variable to promote to a parameter. Call sites for the containing procedure will be updated with a TODO argument, which must...
Refactoring in VBA with RubberDuck: Encapsulate Field
I have discovered another source of documentation from the RubberDuck git repository which contains some descriptions of the refactoring options. Here is the link: Refactorings · rubberduck-vba/Rubberduck Wiki · GitHub According to this page, the Encapsulate Field...
Refactoring in VBA with RubberDuck: Move Closer To Usage
Here is another entry on the VBA RubberDuck Refactoring menu: What exactly does this mean? Initially, I was thinking the scope was a function in a module, and it would move a function closer to a function call made. I was just DEAD WRONG! It's actually something to...
Hourly Billing Pros & Cons for Programming
I'll be honest, I don't particularly like hourly billing. This list will likely show you why. Description: Hourly billing (Rate * Hours): This seems to be the favorite of the industry. It is based on an hourly rate and the concept that time is money. It also is...
4 of a million possible ways for customers and developers to work together
A while back I was searching for an alternative to hourly billing (all I knew was there was either hourly billing or fixed cost billing). I wanted to see what others were doing out there. This led me to Jonathan Stark's Hourly Billing Is Nuts series of articles and...
Refactoring in VBA with RubberDuck: Reorder Parameters
Using some sample code I was playing with in my last Refactoring article, we will see what RubberDuck does when reordering parameters. Here's the code: HAL_BasicEncryption Option Compare Database Option Explicit Implements IHAL_Encryption Private Function...
Adding a deployment script to an existing Access JumpStart app (Part 6)
I wrote a script to deploy my Microsoft Access application which utilizes my company’s Access JumpStart framework which is available for purchase from our store. In the previous parts I’ve explained how I’ve done the first 6 steps of my script: Step 1 – Update the...
Adding a deployment script to an existing Access JumpStart app (Part 5)
I wrote a script to deploy my Microsoft Access application which utilizes my company's Access JumpStart framework which is available for purchase from our store. In the previous parts I've explained how I've done the first 5 steps of my script: Step 1 – Update the...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994