Check out all the BREAKING NEWS Ebo Quansah released at my last Access with SQL Server meeting: https://accessusergroups.org/blog/the-biggest-news-from-ebo-quansahs-march-9th-2021-presentation/ #msaccess Access MVP Summit This Week! March 29 through the 31st is the global MVP Summit, looking forward [...]
We love running stored procedures from our VBA code, but there is one issue you need to watch out for: Executing a procedure that affects data already loaded on your form. If you're not careful you will get the following message: Fortunately, it's an easy fix, here are some suggestions: Close the fo [...]
AccessUserGroups.org launched a new tool that will convert your Access queries over to TSQL: https://accessusergroups.org/blog/accesssqltool/ As a firm that specializes in converting Access to SQL Server, this tool will be a real time saver! But it gets better with the ability to also create a strin [...]
If you ever need to download the runtime kit for Access 2016 you will find it here: https://www.microsoft.com/en-us/download/details.aspx?id=50040 If you expand the Details section you will see the following note: Note: There are multiple files available for this download. Once you click on the "Dow [...]
On Tuesday September 8th, 2020 at 6:30 PM CST we are back from summer vacation to start the new season! We will start with introduction to Access with SQL Server, you can learn more at https://accessusergroups.org/sql-server-with-access/event/375-2020-09-08/ Please join me! [...]
I often get asked, "how does one become an Access MVP?" 9 Years of MVP Awards When I first started nine years ago, we had over 30 MVPs. Now we have less than 20. Each year, I need to compile my accomplishments and submit them for review, then cross my fingers and hope to be awarded. It’s not like [...]
[UPDATE: now with Access team link to fixes] Recently the Access team starting working on a new data type called Date & Time Extended, here’s Ebo Quansah, Access program lead: Very soon, we will ship a new data type, known as Date & Time Extended, which enhances syntax compatibility with SQL [...]
Field Hospital Inventory System During these grave times we see field hospitals going up everywhere: Central Park in New York, churches, gyms, parking lots, and more. The COVID Supplies Database is our way of helping humanity in this time of need, its a simple inventory system that’s easy to use, co [...]
If you're on Office365 you have a choice in regards to how often you see new features, (some refer to these as rings): Semi-Annual: You get new features every six months, we recommend this channel to all of our clients Semi-Annual Targeted: Think of targeted as a preview of what users will see a mon [...]
Last week we had our virtual MVP conference, where I huddled with MVP’s from around the world as we heard and gave feedback to the Access team. Here are some takeaways: I miss sharing with friends I only get to see once a year, but being virtual did have some advantages, one of them being able to re [...]
Never discount looking at the What’s New section in Microsoft Office to get a first hand look at goodies coming your way! A fellow MVP pointed out to me how you can see new features by going to backstage, (File menu), clicking on Account and then What’s New. Scroll down until you see new features in [...]
