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...
by Jonathan Halder | Sep 12, 2024 | MS Access, MS Access Forms, MS Access Queries
What? Combo dropdown group headers? What voodoo is this? I have a combo box on a continuous form in an Item Description field. Each row on the continuous form can contain a line item that can be populated from different sources. There is a job estimate source where...
by Jonathan Halder | Aug 27, 2024 | Blogging, MS Access, MS Access Features, MS Access Forms, MS Access Queries, MS Access Reports, MS Access Tables, MS Access VBA Coding
There are of course a multitude of uses for a relational database system. Remember that although natively Access defaults to storing data relationally in tables using the file based ACE system (Access Connectivity Engine), it can really use any ODBC or OLE DB...
