How-to Send E-mails Via Outlook Using The Microsoft Graph API

Well, unless you’ve been living under a rock, by now, you are aware of some fundamental changes coming to Outlook in the not too distant future, mainly the fact that it will cease to support any form of VBA!

MAJOR Changes Coming To Microsoft Outlook
If you haven’t already heard, there are some MAJOR changes coming to Microsoft Outlook.  We will be getting a new ‘Outlook for Windows’ (2+ years out according to the video, but already available for opt-in testing) which will be replacing the existing mail apps (Mail, Outlook, Web Outlook, …). Some are also referring to it as ‘New Outlook’. Karl Donaubauer made a post which explains what we know so far:  

Now, many have tried to make Microsoft reverse course, understand the millions of solutions (Access, Word, Excel, …) that will instantaneously break with such a switch, but there has been no change in course.  Actually, per the usual, there has been little to no response whatsoever.

This brings us to today’s post!
 
Continue reading →

Microsoft Access Bug Listing And Support

In my ongoing push to try and get the Microsoft Access Dev Team use and maintain their own web resources, today I wanted to touch upon their Fixes or workarounds for recent issues in Access. This page with not even an introductory paragraph as to the purpose it has, is supposed to be the place people turn to when seeking a listing of known bugs and thus get information regarding the problem including how to workaround the issue, or fix it.
 

Problems Abound

Like pretty much every Access site from Microsoft:

  • Feedback Portal
  • Fixes and workaround
  • Access Blog
  • …

this site (Fixes and workaround) has many, many problems.
Continue reading →

String Parsing Function Crashing Microsoft Access Bug

Software Bug

Just a service announcement, that as reported by Mike Wolfe, Microsoft has introduced a new bug caused by using common string parsing function (Instr, InStrRev, Replace, …) in a query’s where clause…

Consult his post on the matter for all the details and a link back to the original post on the subject.

Bug Alert: InStr() in WHERE Crashes Access
Using string expressions like InStr(), InStrRev(), and Replace() in the WHERE clause of a query can crash Access in certain recent releases.

Modern Web Browser Control Does Not Support URL Parameters When Working With Local Files

Software Bug

One more bug to add to the very long list of Modern Web Browser control bugs!!!

I was working on what I was hoping would be a nifty demo database to utilize for fun media capabilities that HTML5 offers and got it all working fine in Edge, on its own. Sadly, when I then tried to bring it over into Access I hit a wall.

After testing I discovered that Access will accept a Control Source like:

="https://msaccess/C:\Users\Daniel\Desktop\blank.html"
="https://msaccess/C:\Users\Daniel\Desktop\" & [FilePath] & ""

where [FilePath] returns ‘blank.html’ (and yes the ending & “” is required to get around another bug!)

So, simply accessing a file is possible. We knew that.

—

Where things then start to fall apart is when we try to pass parameters as part of the URL of any local files. Thus, passing parameters like demonstrated in the following 2 examples fail.

Continue reading →

Cost of Running Windows 10 Past October 2025 Announced

If you weren’t already aware, Microsoft Windows 10 EOF (End of life) is October 14th, 2025.  That means at that point in time, Microsoft will cease to release security updates…. well for free at least! They will become only available to those that pay for Extended Support.

Microsoft has recently announced the pricing of getting extended support and it will add up quickly.  You can read all the details in the following article:

Continue reading →

Sharing a Microsoft Access Database Online With Multiple Users

Today, I thought I’d briefly touch upon a more and more common question, which is:

How can we share a Microsoft Access database online between multiple users?

In today’s world, sharing data is simply a necessity!  So it is only natural to have the need to share Microsoft Access data with people outside of your network, over the Internet…

I previously posted about this issue in my article:

Access Back-End Location - WAN, Online Server, OneDrive, DropBox, ...
There have been a few recent threads, some of which I’ve been involved in: Access Database on OneDrive for Business corruption Unrecognized database format Splitting MS Access on a LAN work well, but on a wan run very slow. Wan communications has tested positive very good. Why would MS access 2007 run slow over a wan. Slow MS Access DB over WAN in which people are inquiring about running a standard MS Access database over a WAN, an Online Server, Shared drives (OneDrive, DropBox, …) and the likes.   The Reality of MS Access Databases Microsoft Access databases are only meant…

Continue reading →

Today, I wanted to continue the discussion a little more.

So How Can We Do It Exactly?

Continue reading →

Using VBA to Shutdown, Reboot, Hibernate, Logoff of a PC

Ever needed to make a PC Shutdown, Reboot, Hibernate, … after running some code?

As with most things, there are a number of possible approaches, but today I thought I’d demonstrate a very simple solution using the Shutdown command:

shutdown
Reference article for the shutdown command, which enables you to shut down or restart local or remote computers, one at a time.

Continue reading →