Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
Dragging and dropping between Access Files
Did you know that you can drag and drop items from the navigation pane in one Access database to another Access database? I used this feature today as I needed to copy a somewhat complex form to display a series of entries in a linked table in both databases filtered...
Reformatting simple text based phone number strings in VBA
Today, for my customer's app, I wrote some VBA code in an after update routine of a textbox to strip out non-numeric characters and reformat them into a phone number format the customer wanted. Private Sub employee_phone_number_AfterUpdate() If IsPhoneNumberThere Then...
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...
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...
Lazy Loading Class Instances on a form
One of my recent adventures in Access was to fix an issue where occasionally a class instance setup by the Form Open event was somehow getting blown away. I'm frankly not sure why. As far as I know the global variables on the form only get reset if you close and...
ADO and DAO recordset Filter property
Today, my customer for whom I had enabled transactions was having problems with the update routine. Ultimately, it stemmed from the fact that the Filter property is treated differently between the ADO recordset object and the DAO recordset object. I had originally...
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...
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...
Ahh! Egg on my Face! (Or: Input mask and value options)
So I was wrong yesterday about phone number input masks and input values. An input mask value specifies a format, whether the mask is stored in the value, and the placeholder for users to enter data into the mask. This Microsoft web site discusses the pros and cons of...
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...
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...
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...
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