Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
Using RecordsAffected with DAO
If you want to get the number of records that were updated, inserted, or deleted by your query, you would read the RecordsAffected property on the object that executed your query after it had run. 'Copied from a normal module 'We set a reference to the CurrentDb...
When the locals window doesn’t cut it (Viewing dictionary keys with values, including nested dictionaries)
When you want to view the contents of a dictionary object in the VBA locals window, it turns out you just can't. It shows the Dictionary Items collection with the item number and key contents, but not the value. In order to see what's in the dictionary, you need to...
Leave that VBA better than you found it
Today's adventure was helping a customer who had moved from an on premise Exchange server at their business to Microsoft 365 email accounts in the cloud. They needed to update their Access application with the new email settings. As I dove into the code, I found 6...
CustomTags – changing to utilize RubberDuckVBA testing
Ok, so to use test driven development here, I will start writing tests to describe the behaviors of the control I want and then code to make the tests pass. I copied the code from the module from last time with the TestCustomTags Sub to a new Test module I created...
Class Module InputSimulatorForArray
I wrote up this quick class module a while back to more easily and quickly replace file Input and Inputline functions in code with an array of lines for a file. Basically, I was pre-processing and staging text files into a usable format into a database and wanted to...
Accdb’s link to Mdb’s, but Mdb’s don’t link to Accdb’s
Today, I remembered a little factoid about Access database versions. You can't link older front end Access files to newer back end Access files. My mission was to take a set of Access applications I had upgraded for one department (which is being used in parallel with...
Take a minute to reflect
I'm referring here to knee-jerk reactions, and in particular reactions in response to crisis. As an Access consultant, I am currently experiencing a famine cycle of the feast-or-famine evil beast. It is a beast I've wanted to get away from and have tried different...
How not to generate unique numbers from existing ones
Today one of my customers ran into a problem with my coding of a system meant to group related lines together on a purchase order. There are estimating details that contain an affiliation number for grouping lines together. They are unique per phase number. These need...
Using an Access file as a VBA reference
I had a friend ask me for more info about using access files as libraries, so here is some info I gathered up: First off is a link to a file Steve Halder created when researching building our library for our Access JumpStart product. This has a lot of info and sample...
Refactoring Tests in RubberDuckVBA
Today I was refactoring some tests to make them easier to write for my application. In this application, I am testing lines on a subform to make sure they have the correct values. I used a class I created called a FormGetter which uses an interface so I can create a...
CustomTags – Basic functionality coded!
This is a very basic set of 2 classes to produce a CustomTags object that can take an Access Control object from a form and store an internal dictionary intended to use string keys to store string values for that tag. The ControlTags and ControlTag currently use early...
Custom tags for form controls – Beginning to code the solution
So I'm doing some proof of concept here. I want to use a starting syntax like the following in the Debug.Print line: Public Sub TestCustomTags() Dim testCT As CustomTags Set testCT = New CustomTags Dim ctl As Access.Control Set ctl = Form_TestForm.TestControl...
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