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 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 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 22, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
Today I was debugging Access and was working in some complex code that iterated over a large number of records. I wanted to stop at a particular record and run through it step by step. The record could be identified by using the RS variable which represented a DAO...
