by Jonathan Halder | Nov 16, 2023 | MS Access, MS Access Forms, MS Access VBA Coding, TDD
Ok, so now we have just created a test for creating an instance of a FormListener class, but there’s nothing in the class yet. What do we want to test next? I need to think about the next bit of functionality I will want in this class in a way that I can test...
by Steven Halder | Dec 5, 2022 | MS Access, MS Access Features, MS Access Forms, MS Access VBA Coding
The Access Web Browser Control is not a Web Browser Object, but does contain one. To access the internal workings of the control with VBA code, it is most convenient to dimension and use variables as follows, where the name of the control is “MyWebBrowserControl”: DIM...
by Steven Halder | Dec 5, 2022 | MS Access, MS Access Forms, MS Access VBA Coding
Case Study The issueA form contained several combo boxes linked to tables, sub-forms, and a delete button intended to delete the current record. The client noticed while deleting records that occasionally one of the combo box linked records would get...
by Jonathan Halder | Mar 7, 2022 | MS Access Forms, MS Access Queries
This error occurs because, drum-roll please…. The setting for this property is too long. So in this particular case, the developer was trying to create a long SQL string using multiple UNIONs with a complex query and trying to set this string to the RowSource...
by Jonathan Halder | Jun 18, 2021 | MS Access, MS Access Forms, MS Access Queries
I recently experienced a frustrating issue that had me scratching my head for a while. I had a PO form with a Line Item subform and I could edit lines and when I tried to delete a line it was removed from the subform. BUT… If I closed and reopened the same PO...
by Jonathan Halder | Jun 4, 2021 | MS Access, MS Access Forms, MS Access Reports
So I had a form that opened a report using a function in another module using DoCmd.OpenReport. This worked fine and the report popped open and appeared to be the active object on the screen. However, it was not. The behavior this caused was that when I clicked on the...
