AEU Meeting Date 5 Feb 2025 starting at 18:00 UK Time (UTC)                     Last Updated 23 Oct 2024



Meeting Details:

This Access Europe meeting will be on Wednesday 5 Feb 2025 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 the UK is currently on Winter 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.



Download Outlook Calendar (.ics file):

Click to download. Save in Outlook to create a recurring event for each month:       Outlook Calendar (.ics)



Topic outline:

Introduction
•   What is VBE_Extras?
•   Why VBE_Extras isn't the same as MZ-Tools … high level compare / contrast
•   Brief history of VBE_Extras
•   How to get VBE_Extras: https://www.thevbahelp.com/vbe-extras-download
•   Licensing / offer

Demonstration - main commands / functionality of VBE_Extras:
•   Immediate window: clear / go to start / go to end
•   List declarations in this Procedure / Property … Module … Project
•   Go to declaration for code at cursor
•   References for code at cursor
•   Go to previous code reference in this Project / Go to next code reference in this Project
•   Highlighting
•   Rename code at cursor
•   Sub to run / Run Again
•   History - Back / Forward
•   Show History
•   Module Picker
•   Attributes
•   Add Factory
•   Full Screen
•   Themes
•   Compare Module / Project
•   Version Control
•   Update Project References
•   Show All Members
•   Special binding
•   Add Enum from Type Library / Add a "GetEnumAsString()" Function

Screenshots

1.   Highlighting
      The 'Highlighting' command (in this case, see boxes around 'strFileName').


2.   References for code at cursor
      The 'References for code at cursor' command (for the same code as used for 'Highlighting').


3.   File Name Dialog
      The 'Rename' dialog (for the same code as used for 'Highlighting').


4.   Compare Modules Dialog
      Screen shot from the 'Compare Modules' dialog, via the 'Compare Module', 'Compare Project' or 'Version Control' commands.
      Key: red highlight = removed code; green highlight = added code; yellow highlight = updated code; blue highlight = change-of-case.


5.   Themes Dialog
      Creating a theme




Background:

John Mallinson is based in West Lothian, Scotland and has been using VBA for over 20 years along with other languages (most recently, mainly C#).
He worked for large corporate IT companies until 2019 . . . since then, freelancing on Upwork.

The basic (pun intended) nature of the Visual Basic Editor (VBE) frustrated him enough to try and make it more "Visual Studio – like" by creating VBE_Extras.
(Visual Studio is the tool that John uses to write C# code)

John's primary focus is on Excel, Word, Outlook and PowerPoint … not Access (but we'll forgive him!).
However, VBE_Extras has been designed to work in Access as an add-in along with the other Office applications.

Website: VBE_Extras




Download:

Any files for this presentation will be made available just after the session



Video:

The video of this session will be edited and uploaded to YouTube a few days after the meeting.
This article will be updated with a link to the video when that happens.



Colin Riddington           Mendip Data Systems                 Last Updated 23 Oct 2024

Return to Access Europe Page

Return to Top