Access Europe – Dale Fye (Working with Command Bars and the Access Shortcut Tool)
Please join us for our monthly Access Europe session on Wed 3 Apr 2024 at 18:00 (6:00PM) London time (UTC+1)
This month, former MVP, Dale Fye will be leading a presentation in which he will first discuss his Advanced Shortcut Tool for working with Command Bars. He will then explain a Simple Audit Log he created for a client.
Topic outline:
Command bars and the Access Shortcut Tool:
After hearing many people complain on the various internet forums, and some discussions with other Access MVPs, Dale developed the Access Shortcut Tool to simplify the process of creating shortcut menus for use in Access applications. He did a lot of research during this process and wrote several articles for Experts-Exchange on the subject:
- Understanding and using Commandbars (Shortcut menus), Part 1
- Understanding and using Commandbars (Creating your own), Part 2
- Commandbars (Using built-in shortcut menus), Part 3
- Using shortcut (right-click) menus in the Access runtime environment
The Access Shortcut Tool is the culmination of his research into Command bars (shortcut menus).
A number of years ago, Dale had a client who needed to track all changes made within a database application. This was a financial database and he needed to be able to track whenever the value in any field in several of the database tables was changed. At the time, Dale found a workable solution that had been created and documented by the renowned Access MVP Allen Browne, so he started using it.
However, Allen’s solution required a separate history table for every table that was being logged, and wrote an entire record to that table whenever any field in the source table was changed. This resulted in some very large history tables.
In 2017, Dale had the occasion to revisit the need for an audit log for another project, and decided that he could write a relatively streamlined version of the process, with a single history table, and where he only logged the changes to each record. Dale developed his own Simple Audit Log. This application is form centric, it does not track changes made directly in tables. However, with relatively simple modifications, it can be modified to handle changes made through bulk imports and deletions.
Background:
Dale is a retired Army officer with a Masters Degree in Operations Research.
He spent the last ten years of his active military career doing data analysis and developing database applications in a combination of dBase, Clipper, and early versions of Microsoft Access. In total, Dale has over 29 years working with Access and a dozen years working with SQL Server (off and on).
Dale has participated in various on-line forums for Access for over twenty years and was selected as an Access MVP in 2013. He remained an MVP through to 2016, when family medical issues forced him to reduce the time spent on the various forums.
Dale worked as a database developer for a variety of US Government agencies and private corporations, until he started his own software company (Dev-Soln, LLC) in 2010. In 2014, Dale quit his day job and has been operating solely as a one-man development shop ever since.
Based in the USA, Dale was president of the Eastern Time chapter of AccessUserGroups.org until 2022.
His website is http://dev-soln.com
======================================================================
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