Access Europe – Olaf Nöhring (An Improved, Enhanced Message Box) / André Minhorst (Enhancing Access Forms)

Please join us for our monthly Access Europe session on Wed 3 July 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)

—————————————————————————————————————————————————–

Session outline:

In this session, we will have two presenters from Germany – Olaf Nöhring and André Minhorst.

1.   Getting Attention With Style – An Improved, Enhanced Message Box (Olaf Nöhring)

The standard VBA message box enables us to provide information for users and act upon user responses to questions.
The message box is very simple and has never been updated.

Various improvements have been made by individual developers over the last 30 years.
The Enhanced Message Box was originally developed by Renaud Bompuis about 15 years ago.
It is (almost) a drop-in replacement for the standard message box but offers some advanced features like displaying Access rich text format – color, bold, italic, fonts.

But there is even more in Olaf Nöhring’s improved version: A simple wizard lets you create the box you want, including VBA code, different colored buttons, custom default button, auto close and enable-delay.

Enhanced Message Box

Best of all: It’s completely free. Can’t wait? Download it here: Improved, Enhanced Message Box

Bio:

Olaf_Nöhring
Olaf Nöhring started using Access in 1999. Now, more than 20 years later, he is still convinced it’s a powerful tool that is often significantly underestimated.
Olaf specializes in offline and online database development and individual software for medium sized companies.
Whilst he prefers using Access for offline development, he uses PHP for online.

Since 1998 he has been self-employed. After finishing studies in 2004, he taught for almost 15 years before leaving teaching in December 2021.
He holds a Masters degree in economics (Dipl.-Hdl.), a M.A. Education and Media: eEducation and a M.Sc. Psychology.

Website: https://datenbank-projekt.de/

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

2.   Enhancing Access forms with Outlook-style Calendar and Windows Explorer (André Minhorst)

André will introduce two exciting enhancements for Access applications, designed to streamline and enhance user experience.

Firstly, amvCalendar , offers a comprehensive solution for managing appointments within Access applications.

activex

The appointment data is directly stored in tables and can be used or edited all over the database. Consisting of a collection of Access objects that can easily be integrated into any database application, amvCalendar provides a user-friendly interface reminiscent of Outlook’s calendar functionality.

kalender_full

This becomes particularly crucial in uncertain times regarding the longevity of VBA support in Microsoft Outlook, making it imperative to have reliable alternatives readily available.

Secondly, amvExplorer addresses the common challenge of managing data associated with external documents within databases. Many databases contain information linked to documents stored in the file system, and amvExplorer provides a seamless solution for this scenario.

explorer_kunde

By seamlessly integrating with a specific folder related to a recordset (such as customer, project, or product data), amvExplorer allows users to effortlessly view, add, rename, and remove files. While similar functionalities were achievable through the classic web browser control, amvExplorer introduces a host of compelling features. Notably, it enables the tracking of user operations, empowering developers to respond dynamically to file management actions like addition, renaming, and removal through user-defined events. Furthermore, it offers enhanced usability by restricting users from selecting alternate folders within the form, ensuring a focused and intuitive experience.

Through these innovations, André’s company continues to pioneer advancements in Access application development, offering practical solutions to common challenges and elevating the capabilities of Access developers worldwide.

Bio

André Minhorst

André has been writing about Microsoft Access since 1998. His journey with Access began during his mechanical engineering studies, and since then, he has become a prolific author, sharing over 15,000 pages of Access and VBA expertise in numerous books and magazines. Through his own small publishing house, he has brought valuable insights and knowledge to the Access community.

In addition to his writing, André develops tools tailored for Access developers. Among his most popular offerings is the Ribbon-Admin 2016, a tool designed for crafting ribbon definitions for Microsoft Access applications.

Despite Microsoft’s limited focus on enhancing the functionalities of Access, André believes that there remains ample opportunity for developers to augment the platform with their own innovative solutions. Through his work and dedication, André continues to empower Access developers to unlock the full potential of the platform.

Website: Shop@minhorst.com

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

IMPORTANT NOTE

All sessions will be recorded and later uploaded to the AccessUserGroups channel on YouTubeAccessUserGroups.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