Week in Review Week in Review: January 18, 2025 Highlights include a new MouseWheel event bug in Access v2412, an exploration of connection strings in Access, and a deep dive into complex datatypes.
Week in Review Week in Review: January 11, 2025 Highlights include creating COM add-ins with VB.Net, deploying Access updates, sorting MVFs, a current Access User Group list, and a new recurring section on End-of-Life dates.
Week in Review Week in Review: January 4, 2025 Highlights include a deep dive into `&` vs. `+` for joining strings, a how-to video on using inline queries (i.e., subqueries), and working with the KeyDown and KeyPress events.
Week in Review Week in Review: December 28, 2024 Highlights include customizing ribbons using command bars, details and migration guidance for New Outlook, and an analysis of when to index boolean fields.
Week in Review Week in Review: December 21, 2024 Highlights include image processing with ImageMagick, navigating forms in VBA with SetFocus and GoToControl, and using UI Automation to identify the current ribbon tab.
Week in Review Week in Review: December 14, 2024 Highlights include how to create Access and COM add-ins, Outlook COM automation alternatives (Mailgun, Graph API), and using AI in VBA development.
Week in Review Week in Review: December 7, 2024 Highlights include critical info for the migration to New Outlook, a detailed Access image gallery tutorial, and perspectives on pair programming benefits.
Week in Review Week in Review: November 30, 2024 Highlights include key insights on Access-to-SQL Server migration, the pros and cons of the new Monaco SQL Editor, and practical VBA tutorials for dates and combo boxes.
Week in Review Week in Review: November 23, 2024 Highlights include a new episode of Access News from Karl Donaubauer, a video walkthrough of the new Monaco SQL Editor, and a form resizing solution.
Week in Review Week in Review: November 16, 2024 Highlights include measuring the height of CanGrow controls, exporting an Access chart to PNG/GIF/JPG, building a photo cataloguer, and tabbing to the form footer.
Week in Review Week in Review: November 9, 2024 Highlights include updated development priorities from the Access team, adding a row number to queries, and a treasure trove of VBA content at Awesome VBA.
Week in Review Week in Review: November 2, 2024 Highlights include the Monaco SQL Editor release, TDD implementation techniques, intro to Cross Joins in SQL, and the inaugural meeting of the Access Beginners User Group.
Week in Review Week in Review: October 26, 2024 Highlights include a video intro to the new Modern Charts feature, combination query techniques, and handling bit fields in SQL Server.
Week in Review Week in Review: October 18, 2024 Highlights include a deep dive into parentheses in VBA, ChatGPT's new canvas feature, and the official bug fix list for Access versions 2408 and 2409.
Week in Review Week in Review: October 12, 2024 Highlights include disabling shortcut menus on reports, drag and drop with Alessandro Grimaldi, and single sign-on cached ODBC connections.
Week in Review Week in Review: October 5, 2024 Highlights include the official release of the new modern chart feature, the release of Access 2024, and dynamically loading a DLL without registering it first.
Week in Review Week in Review: September 28, 2024 Highlights include adding a multi-file drag-and-drop control to your Access forms, improved control tips, and accessing the call stack at runtime with vbWatchdog.
Week in Review Week in Review: September 21, 2024 Highlights include the relaunch of the UK Access User Group, working with the MS Graph API from VBA, and advanced interactive Gantt chart techniques.
Week in Review Week in Review: September 14, 2024 Highlights include runtime ribbon updates, locking records in continuous forms, FTP operations via curl, and the inaugural meeting of the Australia Access User Group.
Week in Review Week in Review: September 7, 2024 Highlights include a new bug causing msaccess.exe to hang on exit, how to export to PDF/A from Access, and the launch of an Access "developer research panel."
Week in Review Week in Review: August 31, 2024 Highlights include primers on two new Access features (the Monaco SQL Editor and Modern Chart Improvements), using curl to FTP from VBA, and when to use Access vs. Excel.
Week in Review Week in Review: August 24, 2024 Highlights include using curl to download from the web, using PowerShell to send emails, exporting an Access query to a Word table, and kicking all users out of SQL Server.
Week in Review Week in Review: August 17, 2024 Highlights include an intro to treeview controls, working with the Windows Registry, Access best practices, and understanding VBA libraries.
Week in Review Week in Review: August 10, 2024 Highlights include a free tool for building database diagrams, an intro to SaveAs/LoadFromText, and a showdown between hourly billing and value-based pricing.
Week in Review Week in Review: August 3, 2024 Highlights include a tablet-friendly UI technique, fetching current weather via a free web API, and a text file logger for my VBA logging framework.