Скачать или смотреть AEU36: Using VBE_Extras add-in with Access (John Mallinson)

In this presentation, UK developer, John Mallinson demonstrated a selection of features from his VBE_Extras add-in.
The add-in works across all Office apps but the focus of the session was on its use with Access

Introduction
• What is VBE_Extras?
• Brief history of VBE_Extras
• How to get VBE_Extras: https://www.thevbahelp.com/vbe-extras...
• Licensing / offer

This was followed by a demonstration of the main commands / functionality of VBE_Extras.

The presentation slides are available as a PDF from https://www.isladogs.co.uk/aeu-36/

TIMES
0:00:00 Colin - welcome to the Access Europe User Group and to this month's presenter John Mallinson
0:00:44 Intro by John
0:01:17 About VBE_Extras
0:03:02 How to get VBE_Extras
0:03:50 VBE_Extras Commands (and comparison with MZ-Tools)
0:05:22 Outline of presentation demonstrated
0:05:34 Demo - VBE_Extras toolbar in the VBE / context menus / keyboard shortcuts / command search
0:08:30 Clear immediate window / go to start / go to end (using menu / toolbar or automatically via settings)
0:11:58 List all declarations used in procedure / module / project
0:19:08 Testing 'ThisThing' showing VBE_Extras can correctly handle same name used for different purposes.
0:20:46 Use of highlighting tool to identify line labels, variable, declarations, events, type, keywords, open/close quote marks & parentheses etc
0:25:36 Rename code at cursor - event names, line labels, module references etc
0:27:54 Sub to Run (F6) ; Sub to Run Again (F10) - allow you to edit code in one place and run code in another place
0:30:51 History - easily navigate Back/Forward through code
0:33:07 Module Picker - easily navigate through modules using keyboard only (Ctrl+Tab)
0:35:00 Make code pane full screen hiding other VBE panels (Alt+Shift+Enter)
0:37:38 VBE Themes - much impro ved version of the built-in VBE Editor Format screen
0:41:45 Show All Members (Ctrl+period) - improved intellisense compared to VBE List Properties / Methods dialog.
Also for context-sensitive autocomplete e.g.Dim x As . . . shows list of properties & methods for each library
0:46:30 Improved References Dialog - resizable; can be filtered; additional details; explore library members
0:47:58 Special Binding - allows use of intellisense with late binding (without adding library reference)
0:49:57 Update Parameters
0:53:02 Interfaces (following on from Philipp Stiefel's AEU presentation in January) - implement/extract interfaces
0:55:49 VBE Extras works in other Office programs - example of use in Excel
0:57:33 Download VBE-Extras - fully functional for 60 days to try out with online help for each command. Purchase for $30 USD per year
0:m58:26 Review / prize draw / lots of highly complimentary comments from chat
1:01:02 Q1 - Neil: is there a shortcut for inserting item found using Show All Members - A1: Yes - Alt+I. Users can also add own shortcuts
1:02:10 Thanks to John for an excellent presentation
1:02:18 Next month on Wed 5th March - Alexander Denz will be discussing his AI-powered Assistants tool
1:05:51 April's AEU session will now be led by former MVP Anders Ebro from Denmark on Using Class Modules
1:07:00 Colin discussed defeating Co-Pilot with a relatively simple question about where the Aptos font is registry
1:07:54 Q2 - Ben: asked how Alexander's tool handles source code protection. A2: code is protected by default.
Is it a paid tool? Yes - details will be provided next month
1:09:51 Final comments. See you all next month.
1:10:31 End