by Jonathan Halder | Aug 19, 2024 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding, TDD
Yesterday’s message: Writing tests for legacy code – Part 4 | Access JumpStart Here is the full code I am discussing: ‘@TestMethod(“DeleteAction”) Private Sub GivenConcreteGroupDeleteTriggered_WhenReadOnlyStatusType_RequirePassword() On Error...
by Jonathan Halder | Aug 8, 2024 | MS Access, MS Access Forms, MS Access VBA Coding
I was working with a friend yesterday and he was showing me how he was showing a bound dropdown list on a combo box on a bound form. He was using a UNION query and VBA to update the combo box RowSource value each time to include another row in the dropdown if the...
by Jonathan Halder | Jul 24, 2024 | MS Access, MS Access Features
It’s important to choose the right tool for the right job. What about Microsoft Access? When is it the best or at least a good tool for the job? Or turning around the question, what are the best jobs to use Access for? The first thing to remember is that Access...
by Jonathan Halder | Jul 11, 2024 | MS Access, MS Access Features, MS Access Forms, MS Access Queries, MS Access VBA Coding
I’m revisiting my ListBox control work from these two articles: Access ListBox Row Source and Type | Access JumpStart ListBox Column size adjustments | Access JumpStart The second article discsusses how to adjust column sizes using the ColumnWidths property and...
by Jonathan Halder | Jul 9, 2024 | MS Access, MS Access Forms, MS Access VBA Coding
In a previous article, I discussed a listbox conundrum I had with really long lists: Access ListBox Row Source and Type | Access JumpStart One of the things I wanted to do with this listbox was adjust the column sizes of the list on the fly, depending on the size of...
