12114:demo

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
12114:demo [2024/04/15 04:54 UTC] – [Edit the Code in myToolWindow.twin] mwolfe12114:demo [2024/04/15 19:11 UTC] (current) – [Demo Script: DevCon 2024] mike
Line 1: Line 1:
 ====== Demo Script: DevCon 2024 ====== ====== Demo Script: DevCon 2024 ======
  
 +  * I have 25 minutes for the demo portion:
 +    * 0:01: Download and open twinBASIC
 +    * 0:02: Customize add-in name and description
 +    * 0:04: Create the tool window controls
 +    * 0:05: Edit the Code in myToolWindow
 +    * 0:07: Test in Access
 +    * 0:10: Explain Strongly-typed collections and copy ''BuildStronglyTypedCollection()'' function
 +    * 0:15: Bring in other dependencies
 +    * 0:16: Test in Access
 +    * 0:18: Test in Barebones Access
 +    * 0:22: Convert fafalone's WinDevLib package
 +    * 0:24: Build 64-bit version
 +    * 0:25: Explain ''regsvr32'' registration; mention InnoSetup
 ===== Download and Save Sample Code ===== ===== Download and Save Sample Code =====
  
Line 76: Line 89:
     End Sub     End Sub
 </code> </code>
 +
 +===== Test the Updated Addin =====
  
   - Make sure Access is closed then **Build** the tB project   - Make sure Access is closed then **Build** the tB project
   - Reopen Access and switch to VBA   - 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]   - 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 later.
 +
 +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.
 +
 +===== Copy the VBA Code Into twinBASIC =====
 +
 +  - Create a new module named MyModule.twin
 +  - 
  
 ===== Build and Test the Addin on a Different Machine and Bitness ===== ===== Build and Test the Addin on a Different Machine and Bitness =====
  • 12114/demo.1713156889.txt.gz
  • Last modified: 2024/04/15 04:54 UTC
  • by mwolfe