Access Europe – John Mallinson (Using VBE_Extras Add-In with Access)
Please join us for our monthly Access Europe session on Wed 5 Feb 2025 at 18:00 (6:00PM) London time (UTC)
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)———————————————————————————————————————————————–
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
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
======================================================================
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