Скачать или смотреть AEU42: New and Forthcoming Features in Access (Colin Riddington)

In this session, Colin demonstrated several recently released new Access features including:
• VBA support for modern charts
• command line project signing and timestamping
• new Create SQL Query button
• significant improvements to the Monaco SQL editor.

Colin also discussed the scope of two recently announced Access features that will be rolling out to users later this year: Responsive Forms and Large Monitor Support

Download a PDF of the slides, feature wish list, articles and other files referenced in this presentation from https://www.isladogs.co.uk/aeu-42.

TIMES
0:00:00 Welcome by Colin to the Access Europe User Group followed by an outline of today's presentation
0:02:31 VBA Support for Modern Charts - allows users to change chart properties at runtime
0:03:04 DEMO Programming Modern Charts - build chart / format chart / chart data options / chart series options / line charts / arc & doughnut charts etc.
0:16:57 Questions: Property Enums / Chart Settings Task Pane & Property Sheet / Save Settings
0:24:03 VBA Project Signing - Command line signing
0:25:09 DEMO Code signing from VBE / command line signing & right click File Explorer shortcut
0:32:41 Timestamp code signature - edit registry
0:34:58 Question: is code available to detect if a project has been signed - not yet but a boolean IsSigned function has been requested
0:41:16 DEMO New SQL Query button on the Create ribbon
0:42:51 Monaco SQL Editor improvements
0:46:50 Question: Monaco improvements - does speedy loadng have impact on system resources? A: very little impact if any
0:48:35 Responsive Forms (& Large Monitor Support) - will start to roll out in Sept 2025
0:49:15 Colin's wish list as presented to Access team - Jan 2025. Almost all of this will be implemented in next few months - form & report view / datasheet view / design view
0:53:29 DEMO Automatic form resizing (AFR) - available now as a free custom solution with similar functionality - resize / reposition controls; stretch / shrink; form & datasheet view
0:59:30 Large Monitor Support - details of new maximum form width still to be confirmed by Access team
1:00:13 DEMO - Access form with modern chart extended over 2 monitors side by side - uses anchoring to give total width approx 36 inches - far higher than official width limit
1:03:04 Question: Will total report height be increased - hopefully.
1:03:34 Links to realted articles & example apps. Go to https://isladogs.co.uk/aeu-42 for the full list of links
1:04:07 What features are coming next? In 2026 and beyond
1:05:06 Q1; which slider control was used in the AFR DEMO? A: Standard MS ActiveX control. Similarly for spin & treeview controls. Also works with iGrid ActiveX control
1:05:48 Q2: how will Access manage the increased form width - change from INTEGER to LONG? New number datatype? Not yet known
1:07:05 Q3; how did stretch / shrink resizing work with the form aspect ratio?
1:07:37 Q4: Best way of submitting a feature request to the Access team? Via feedback portal or ask an MVP to submit on your behalf
1:07:58 Next month (Wed 3 Sept) Adam Waller:Version Control for the Sole Developer
1:10:34 Wed 1 Oct - Marcus Dieterle: High impact - Custom dialogs and mini-notifications
1:13:16 George Hepworth outlined the topic for the Access Pacific User Group meeting on Thur 7 Aug
1:14:36 George outlined new bug in 32-bit Access v2507 (Database Documenter & Table Analyzer tools). Not in 64-bit. Bug reported to the Access team on Thur 7 Aug.
1:17:01 Duane - it is possible to do some customization of class charts at runtime.
1:18:17 Final comments - see you all next month
1:18:33 End