Search results

I have been thinking about how to build tables for my book, and how that might fit into the purpose of the book, learning about how to use classes. I want to build some pretty specific little tables. I'll get into the why in a minute. For now, know that I didn't write the following code, I...

My blog I have been working on a book EventDrivenProgrammingInVBA which I am placing in a public GitHub so that anyone interested in the subject can get a free copy. Writing a book is a lot of work. Additionally getting editorial assistance is problematic. This is a free thing, so I cannot...

I had a poster in one of my threads post that if I did some thing his way it would avoid a circular reference, and how circular references could cause memory leaks (true) and how if Access crashed the end of the (access) world could commence. Not so true but worth dealing with. The point...

This thread is written solely to teach classes and framework concepts. To quote Paul, and it feels like I have done so waaay too often, there must be 50 ways to leave your lover. If you would like to teach how to use classes, events and frameworks, I encourage you to do so. Just not in this...

I have a new blog up about clsMsgPD which is a predefined or predeclared class which I use to pass messages around. In this case a client asked me to create a "big edit" form. The user could dbl-click into any text box following a naming convention and doing so would open a form with a single...

:)

Ages ago I wrote a little tool - C2DbProperties - to allow me to modify database properties. C2DbProperties The objective was the ability to open any "remote" non password protected database from my C2DbProperties tool, and set and reset the database properties most often troublesome to...

I use classes to generalize activities in the user interface. The objective is to standardize the interface across forms. For example every form can have an active / trash capability without having to do that in every form's code-behind-form class. One example from my past, I used a pair of...

I am writing a book on Event Driven Programming in VBA. It is coming along, and it is a LOT of work. I am using LibreOffice, and I am looking for any suggestions on anything related to the publishing subject. I am exporting to PDF and I am quite impressed with LibreOffice as well as the...

I read with interest a thread which described the machinations that folks went through to do something that is simple with RaiseEvent. The OP wanted a form with a ton of buttons on it. She created a clsBtn (good job) which the form used to encapsulate each buttons. As many buttons as the OP...

I downloaded the National Address Database last night. Unzipped it is 33 gb and change which is a tad too big for MS Access <grin> or even SQL Server Light. They provide a schema.ini with the field names and widths which seems like it could be used directly in the import process. But it has...

I've been doing this since the late nineties. I am finishing up working on a book on the subject which can be found on my blog about the subject. https://jwcolby.blogspot.com/2025/05/the-book-event-driven-programming-in.html?view=sidebar

I have spent decades doing classes and events, wrapping controls Withevents to extend their functionality. I am trying to get all the stuff out of my head and onto "paper". For now google Blogger John Colby. I cannot post a link here it seems. I hope you enjoy and find it useful.