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...
by Jonathan Halder | Mar 17, 2025 | Blogging, MS Access, MS Access VBA Coding, TDD
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...
by Jonathan Halder | Mar 14, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding, TDD
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...
by Jonathan Halder | Mar 13, 2025 | Blogging, MS Access, MS Access Features, MS Access Queries, MS Access VBA Coding
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...
by Jonathan Halder | Mar 11, 2025 | Blogging, MS Access, MS Access VBA Coding
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...
