Differences

This shows you the differences between two versions of the page.

--- 12114:demo [2024/04/15 04:48 UTC] – [Create the Tool Window Controls] mwolfe
+++ 12114:demo [2024/04/15 05:12 UTC] – [Edit the Code in myToolWindow.twin] mwolfe
@@ Line 77: / Line 77: @@
 </code>
+===== Test the Updated Addin =====
+  - Make sure Access is closed then **Build** the tB project
+  - Reopen Access and switch to VBA
+  - Enter sample text ''oVehicle'' for object class name and ''collVehicles'' for collection class name then click [Create Collection Class]
+===== Strongly-Typed Collection Class =====
+Now, let's talk about what this add-in will actually, you know, //do//.
+The purpose of the add-in is to encapsulate the ''BuildStronglyTypedCollection()'' function as described here: [[https://nolongerset.com/strongly-typed-collection-classes-the-easy-way/|Strongly-Typed Collections: The Easy Way]]
+I put a link to this article in the Resources page for today's presentation.  If you've never heard of strongly-typed collection classes, I recommend you read up on them after today's presentations.
+For our purposes, the important thing to know about them is that you CANNOT build them in the VBA editor.  They require setting a couple of hidden code attributes that only appear when you export the code module to a text file.
+As you can imagine, manually jumping through those hoops is inefficient and error-prone.  The existing code I wrote in VBA does automate the process, but it requires importing several additional dependencies.  Our VBE add-in will be a direct replacement for the ''BuildStronglyTypedCollection()'' function.