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 [...]
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 [...]
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’ [...]
I've been playing with ChatGPT for a while now and mark me impressed with its capabilities. One of the first things I did was ask it to create a VBA function that calculates the first of the month: A couple of points on the code above: I never named the function yet the AI used a great name: FirstOf [...]
It seams Microsoft is releasing new drivers every few months now, trying to keep pace with the trove of new SQL Server and Azure features that come out with every new version. The drivers do double work, both with the product you can install locally, and the Azure service in the cloud. Why you shoul [...]
I am currently traveling through the Middle East on a entrepreneurship training course through Israel where I’m meeting startups and getting a ton of ideas for my practice. Consequently we will not be having our normal meeting in November and our next meeting is in December 13th 2022. Here are the m [...]
Last Tuesday, October 11, 2021 I was all set to present SQL Server with Access Academy Part II when I hit a roadblock I could not overcome: SQL Server Migration Assistant for Access, (SSMA), would not load the sample Northwind database and I was stuck, could not continue the session. I've done it fo [...]
We've gotten reports of an Office update adversely impacting existing applications that uses Access database to store data and is shared on a network location. Because of the update, people no longer can connect to same Access database file. With the update, only one can use the shared Access databa [...]
