by Jonathan Halder | Oct 14, 2025 | Blogging, MS Access, MS Access Queries, MS Access Tables, MS Access VBA Coding
I utilized a couple of library routines I built to manage an Excel export. Step 1 – Get an Excel object from a function which opens a particular xlsx file as a template, then copies it to a new file name given by the function. I have other functions which can...
by Jonathan Halder | Oct 13, 2025 | Blogging, MS Access, MS Access Queries, MS Access VBA Coding
Today I was pulling in some SQL code from SQL Studio I wanted to put into a string and run from a VBA routine to update some views on the production database. Because I use MZ Tools, I chose to use the find and replace function along with regular expressions to pick...
by Jonathan Halder | Sep 29, 2025 | Blogging, MS Access, MS Access Forms, MS Access Queries, MS Access VBA Coding
Over the weekend I was working on a query for a drop down list for items on a PO. The list had 2 sections: Job Estimated Items Vendor Items Each section would show up in different circumstances with different items, but usually they show up together. Each section had...
by Jonathan Halder | Sep 26, 2025 | Blogging, MS Access, MS Access Forms, MS Access Queries, MS Access Tables, MS Access VBA Coding
This is a little different than my usual email, but just decided to decompress from what I was working on today before heading into the weekend. I worked on a couple interesting things today: A Launcher app using a class object to authenticate and connect to a...
by Jonathan Halder | Sep 4, 2025 | Blogging, MS Access, MS Access Features, MS Access Queries, MS Access Reports, MS Access VBA Coding
Don’t be afraid to refactor something if it’s getting too complicated. One of my customers often will have new ideas for reports or forms in the Access app that would really help him make his business better and his life easier. Many times these ideas will...
by Jonathan Halder | Sep 3, 2025 | Blogging, MS Access, MS Access Features, MS Access Forms, MS Access Queries, MS Access Tables, MS Access VBA Coding
Ever wonder what a developer running a sole proprietorship does? Here’s a little snapshot of my life this week. This week i’ve been up to a couple of things: I’ve updated a client to provide a button to their navigation to open a particular query....
