AEU Meeting Date 7 Aug 2024 starting at 18:00 UK Time (UTC+1)                     Last Updated 12 July 2024



Meeting Details

This Access Europe meeting was held on Wednesday 7 Aug 2024 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:30 (7.30PM)

The start time is equivalent to 19:00 (7PM) in Central Europe and 10AM in Seattle / PST

Please note that the UK is currently on Summer Time (UTC+1). For local times, please check World Time Buddy

We use Zoom as our meeting application. Please click this link to Get Zoom if you don’t already have it.

The following link is used for all Access Europe meetings: Join Zoom Meeting
If you are asked, use: Meeting ID: 924 3129 5683 ; Passcode: 661210

For more connection options, please see the AccessUserGroups.org web page for this event

All sessions are recorded and later uploaded to the Access User Groups channel on YouTube

If you do not wish to be part of the recording, please ensure your webcam and microphone are both switched off during the meeting.



Download Outlook Calendar (.ics file):

Click to download. Save in Outlook to create a recurring event for each month:       Outlook Calendar (.ics)



Topic outline

In this session, Pete Poppe introduced the Treeview control and demonstrate when it can greatly benefit the display of certain types of data within Access applications. The treeview provides a means to show hierarchical data in a compact but expandable form.

Access does not have a native Treeview control but there is an Active X control and third-party versions.

The presentation explained when and how to use the treeview successfully and a “wrapper” class is provided that makes working with treeviews much simpler.

Treeview Example


Detailed Agenda

•   Introduction
      •   What a Treeview is
•   Examples
•   Basic Terminology
•   Two types of Treeview Controls
•   How to get and install
•   Utility / Value of Treeviews examples
•   Self-Referencing Tables
•   Recursion
•   Tieing the view to the data
•   Simple loading a Treeview and key methods
•   Listview Control and Images
•   The Wrapper Class
•   Loading using common query
•   The light load
•   Node click
•   Drag and drop



Background


Pete is currently working as a Data Analyst for a large Material Handling Company that sells, installs, and services everything that makes a modern warehouse run.

BSc in Civil Engineering from the US Air Force Academy and MSc in Operations Research from the Naval Postgraduate School. Served as a 20-year US Marine Corps officer with multiple assignments in “Combat Systems Development” and specifically Test and Evaluation (T&E).

This started Pete’s Access journey as a developer/user to support test and other engineering activities. Found he could do it better and cheaper.

He is not involved with Access in a professional capacity, but as a user it has been an invaluable tool throughout Pete’s career.

Pete has for many years been heavily involved with various forums where he focuses on solutions to complex problems such as optimization and mathematical modeling. Currently he is very active at Access World Forums with the user name MajP and his signature line is Access VBA Savant.



Further Info

In advance of the meeting, it will be useful to download/install the treeview controls that will be used in this session. Please see this link for instructions:
      How to Get and Load Treeview Controls

NOTE:       (thanks to Bernd Breckt for the following info)
If you have an older version of Access running in 64-bit Windows, you may have problems trying to load the ActiveX treeview control.
If so, you may need to 'register' the Microsoft Windows Common Controls 6.0 (SP6) library file, MSCOMCTL.OCX. See this article for more details:
      SOLVED: MSCOMCTL.OCX Download & Register on 64 Bit Windows



Download

Click to download the files from this session:
      Access Europe Presentation     PDF file          Approx 4.4 MB (zipped)
      Treeview Demo Database         ACCDB file     Approx 2.0 MB (zipped)       UPDATE 11 Aug - now includes bitmap images used in the treeviews



Video

The meeting was recorded and the video is now available on the Access Europe YouTube channel at https://youtu.be/XpEHuWcHang or you can click below:

       

The presentation was by far the best explanation of using treeviews that I've ever seen.
Well worth watching if you missed it . . . and to watch again if you were present!



Colin Riddington           Mendip Data Systems                 Last Updated 12 July 2024

Return to Access Europe Page

Return to Top