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 [...]
One of the major issues we have encountered with Access is the use of DLookup and DCount when using SQL Server tables. We recently worked on migrating a pure Access solution to SQL server and encountered delays on the loading of several forms. This was due to the use of DLookup and DCount in the V [...]
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 [...]
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 [...]
One of our clients wanted to use Azure multi-factor authentication with Microsoft Access and Azure SQL, requiring users to authenticate when they launch Access through a second validation at least once every 60 days. Step 1: Extend your domain to Azure AD Before you can enable MFA in Azure you need [...]
We recently had a client who wanted to view his QuickBooks data in Power BI, but the former could not connect with the latter to get the data, so we resorted to exporting the data from Quickbooks, using Access to clean it up and finally upload it to PowerBI.com so that other employees can see the an [...]
Catch my latest podcast on why Access is not dead! https://accessusergroups.org/microsoft-access-podcast/ [...]
Access developer day is quickly approaching and you still have time to register and get a discount. It promises to be a great experience with the Access team and some of the brightest Access developers in the world. To register and learn more details please click here: https://www.sys.nl/netherlands [...]
Next week August 12, 13 and 14th I will be doing a different SQL Server PASS group each night in Iowa, it’s the perfect opportunity for you to catch my “Optimizing Access with SQL Server” presentation if you live nearby live and in person: Access can be much faster with SQL Server, allowing many mor [...]
We've noticed more firms migrating over to Office365 and it's liberal policies of 5 licenses per user, but there are still instances were providing an office license is too expensive for a mission critical application, prompting many to use the Access runtime. It's not as easy as installing runtime [...]
NOTE: I will be talking about this topic in depth in the upcoming Access and SQL Server monthly webinar on July 9th at 6:30 PM CDT. Register so that you can view the process live and ask questions! As we work with several applications and sometime in a team, source code control is pretty impo [...]
