AEU Meeting Date: 6 Dec 2023 starting at 18:00 UK Time (UTC) Page Last Updated 13 Dec 2023
Meeting Details:
This Access Europe meeting was on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) 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 in December, the UK is on Greenwich Mean Time (UTC). 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.
Topic outline:
Learn how to programmatically update import/export specifications in Access with a custom VBA class.
In this presentation, Mike will demonstrate his clsImExSpecs class. This simplifies working with import and export specifications by writing and modifying simple VBA, rather than fighting with the unintuitive Access wizards.
• How Access works with specifications behind the scenes
• Why changing system tables directly can cause problems
• Encapsulation, organization, and reusability benefits of classes
• Using clsImExSpecs to document existing specifications in VBA
• Streamlining workflows by avoiding context switching between code and UI
• Demonstration updating a real-world import specification
By attending, you will gain practical tips for managing specification changes in code rather than through awkward and inconvenient Access wizards. You will also learn how VBA classes can be used to solve real-world problems, rather than the typical "Cat is a type of Animal" nonsense that you often find in online tutorials.
Knowing when and how to effectively use class modules will take your VBA to the next level.
You should attend this presentation if you fall into one or both of the following categories:
• You are frustrated with the Import/Export wizards in Access and want a better way to manage import/export specifications.
• You keep hearing about how great class modules are, but you have no idea why or how you would use them.
NOTE:
Colin Riddington will be leading a related presentation in the June 2024 session of Access Europe.
For further details, see View & Edit Import/Export (IMEX) Data Task Specifications
Bio:
Mike Wolfe - 3x Access MVP
Mike runs Grandjean & Braverman, Inc., specializing in Microsoft Access and SQL Server software solutions for government, banking, and insurance clients.
He writes daily articles about advanced Access and VBA topics on his No Longer Set website, where he’s published over 1000 articles since 2020.
Mike first earned the Access MVP award in November 2021.
Further Reading:
Mike has also published a series of articles on his No Longer Set website related to the topics covered in this session
clsImExSpecs Presentation to the Access Europe User Group
Creating and Editing Import Specifications via the Wizard
Using the Wizard to Export to Text Files with Microsoft Access
Documenting the Import-Export Specification System Tables
Downloads:
Click to download a PDF of the presentation used in this session together with the ACCDB FE database and related files:
IMEX Specifications Presentation Approx 0.5 MB (PDF)
IMEX Example Database & Files Approx 1.1 MB (zipped)
Video:
The meeting was recorded and the video is now available on the Access Europe YouTube channel at https://youtu.be/VUEMv_05hws or you can click below:
-->
Colin Riddington Mendip Data Systems Last Updated 13 Dec 2023
|
Return to Access Europe Page
|
Return to Top
|