AEU Meeting Date 2 July 2025 starting at 18:00 UK Time (UTC+1)                     Last Updated 16 Aug 2025



Meeting Details:

This Access Europe meeting will be on Wednesday 2 July 2025 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM)

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.

When the time comes for the meeting, please use the following link: 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:

Many forum threads are based on databases where people have built non-normal tables in order to show data in the way they want.
Typical examples include daily schedulers, surveys, checklists and hierarchical data.

This approach is sometimes known as the 'Excel in Access' mentality and is often because of limitations of what you can do out of the box with standard forms and subforms.

In this presentation, Pete will cover several techniques to build “non-normal” interfaces while keeping the data normal. This will include features such as:
•   Use of temp tables
•   Use of cross tabs for interface
•   ADO in memory recordsets
•   Custom unbound forms to act as a user control
•   Treeviews (light discussion)
•   Advanced sub data sheets

The idea is to expose the audience to some tips, tricks, ideas and approaches more than explaining the code. Many examples will be provided.



Background


Pete Poppe 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.



Downloads:

Click to download files used in this presentation:

PDF of the presentation slides:   Access Europe Presentation July 2025     Approx 5 MB

Item Genie database FE / BE:   Item Genie (split)     Approx 1.4 MB   (zipped)

Example Access database files:   Other 'Non Normal' Interfaces     Approx 5 MB   (zipped)



Video:

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

       

Mike Wolfe has now written a summary of the main points arising from this video. This is available on his NoLongerSet website:Outside the Box Access UI Design with Pete Poppe (Maj P)



Colin Riddington           Mendip Data Systems                 Last Updated 16 Aug 2025

Return to Access Europe Page

Return to Top