by Jonathan Halder | Sep 24, 2024 | MS Access, MS Access Tables, MS Access VBA Coding
I received a task today to update a demo / WIP Access system which will be upgrading an existing Access system. Many parts of the system are the same, the upgrade is meant to address importing data from a new datasource. The customer is currently using both systems...
by Jonathan Halder | Sep 23, 2024 | MS Access, MS Access Queries, MS Access VBA Coding
I’m working in Access today and I noticed that a confirmation dialog box I have set up to ask me as a developer if I really want to send an email was not working. Initially I thought it was because of a flag that was failing to get set, but that wasn’t it....
by Jonathan Halder | Sep 20, 2024 | Blogging, MS Access, MS Access VBA Coding
So, I was having an email conversation with a regular reader of my Access Adventure and he was discussing the sad lack of documentation for VBA’s internals. The engine that runs it and it’s various components. Although I have a cursory knowledge of VBA, I...
by Jonathan Halder | Sep 19, 2024 | Blogging, MS Access, MS Access VBA Coding
There are a number of looping structures in VBA. Here is a quick cheat sheet: Loop Types:For <var> = <start> To <end> (Step <amount to add>) / Next <var> For Each <itm> In <array / collection> / Next <itm> Do While...
by Jonathan Halder | Sep 18, 2024 | MS Access, MS Access Features, MS Access VBA Coding
As an Access developer, my typical knee jerk response to Macros is: DON’T USE MACROS, anything a macro can do, VBA can do! However, there are a couple of things macros can be used for that VBA actually can’t do. — GASP — WHAT??? One thing...
by Jonathan Halder | Sep 17, 2024 | Blogging, MS Access
I’m struggling through some client work right now and finding that I have found at least 3 ways of how not to get the results I’m trying to achieve. In this case it has to do with reporting to the user everything that has changed from the beginning of...
