Events

This was given by Judith Mills, there are no slides or video.

This was given by Steve Gilling, there are no slides or video.

This was given by Anders Ebro, there are no slides or video.

This was given by Alan Cossey, there are no slides or video.

This was given by Bob Cresswell, there are no slides or video.

Colin Riddington - 2022/02/08 Abstract: If you are designing applications for use on a variety of monitors/resolutions then this might be just the solution you need.  Colin’s code will automatically resize all forms in your applications for any screen size & resolution whilst allowing you, as the developer, full control over the form layout and appearance. Colin also has a newer article here on using AFR. Slides and video here.

Donna Landy: 2022/04/07 Or: Why couldn’t the client just have told us what they wanted in the first place?!? Slides and Video here.

When moving away from proprietary backup software (waves to Backup Exec) and installing systems with SQL Server Express, there is a notable lack of managed backup tools that enable sites to manage RPO and RTO. A bit rough around the edges (Ed: that’s enough about Peter!) this solution gives you a lot of that control back; and makes it visible from the application to the users. Backups can be scheduled and/or on-demand. As ever, sample code will be available to attendees afterwards, and you can cut your own solutions to suit your cloth. Peter uses it in house to do high frequency backups to the cloud in order to sleep at night after rebuilding the long-lost Microsoft Money to manage the family finances. No bank accounts were harmed in the building of this solution Slides and video here.

When moving away from proprietary backup software (waves to Backup Exec) and installing systems with SQL Server Express, there is a notable lack of managed backup tools that enable sites to manage RPO and RTO. A bit rough around the edges (Ed: that’s enough about Peter!) this solution gives you a lot of that control back; and makes it visible from the application to the users. Backups can be scheduled and/or on-demand. As ever, sample code will be available to attendees afterwards, and you can cut your own solutions to suit your cloth. Peter uses it in house to do high frequency backups to the cloud in order to sleep at night after rebuilding the long-lost Microsoft Money to manage the family finances. No bank accounts were harmed in the building of this solution Slides and video here.

Multiple Speakers: 2023/06/22 Colin Riddington (Mendip Data Systems) spoke on Context Menu Creator – currently unavailable to new users, but was at https://devhut.net/windows-explorer-ms-access-database-right-click-context-menu/ Access Version Checker – add in version: https://isladogs.co.uk/avc-addin/ standalone app: https://isladogs.co.uk/access-office365-win-check/ Database Analyser Pro – https://www.skrol29.com/vtools.php   Andrew Richards (The IT Service) spoke on MZTools – https://www.mztools.com/ DBForge SQL Tools – https://www.devart.com/dbforge/sql/sql-tools/   Peter Cole (Theme My Database) spoke on vbWatchdog – https://www.everythingaccess.com/vbwatchdog.asp You can download The Very Quick vbWatchdog installation ACCDB here: Very Quick vbWatchdog 32 to 64 bit API Scanner – https://www.thememydatabase.co.uk/access32to64.html (it costs you nothing). Peter asks that should you find any unknown Declares in your code to report them to him (using the buttons that appear on the form if Unknowns are found).   PJ Bryant (Corylus Business Systems) spoke on Everything – https://www.voidtools.com/ Slides and Video here.

Most Access developers avoid web development because of the need to learn JavaScript/J Query.   Using the MS ASP framework also required C# as there are few coding examples in VB.Net and anyway VB.Net is not much like VBA. In 2020 MS announced a new framework called Blazor, that removed the need for JavaScript.   Does this simplify web development enough to make it feasible for Access developers?   Is Blazor a complete solution or do you still need other components? John will talk about what he had to learn in order to deliver a customer facing web-based interface to an application already running in Access / SQL. Slides and video are here. In July 2023 John adds: Blazor continues to evolve during 2023 and .Net 8 promises some new features that have got developers excited.  The Microsoft page ASP.NET Core updates in .NET 8 Preview 6 has the full list but is a bit ‘dry’. There is a more enthusiastic version at The Future of ASP.NET Core: .NET 8 Feature Preview.