Access JumpStart 2.0 | Email Archive
A Rapid Development Framework for Microsoft Access
Email Archive
DAO Workspace Transactions
So I had some legacy code that was testing an mdb connection to make sure it could get an exclusive lock on the file. If so, the code would then proceed doing an update procedure, but switched methods to use ADO. I am pretty certain that I wrote the code like 15 years...
Hooray, I figured out color for VBA in my emails, I think…
A big shout out to Crystal Long (strive4peace) for this Access Add-In. So, I have simply been using a plugin on my WordPress site that I post the daily article to which in turn is picked up by my Kit account RSS feed reader and auto-emailed to everyone. I've always...
Your Development Environment vs the Live Environment
Your development environment is important. You want to have fast performance as you develop and you want it to remain stable so it doesn't crash. I have a decent desktop with 2TB of NVME storage (the fastest I could get when I built it), two monitors and 64GB of...
Red, Green, Refactor vs. Specify, Encode, Fulfill
I was listening to the Mob Mentality podcast on Spotify and came across this episode. Here is the YouTube link (Spotify is only audio): https://www.youtube.com/watch?v=_kL_tXiNcl4 The guest, Jason Swett, was talking about Test Driven Development and those coming into...
Test Driven Development (TDD) and Forms in Microsoft Access
I thought I would update folks on my TDD progress using VBA in Access. I use the RubberDuckVBA Unit Testing component to create and run tests. You don't need a fancy program or system like that to utilize automated testing, but I have enjoyed using it and the nice...
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...
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...
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...
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...
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...
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...
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...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994