Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
Calculating Weeks and Periods in VBA
I recently needed to calculate the period number of a current date for a client. The current period is not exactly the current week number, it's a specific week, but it could start on any particular day and end on any particular day. In my case, they specify it for a...
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...
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...
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...
Deftype statements in VBA – What?
I had never heard of this keyword. I was perusing the Microsoft Learn web site and happened across this in the VBA reference here: Deftype statements (VBA) | Microsoft Learn Here is the basic definition from that page: Used at the module level to set the default data...
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...
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...
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...
DLookup and “NiceDLookup”
A lot of Access users (especially newer ones) like to use the function DLookup to quickly lookup a value from a table or query. It is quite handy shorthand and can be used in VBA and in queries. The usage of DLookup is: DLookup (Expr, Domain, Criteria)...
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...
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...
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...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994
info@halderconsulting.com