by Jonathan Halder | Feb 15, 2024 | MS Access, MS Access Features, Versioning
What is Access JumpStart? Thanks for asking. Access JumpStart is our collective work as a two man programming outfit to share common code for our apps across multiple clients, architectures, and configurations. Steve and I call it a framework. It originally was named...
by Jonathan Halder | Feb 6, 2024 | MS Access, MS Access Features, MS Access VBA Coding, TDD
We are in a refactor cycle, so it’s time to look at my mess and see what I can do to clean it up a bit. I had to make a number of changes to the test in order to test multiple fields at once. It didn’t work with my existing function which changed a single...
by Jonathan Halder | Jan 10, 2024 | MS Access, MS Access Features, MS Access VBA Coding
Here’s a question. How can you run Access without paying for a license? Answer: Use the Access runtime version! Download and install Microsoft 365 Access Runtime – Microsoft Support The Access Runtime version exists so that if YOU develop a database...
by Jonathan Halder | Dec 18, 2023 | MS Access, MS Access Features, MS Access Forms, MS Access Queries, MS Access Reports, MS Access Tables, MS Access VBA Coding
Refactoring code is something I do often. Trying to find ways to make things simpler and more readable are two reasons of many that I do this. As I work on code and refactor it, I find myself continually, daily, using tools to find and replace code, and not quite as...
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...
