by Jonathan Halder | Mar 24, 2025 | Blogging, MS Access, MS Access Forms, MS Access Queries, MS Access VBA Coding
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...
by Jonathan Halder | Mar 21, 2025 | Blogging, MS Access, MS Access Features, MS Access VBA Coding
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...
by Jonathan Halder | Mar 20, 2025 | Blogging, MS Access, MS Access Features, MS Access VBA Coding
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...
by Jonathan Halder | Mar 19, 2025 | Blogging, MS Access, MS Access VBA Coding
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...
by Jonathan Halder | Mar 18, 2025 | Blogging, MS Access, MS Access Features, MS Access VBA Coding
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...
