AEU32: Drag and Drop: Behind the Scenes (Alessandro Grimaldi)

In this month's presentation, Alessandro Grimaldi demonstrated several examples of his Access interactive interfaces, including some already presented at Access DevCon in recent years to great acclaim.

Following many requests, Alessandro went 'behind the scenes' and outlined the code structure of his 'drag and drop' engine, on which most of these examples are based. This procedure, and other methods he uses to create his interfaces, are detailed in his book Advanced interactive interfaces with Access, which was published by the American publisher APress on 7th October in both softcover and e-book formats.

Alessandro also showed a quick preview of the application he is currently working on, an innovative ribbon builder.

Website: https://alessandrogrimaldi.com
Book: https://link.springer.com/book/10.1007/979-8-8688-0808-1

TIMES
00:00 Colin - welcome
00:22 New Access User Groups
01:34 Forthcoming events
02:18 Introduction to Alessandro
02:35 Presentation starts
03:39 Presentation goals
04:33 Agenda
06:32 The book: "Advanced interactive interfaces with Access"
07:38 Dynamic interfaces, ex. 1: AIDA
11:30 Dynamic interfaces, ex. 2: VeLo (Vessel Loader)
12:46 Dynamic interfaces, ex. 3: Happy Berthday! (Port Manager)
15:16 Importance of classes
16:32 Sketching the Drag and Drop
21:30 The Master-Slave class technique
28:41 Recap of technique
31:51 Brief comment / review by Colin followed by questions
32:24 Q1: Ben S - Would the code work in an .accde file?
34:36 Q2: Tim F- Can collections can be used in place of arrays?
36:15 Q3: Ant - What if the moved image falls off the form?
37:12 Q4: Neil - Data associated with the dropped image
39:03 Q5: Neil - Does the MouseMove() miss events if the mouse moves quickly?
40:46 Q6: Ade - Discussion about the X/Y parameters of the MouseMove()
43:22 Q7: Chris K - Is image postion recorded on mouse down?
43:53 Q8: Tim - Differences compared to Aleksander Wojtasz's Gantt Charts
46:49 Alessandro: Demo of Ribbonizer app currently being developed
52:24 Q9: Can the ribbon XML be used in Excel?
52:58 Q1 Will Ribbonizer be a stand-alone app or an add-in?
53:12 Conclusion
53:34 Alessandro's book is now available from: https://link.springer.com/book/10.1007/979-8-8688-0808-1
54:29 Next month: an image/photo cataloguer (Chris Arnold)
57:32 End

Видео AEU32: Drag and Drop: Behind the Scenes (Alessandro Grimaldi) канала AccessUserGroups.org