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...
by Jonathan Halder | Jun 26, 2024 | MS Access, MS Access Forms, MS Access VBA Coding, TDD
I now have a real-world scenario for requirements for this class. Requirements are coming from customer requests and then interpreted into a list for myself. Test Driven Development then takes requirements and you translate them into tests (one at a time). Just...
by Jonathan Halder | Jun 17, 2024 | MS Access, MS Access Forms, MS Access VBA Coding
I had an application today with lots of flickering on a form containing two subforms in continuous mode. When I first load the main form it flickers a little bit, sometimes longer than others (seemingly depending on where my mouse is sitting). Often moving the mouse...
by Jonathan Halder | Jun 13, 2024 | MS Access, MS Access VBA Coding
According to the RubberDuck refactoriings page, the definition of the Introduce Parameter refactoring is: Introduce Parameter Select a local variable to promote to a parameter. Call sites for the containing procedure will be updated with a TODO argument, which must...
by Jonathan Halder | Jun 12, 2024 | MS Access, MS Access VBA Coding
I have discovered another source of documentation from the RubberDuck git repository which contains some descriptions of the refactoring options. Here is the link: Refactorings · rubberduck-vba/Rubberduck Wiki · GitHub According to this page, the Encapsulate Field...
