by Jonathan Halder | Oct 31, 2024 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding, TDD
This is an experiment today. I don’t think I’ll get fully through what I would want to do today, but I want to start a little series on using TDD along with a form in Access. What would the whole process look like from beginning to end? I’m thinking...
by Jonathan Halder | Oct 24, 2024 | Blogging, MS Access, MS Access Forms, MS Access Reports, MS Access VBA Coding
First of all, it’s good to know that you can add a report to a sub-report control on a form. If you need to display multiple groups of data for informational purposes on the form, this can be a real game changer! I have a routine I use that’s in my library...
by Jonathan Halder | Oct 17, 2024 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding, TDD, Versioning
Back 6 months ago I was asked to add new fields to check for the validity of a line item on an order. This caused me to go through a rather extensive process to break dependencies on an Access form so that I could test it without having to launch the form and build an...
by Jonathan Halder | Oct 9, 2024 | Blogging, MS Access, MS Access Forms, MS Access Reports, MS Access VBA Coding
When implementing logging in your Access app, some of the things you might want to log are: Opening and closing of objects which have VBA associated with them. Typically Forms and Reports. Try to add a log message which includes the primary key when you edit or add a...
by Jonathan Halder | Sep 16, 2024 | Blogging, MS Access, MS Access Features, MS Access Forms, MS Access Reports, MS Access VBA Coding
They sound the same, don’t they? But they aren’t!!! Often you want to control elements visibility on forms. For example, you might want to hide certain fields or buttons from view when you are adding a record instead of editing it. In a recent case for my...
by Jonathan Halder | Sep 13, 2024 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
Yesterday I discussed a Combobox I was adding dummy header lines into. See that message here: The Joys of Combo Dropdown Group Headers. My combo box is multiple columns and I use the extra columns to insert data into other fields on the line when the Item Description...
