We've been receiving reports of Access not closing correctly on various versions. As far as we know, this impacts those on current and monthly enterprise. Those on the build 2408 will find that the Access no longer closes correctly and instead leaves behind a ghost process that needs to be killed in [...]
April 1, 2024 In a surprising turn of events, Microsoft has announced that two of its most iconic software applications, Microsoft Access and Microsoft Excel, will be merging later this year. The new product resulting from this union is aptly named “AccXel”—a blend of the two names that promises to [...]
Overview The datasheet view in Microsoft Access offers a range of features and capabilities that empower users to manage and analyze their data efficiently. Its familiarity, flexibility, and integration with other Office applications make it a valuable tool for various data-related tasks. Eas [...]
Don’t let the short length of this article fool you. When I discovered how to add my custom code routines to Access’s intellisense feature, I discovered a coding technique that I have used every day since! Think about it. Have you ever wondered how you could get your custom VBA code routines to show [...]
Join me this Tuesday January 9th, 2023 at 6:30 PM as we start exploring tools that will help you be more productive. Here are the details: Join us this Tuesday, January 9th for the Access SQL Server Meeting! Session Title: Tools to help you automate Access coding – with FMS founder Luke Chung This m [...]
Join me this Tuesday December 12th, 2023 at 6:30 PM as we start exploring tools that will help you be more productive. Here are the details: https://accessusergroups.org/sql-server-with-access/event/automating-access-programming-leveraging-mz-tools/ [...]
For over two decades, far before the COVID crisis, IT Impact has thrived as a remote company, embracing the dynamic world of technology and innovation. Virtual meetings became the norm, connecting team members from various corners of the globe. But deep down, one goal has always burned brightly in o [...]
Yeah, I know what you’re thinking... "Why do autonumber fields need to be managed? Don’t they manage themselves?" Well, yes, autonumber fields are pretty much self-managing, but there are times when you, as a database manager, may need to repair a table with an autonumber field and you’re sca [...]
The future of Microsoft Access in 2023? Earlier this year I was in Redmond, Washington, to participate in the MVP Summit, where I heard a lot about AI and Office and met with the Access team (it’s one of the best benefits to being an Access MVP). Although I can’t share much of what we discussed, I’ [...]
Over the years (almost two decades), there was (it has been fixed now in the latest versions) a glitch in the Access Datasheet Wizard that created a confounding condition that led many to take to the help forums to find a solution. You see, one of my favorite features of the datasheet is using the c [...]
It is common to run across questions about how Access handle deletions, particularly from the VBA code. The Access form provides 3 events around the deletions but they are easily misunderstood. I attribute this to how the events are presented in the Property Sheet's Events tab: If all we did was jus [...]
