by Jonathan Halder | Dec 19, 2023 | MS Access, MS Access Forms, MS Access Tables, MS Access VBA Coding, TDD
Time to do more test driven development! So we left off last time thinking about doing a test to see if a dictionary object I am going to create to store the form field changes is a new object. I was trying to determine how to Assert that using RubberDuckVBA and I was...
by Jonathan Halder | Dec 18, 2023 | MS Access, MS Access Features, MS Access Forms, MS Access Queries, MS Access Reports, MS Access Tables, MS Access VBA Coding
Refactoring code is something I do often. Trying to find ways to make things simpler and more readable are two reasons of many that I do this. As I work on code and refactor it, I find myself continually, daily, using tools to find and replace code, and not quite as...
by Jonathan Halder | Dec 6, 2023 | MS Access, MS Access Queries, MS Access Tables, MS Access VBA Coding
I’ve been discussing how I use version control in 3 previous emails / articles which you can find here: Access Programming – What I do and Why (source control) | Access JumpStart Access Programming – What I do and Why (source control part 2) | Access JumpStart Access...
by Jonathan Halder | Jun 19, 2020 | MS Access Queries, MS Access Tables
A common database issue in the world is the need to store lists of related items. This might be a Bill of Material (or BOM) for a business application to describe all the parts and assemblies needed to ship a particular product, or it might be something like meal...
by Jonathan Halder | Jun 3, 2020 | MS Access Queries, MS Access Tables
In certain cases I have used temporary tables in order to speed up reports. In these cases, the queries are usually complex and the backend and / or front end are being run in a multiuser environment with multiple users accessing the reports at any given...
