AEU4 - Standard Module Object Generation (SMOG) - Alan Cossey
In this month's session, Alan Cossey demonstrated his Standard Module Object Generation (SMOG) application. This is an Access add-in used to generate VBA code which provides compile-time error checking and Intellisense for database objects such as tables and queries as well as their fields, records, parameters and so on, thus making code-writing quicker and more robust.
The SMOG add-in and the presentation from this session are now available to AEU subscribers at: https://accessusergroups.org/europe/m...
TIMES:
0:00 Welcome by Colin Riddington
0:28 Alan Cossey - background info
1:57 Outline of SMOG add-in
4:40 SMOGify - SMOG add-in creates objects allowing use of intellisense & compile time checking
5:01 SMOG demo
5:48 Table fields with intellisense using SMOG
7:30 Query fields
8:25 Parameter queries
11:04 Evaluate parameters - optional
12:50 Intellisense with query fields and SQL
13:55 User interface form to generate or SMOGify objects
15:07 SMOG tables module code
17:06 SMOG queries module code
18:09 SMOG forms module code
18:21 Audience questions: Adrian B - what are the main benefits of SMOG? Intellisense / reduce risk of coding error / shorter code for developers
24:55 Chris A - questions on parameter queries & column headings in crosstab queries
27:11 Colin R - question - if SMOG code run again for new fields, is existing code replaced? Yes
27:48 Alan C - SMOG limitations - no effect on speed / no memory leaks / error handling built in
29:40 Juan S / Chris A - questions about moving / deleting SMOG objects
30:40 Colin R - questions about stacked queries & multivalued fields
31:36 Alan C - Persisted Public Variables - local / remote
32:58 Managing application options / database properties
34:17 Juan S - question - can SMOG be used with very large apps? Yes
36:35 Colin R / Juan S / Adrian B - questions - can form row sources & record sources work with SMOG? No
40:31 - Chris A - does SMOG work with linked SQL tables? Yes
40:50 Alan C - Install add-in method 1 - using Add-In Manager on ribbon
43:00 Colin R - does add-in work in 64-bit Access? Yes
43:30 Alan C - Add-in user system table - USysRegInfo
44:04 Alan C - Install add-in method 2 - Access Options ... Add-ins
44:30 Klaus O - is source code available for viewing? Yes
46:21 Chris A - does SMOG add-in need to be distributed to clients? No - developer use only
47:00 Pete B - Discussion - Re-smogify or Rees-Mogg-ify ?!?
51:20 Next month - Mike Wolfe - Building Ribbon Interfaces in Code
52:05 Juan S - Access Conference in Madrid - Sat 18 June 2022 - in Spanish with English translation
53:29 Concluding comments