by Jonathan Halder | May 17, 2024 | MS Access, MS Access Features, MS Access Queries
One great thing about Access is all the various ways it can connect to data in tables. Using ODBC, Access can connect to anything with an ODBC driver that you can install. I’ve done connections using datasource names as well as DSN-less connections to SQL...
by Jonathan Halder | May 16, 2024 | MS Access, MS Access Features, MS Access Forms
I have been slack in writing for the past week. The main obstacle is that I had a great suggestion about writing more to my target market in terms of Access JumpStart. This turned out to be a big pivot in my thought process, and I’m not sure I’m there yet....
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...