by Jonathan Halder | Mar 29, 2024 | MS Access, MS Access Features, MS Access Forms, MS Access Reports
I had generally used Subforms in Subform/Subreport controls as part of a standard form. I hadn’t even really thought too much about the fact that you could put report objects into a Subform/Subreport control. What pushed me in the direction of using a report in...
by Jonathan Halder | Mar 28, 2024 | MS Access, MS Access Features, MS Access Reports, MS Access VBA Coding
Sounds intriguing, doesn’t it? So what do I mean by running Access headless? I am referring to the term headless as it refers to running a machine without user intervention as an automated process. For example, I have some reports that get emailed out at certain...
by Jonathan Halder | Mar 18, 2024 | MS Access, MS Access Features, MS Access VBA Coding
I work on my own computers, a laptop and a desktop to do my main work on customer Access databases. Once I am at a point where I have something I want to give to the customer I want that process to work as quickly and as seamlessly as possible. Part of this process is...
by Jonathan Halder | Mar 15, 2024 | MS Access, MS Access Features, MS Access VBA Coding, TDD
I first have to let you know that I am NOT actually doing Test Driven development on live projects consistently. I have created some tests for client work in the past before coding, but it has been quite rare. I like the idea of Test Driven Development and would like...
by Jonathan Halder | Feb 20, 2024 | MS Access, MS Access Features, MS Access Forms
Yesterday we discussed replacing the Access Splash Screen with your own custom bitmap. Today We will discuss how to launch the app without seeing the Access database window and just using your main form. The technique involves a few different Access settings and a...
by Jonathan Halder | Feb 19, 2024 | MS Access, MS Access Features
There are some nice little features of Access and some nice tutorials and articles out there to help launch an Access app without making it obvious to the user it is an Access app. The first one I’m going to discuss today is: Replacing the Access Splash Screen...