DevCon

The Access team will present its current work and plans. This includes support for large monitors and resolutions, as well as new support for version control with GitHub.

Of course, there will be a Q&A part again. So prepare your questions for Microsoft!

What has happened for Access and in the community since the last DevCon? Additions to the Access team's update with information and comments from a developer's perspective:

•  All new features, bugs and fixes
•  What is going on with Microsoft products surrounding Access (like beloved New Outlook)
•  Access usage statistics from my developer surveys
•  Activities and initiatives in the global Access ecosystem

Karl is an Access developer and MVP who has been preaching and muddling around in the community for a few years now.

You can check out his News videos and a group blog site where you can find all the latest sensations around Access.

You should also follow him on LinkedIn, where he finally wants to become a rich influencer.

Learn how to use the Web API in VBA template code from GitHub VBA-Web to connect with the Microsoft Graph API to send mail, create calendar events and work with contacts. This could be a viable option for when the New Outlook takes over and we can no longer connect with the Outlook COM Object Model from VBA. The security and setup is a bit complicated, learn the basics of it from an Access Developers mindset.

Graph is the gateway to data and intelligence in Microsoft 365. It provides a unified programmability model that you can use to access the tremendous amount of data in Microsoft 365, Windows, and Enterprise Mobility + Security.

• Authenticating with the Microsoft Graph API with VBA
• Navigating the many API functions available
• Implementing functions to send mail in either draft and direct
• Implementing a function to add a calendar event
• Implementing functions to list and create a contact

Another way to survive the New Outlook disaster

Learn how to use Power Automate to send mail, create calendar events, and work with contacts. Besides that, flows can do a few hundred more things. The setup is easy as Power Automate is incorporated in your Office 365 suite, and the security is guarded by Entra ID. For some action you will need an extra license though.

You will learn about the basics, but from an Access Developer's perspective. Then we explore how to automate flows from VBA.

• Creating and editing Flows, eventually supported by Copilot
• Navigating the many Triggers and Actions available
• Calling a Flow's https endpoint from VBA, post JSON data, await the response
• Implementing Flows to send mails from Access, work with calendar and contacts

Ynte Jan has been working as developer and trainer since the 80s. He is extremely solution-oriented and chooses his tools accordingly, be it Visual Studio, Access, SQL Server or not from MS.

In recent years, he has focused on the Microsoft Power Platform. He is a certified Power BI Data Analyst.

Ynte Jan has given many trainings and presentations on programming, database and BI topics at numerous conferences.

Ivercy vs. msaccess-vcs-addin – The fight of the decade


Version control is a very important topic in many areas of software development. In the Access community, however, it has only played a minor role for decades. Adam and Philipp are now going to change that!

They are staging a showdown in which they will demonstrate important aspects of version control and how their respective tools handle them. The tools have very different approaches in many areas. This confrontation will therefore be both educational for version control novices and exciting for experts.


Spoiler:
Of course, the fight is a little staged. ;-) The opponents are currently discussing how many rounds it will last and what they shall look like. The goal is a fair draw. But will that be possible at all?


Details tbd

In 2023, Colin released his Database Analyzer Pro app. It provides a detailed analysis of the structure and properties of Access databases and their objects. The app has recently been significantly updated with many new and improved features.

In the first half of this session, Colin will demonstrate a selection of new features including:
• database summary and issues
• import saved analyses
• object properties and charts
• form/report control properties, events and embedded macros
• ribbons, shared resources, API declarations, add-ins and CommandBars
• IMEX specifications and data tasks

This will be followed by demonstrations of two free apps:

• SQL to VBA and back again (add-in)
Easily convert SQL to/from VBA and detect errors. Choose from a range of customisable options.

• Simple ribbon creator to run external apps from Access
From now on, all your favourite applications are just 1 click away. No XML code required!

VBE_Extras is an AddIn for the Visual Basic Editor (VBE). It makes writing VBA code quicker, simpler and less bug-prone by adding new functionality to the VBE. The sort of functionality you would expect in a modern code editor. Demonstration will include:

• History - Back / Forward / Show
• Go to last edit
• Indent
• Add/remove line numbers
• List declarations in this Procedure / Module / Project
• Go to declaration for code at cursor
• References for code at cursor
• Highlighting
• Rename code at cursor
• Sub to run / Run Again
• Add Property
• Add Factory
• Full Screen
• Show / hide hidden members
• Show All Members
• Update Project References
• Special binding
• Extract to constant
• Call hierarchy