Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
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...
Access Subform, or Subreport?
I had generally used Subforms in Subform/Subreport controls as part of a standard form. I hadn't even really thought too much about the fact that you could put report objects into a Subform/Subreport control. What pushed me in the direction of using a report in a...
Running Access Headless
Sounds intriguing, doesn't it? So what do I mean by running Access headless? I am referring to the term headless as it refers to running a machine without user intervention as an automated process. For example, I have some reports that get emailed out at certain time...
ChatGPT woes
Me: Write a humorous limerick about ChatGPT failing to do what is expected. ChatGPT: There once was a bot named ChatGPT, Whose answers could often betray. Asked for a rhyme, it stuttered in time, And left folks in quite the disarray. It pondered and whirred with great...
Access Query Optimization – using Passthrough and local queries together
Today I worked on optimizing a query for a client. it wasn't super long, about 2 seconds, but that was enough to make a noticeable delay for the users running the database. I wanted to make it a little snappier. It ended up boiling down to one thing, but first I had...
TDD – 069 – Thinking about another class of tests for initializing
Back to getting a failing test. I am wanting to make sure that the user can configure any particular form to use this FormAuditor class easily, so I want my next tests to indicate that. Here are a few scenarios I already had on my test list: Easily load the form...
TDD – 068 – Being a rebel, outside of the Red/Green/Refactor cycle
I'm making a new test. So far I've just copied an old test and here it is so far: '@TestMethod("Verify Changes") Private Sub WhenControlTypesAcceptedListChanges_ThenControlTypesInListChecked() Dim dctInputs As New Scripting.Dictionary, colResults As VBA.Collection Set...
TDD – 067 – Finishing up the refactored control checking
I've decided to use an array instead of a collection. I have to loop over either to search for the element, the array will be small, and it is native to the VBA language and I don't have to create a new object. Also, I am just planning on using the array in the...
TDD – 066 – Extracting a case statement, then do what?
Per the last writing, I wanted to refactor the BeforeUpdate routine Select Case statement. Here is the code in question: Private Sub FormToAudit_BeforeUpdate(Cancel As Integer) Dim Fld As Variant, ChangeDictionary As New Scripting.Dictionary, Ctl As Access.Control For...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994