Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
Finding the width of arbitrary text in Access VBA
I'm revisiting my ListBox control work from these two articles: Access ListBox Row Source and Type | Access JumpStart ListBox Column size adjustments | Access JumpStart The second article discsusses how to adjust column sizes using the ColumnWidths property and the...
ListBox Column size adjustments
In a previous article, I discussed a listbox conundrum I had with really long lists: Access ListBox Row Source and Type | Access JumpStart One of the things I wanted to do with this listbox was adjust the column sizes of the list on the fly, depending on the size of...
Access Query to Excel Data table, quick!
Sometimes my customers ask me for data from their database that they want to see in a way they've never looked at or needed to look at it before. When this happens to me and the answer is a data pull, I will often either pull up an existing query with the answer or...
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...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994