Access Europe – Using Treeviews with Access Applications (Pete Poppe)

Please join us for our monthly Access Europe session on Wed 7 Aug 2024 at 18:00 (6:00PM) London time (UTC+1)

You can click the button below to download a small calendar (.ics) file and add the meetings to your Outlook calendar.  This will add a recurring appointment to the first Wednesday of each month.

Outlook Calendar (.ics)

======================================================================

Topic Outline:

In this month’s presentation, Pete Poppe will introduce 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 will provide basics on working with the treeview and provide a “wrapper” class 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
  • Tying 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

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

Biography:

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.

Not involved with Access in a professional capacity, but as a user it has been an invaluable tool throughout Peter’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.

IMPORTANT NOTE

All sessions will be recorded and later uploaded to the AccessUserGroups channel on YouTube: AccessUserGroups.org – YouTube.

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

======================================================================

We use Zoom as our meeting application.

Please click the link below to download Zoom, if you don’t already have it.

Get Zoom

To join our meetings, please use the following link or phone number

Join Zoom Meeting

If you are asked:

Meeting ID: 924 3129 5683
Passcode: 661210

Dial by your location:
+1 669 900 9128 US (San Jose)
+1 253 215 8782 US (Tacoma)
+1 301 715 8592 US (Washington DC)
+1 312 626 6799 US (Chicago)
+1 346 248 7799 US (Houston)
+1 646 558 8656 US (New York)
+43 12 535 502 Austria
+32 1579 5132 Belgium
+359 3 257 1633 Bulgaria
+385 1300 0988 Croatia
+420 5 3889 0161 Czech Republic
+45 32 70 12 06 Denmark
+358 9 7252 2471 Finland
+33 1 7037 9729 France
+49 69 7104 9922 Germany
+30 211 198 4488 Greece
+36 1 779 9126 Hungary
+353 1 653 3898 Ireland
+39 069 480 6488 Italy
+352 2786 4277 Luxembourg
+356 2778 1288 Malta
+31 20 241 0288 Netherlands

+48 22 307 3488 Poland
+351 308 810 988 Portugal
+40 31 630 1088 Romania
+421 233 418 515 Slovakia
+386 1600 3102 Slovenia
+34 917 873 431 Spain
+41 43 210 71 08 Switzerland
+46 850 539 728 Sweden
+44 203 481 5240 United Kingdom
+44 208 080 6591 United Kingdom

Meeting ID: 924 3129 5683
Passcode: 661210
Find your local number: https://zoom.us/u/a4d0JdR88