by Jonathan Halder | Sep 17, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
Implementing an interface can only be done from a class module. The class module uses the “Implements” keyword at the top and won’t compile unless you create all the appropriate functions from the interface. Yesterday I showed the code in the...
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 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...
