by Jonathan Halder | Sep 16, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
So yesterday’s form code: Text File Import / Export Recipe code | Access JumpStart refers to functions in a module called AppProcedures. What’s in this module? Used with the first form button: GetRawFileName() Function returns a string with a full path and...
by Jonathan Halder | Sep 15, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
A reader commented on my email last week asking about the code. So here’s some nuts and bolts in reference to the article: A Reusable Recipe for Importing and Exporting Text Files in Access. The user interface is a form with 2 buttons and 2 text boxes:...
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...
