by Jonathan Halder | Sep 10, 2025 | Blogging, MS Access
I was thinking today about productivity. Not in the abstract, but in the “what am I actually wasting time on?” kind of way. You know the drill—those little things that pile up and eat away at your day before you even realize it. One of the big ones for me is time...
by Jonathan Halder | Sep 9, 2025 | Blogging, MS Access, MS Access VBA Coding
Today I extended a class based file conversion tool. I have different text files and need to be able to import a particular text file and export it into a new format, basically doing different transformations to the line items. I did some work in the past on this for...
by Jonathan Halder | Sep 8, 2025 | Blogging, MS Access, MS Access Forms, MS Access Reports, MS Access VBA Coding
Subform navigation systems on a form can get a little tricky at times. I am currently working on a Subform / Subreport control on a form that lists all the shipment records for a single job in order of the shipping date and time. Because the customer wanted a numeric...
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....
by Jonathan Halder | Aug 27, 2025 | Blogging, MS Access, MS Access Queries, MS Access Tables, MS Access VBA Coding
A few years ago I wrote a routine to copy an Access query or table to a block of Excel cells because I was having issues with DoCmd.TransferSpreadsheet not being able to always do what I needed. I found that copying the entire recordset to an array variable and then...
