by Jonathan Halder | Nov 13, 2023 | MS Access, MS Access VBA Coding, TDD
Why do we want to use Test Driven Development? It is less error prone, producing better code which is more reliable and able to be verified from multiple paths. It allows us to express our intent in the form of a test. This forces us to create a better design. It...
by Steven Halder | Dec 5, 2022 | MS Access, MS Access Features, MS Access VBA Coding
You can control how your project is compiled. Have one “source base” that you use for multiple purposes, environments, or in multiple “modes” of operation. You can use Microsoft defined Compiler Constants and you can define your own....
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 Steven Halder | Jan 31, 2022 | MS Access, MS Access Features, MS Access VBA Coding
So you’re updating some VBA code you wrote a while back… Now what is the Error Processing section doing? What do those Error Numbers mean? I shoulda’ written some comments! Well you can just look up each of those error descriptions quickly by using...
by Steven Halder | Jan 27, 2022 | MS Access, MS Access VBA Coding
So your Access application crashed and user feedback is not specific enough to diagnose the problem? It sure would be nice if your application VBA code could send you an email with all the error details! Well, The Smiley Coder has written and published just such a...
