|Virtual Access DevCon 2022
|Microsoft Access Roadmap Update
|Michael Aldridge+Joe Jimenez, Microsoft, Redmond, USA
+ New Feature Deep Dive: New Microsoft Edge-based Webview2" Forms Control
This session includes a quick roadmap update, and a live demo and discussion on the specs for the new Chromium Edge Webview2 Browser Control for Forms under development. This will replace the IE11 forms control. The Microsoft team want your feedback on what you think are critical requirements as we focus on this in 2022.
Joe Jimenez, Access Engineer
|State of the Dataverse Connector
Barnes Business Solutions,
Minneapolis, MN, USA
The Access team at Microsoft spent the majority of their development efforts since 2020 on the Dataverse Connector. Still in Beta with General Availability
planned for Spring 2022. What is the current status? How does the Dataverse connector work? What do all these efforts mean for us as Access developers?
Maria is a 4-time Microsoft Office Apps & Services MVP specializing in Microsoft Access. She has a Bachelor of Science in Mathematics & Computer Science and a minor in Business from the University of Illinois.
|Mike Wolfe, Grandjean & Braverman, Prompton, PA, USA
COM is the gateway to a world of possibility in Microsoft Access.
Mike is a Microsoft Access MVP who has been developing in Access and SQL Server since 2007. He earned a bachelor's degree in Computer Science from the US Military Academy (West Point) in 2002.
twinBASIC is a modern version of the classic BASIC programming language that is 100% backward compatible with VBA.
twinBASIC made its global debut at last year's Access DevCon Vienna. The overwhelming feedback from that session was along the lines of, "This sounds very interesting, but how does it apply to *me* as an Access developer?" This year's presentation will answer that question. Working outline:
Brief introduction and overview of twinBASIC
Updates on the project's progress over the past year
How to develop in twinBASIC using VS Code and the new twinBASIC IDE
Potential use cases for Access developers *today*
Practical demonstration - creating and using a twinBASIC add-in
|New Access Front-end Deployment Service
|Kevin Bell, AccessUI, Redmond, WA, USA
Anyone who develops Access applications knows you need to split your database. The data can live on a file share, or better yet in SQL Server, and your Access front-end is ideally copied to each users computer. Running the front-end locally will improve performance and virtually eliminate corruption issues, but how do you effectively push out a new version out to all your users? File share? Email? Script file?
Kevin started working professionally with Access in version 1.0 and has been working with SQL Server since version 4.21. For 15 years he ran a small consulting firm in Colorado that specialized in creating custom data driven applications on Access and SQL Server.
|Access Studio Managing your queries
|Chris Arnold, SMEDataSolutions, UK
Access Studio has been developed to overcome many of the shortcomings of the Access QBE and introduce new features similar to those found in SQL Server Management Studio. It can be run as a library file to any existing project or the professional version can be run as a standalone application to manage multiple applications plus additional features.
Chris is a qualified management accountant who was a finance director of a number of companies.
His first introduction to programming was in the mid 70s to create a production control program on an Apple
IIe using UCSD Pascal.
|Word Automation in-depth
|Crystal Long, MsAccessGurus, USA
Create professional Word documents from scratch using Word Automation. Write data and text, format, save, and open the finished document with VBA.
We often want to make datasheets look nicer and have many of them in one report. A great way to do this is by creating a Word document with lots of pages and tables.
Crystal Long has been using and developing with Access a long time, and Word even longer since it was available in the DOS days.
She connects 1-on-1 and guides developers as they're building applications, and teaches in virtual classrooms.
|Annotating Google Maps
|Colin Riddington, Mendip Data Systems, Somerset, UK
This session will demonstrate ways of annotating downloaded static Google Maps to personalise these for your clients.
Topics to be covered will include the use of:
Access developer for over 20 years starting with Access 97. Many years teaching in secondary schools including responsibility for data analysis.
I initially created Access apps for my own use and later for all staff in a number of UK schools.
|VBA Tips and Tricks
Constantly experimenting and in search of something unusual, funny or simply useful, through the years I have collected quite a number of VBA snippets. Some are original, some are adapted from what I found on the Web. This time I will show you a bunch of these "VBA pills", as I like to call them, showing tricks and techniques you might not know yet.
A programmer since 1983, VBA since 1998, for several years Alessandro was consulting for the United Nations in different countries (Italy, Afghanistan, North Korea, Ethiopia, Austria), creating dozens of Office applications, from simple automation tools to corporate level, multiuser, Oracle based applications.
|Themes Click Style into your Applications
|Peter Cole, ThemeMyDatabase, UK
Since 2010 Themes are included in Access. They are not only about color properties like Background 1, Lighter 40%... but you can do things like changing all colors in a database with a single click! Since MSFT does not provide any slick tools for Themes,
Peter has developed the free database ThemeMaker and the commercial add-in ApplyStyle for this purpose.
Peter is an Access developer, who has worked with Access since version 2, intersperced with CAD/CAM developments and macro programming on multiple version of
He has developed an Access based manufacturing system for control desk panels incorporating a COM package for nesting, calls to graphics packages to incorporate color images and output of CNCcode.
|Practical Tools for Access
A gourmet selection of free and commercial tools mostly presented by the authors
Northwind 2.0 progress report on the total rewrite
Continuous datasheets combine the advantages of datasheet and continuous form
API 32-bit to 64-bit updater update existing API calls to work with 64-bit
Translate & Speak a translation and speech tool for >100 languages