by Jonathan Halder | Aug 21, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding, TDD
I decided to do some tests today, but didn’t even get to writing any yet. The issue was that I had a function tied to a button click event event inside a form which referenced various controls on the form. Normally, it’s easy to refactor this by simply...
by Jonathan Halder | Aug 18, 2025 | Blogging, MS Access, MS Access Features, MS Access Forms, MS Access VBA Coding
Do you know what happens if you are in an Access text box and press Ctrl-A? You might expect all the text in it to be selected like a text box on a web page or in a Word document. But it doesn’t. If you are in a text box on a form in the normal single form view...
by Jonathan Halder | Jun 16, 2025 | Blogging, MS Access, MS Access Forms, MS Access Tables, MS Access VBA Coding
This is an entire planet to explore in and of itself. There are multiple layers of sharing when it comes to creating Access databases and applications with multiple users. Although fraught with land mines, users can use the same Access front end at the same time. This...
by Jonathan Halder | Jun 12, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding, TDD
Ok, so this really doesn’t qualify as test driven development because a key of that discipline is to automate your tests. That means you actually would have a set of functions that would automatically test various things as you create them and you leave those...
by Jonathan Halder | Jun 5, 2025 | Blogging, MS Access, MS Access Forms, MS Access Queries, MS Access VBA Coding
Today I updated a form and added a new filter textbox to it to allow the customer to specify part of a part number and filter a list of CSV files that contain that part number. It’s actually already processed these files and the data for all part numbers is in a...
by Jonathan Halder | Jun 2, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
What did I do today? I have a complex order form I built according to customer specs. They have several different scenarios and ways in which they can open an order in the form and I did not build the form so that it is capable of opening multiple orders at once. In...
