I’ve been ‘lucky‘ enough to encounter, yet another, Modern Web Browser Control (MWBC) bug! 😩🫤
I used the MWBC’s Click event to be able to identify what the user clicked upon in the web page so I can react to the select via VBA.
If I use a MWBC control source linked to a local file:
="https://msaccess/C:\Demos\Interfaces\Menu01.html"
this all works fine. The Click Event work perfectly.
Continue reading
A little over a year ago I wrote an article regarding retrieving a database object’s created and modified date/times:
In it, I detailed that the Last Modified properties was in fact unreliable and hence there was a bug.
So, at the end of the article, I included a link to a Feedback Portal suggestion I created about the issue in the hopes Microsoft would decided to fix this issue for us all.
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.
Like pretty much every Access site from Microsoft:
this site (Fixes and workaround) has many, many problems.
Continue reading
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.
Ever get that sense of déjà vu! All I seem to do recently is report bugs, bugs and more bugs!
Well today is no different. In this episode of what did Microsoft screw up this time, I bring to you the spectacular case of the vanishing Navigation Pane objects!
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.
Came across a really weird bug today while trying to identify another bug with the Microsoft Access Modern Web Browser control.
I set a Modern Web Browser control’s Control Source to something like:
="https://" & [URL2]
then tested and came back into Design View to see some messed up Control Source shown on the control itself, yet a blank property value. I even tried the Zoom box, and it too is blank???!
Yep, another bug with the Modern Web Browser control.
Worse, this issue occurs when simply trying to navigate to a URL via VBA using the form’s current event. At the opening of a form, navigation is simply completely unreliable and more often than not renders a blank page! Sometimes it works, but most of the time it does not! When navigating the records, the event works just fine, this bug is limited to the initial opening/loading of the form/report control. So in most instances, the user ends up with a blank Modern Web Browser control when they should be seeing content.
Just a quick FYI regarding the Modern Web Browser control. I’ve been doing some recent work and have been experiencing issues.
As previously reported, I’ve been getting blank displays even though the URL indicates it went to the site, nothing new here!
Now, after closing my database, I kept having a lock file that wouldn’t go away and I couldn’t delete it. Examining the Task Manager I came to see that Access remained running as a hidden process, and I also then saw a whole bunch of Microsoft Edge WebView2 processes running as well. It was only after killing all of these that I was able to finally delete the lock file and continue working.
Well, here’s one more to add to the list of bugs within Microsoft Access.
The issue is that, as shown in the following screen recording, if you make multiple object selections in the Microsoft Access Navigation Pane and then de-select items, it does not properly reflect the de-selections.
I click and click and click, over and over, to select and/or de-select object yet it always remains highlighted.
So even when you de-select items, they remain visually highlighted as if they are still selected even though that is no longer the case. Because of this issue, you simply have no way of knowing what is actively selected, or not!
Continue reading