Microsoft Access - Modern Web Browser Control - Not Rendering - Blank - Bug

  Рет қаралды 354

D Pineault - Tech, Programming and more

D Pineault - Tech, Programming and more

Күн бұрын

This is another take on a reproducible bug with the Microsoft Access Modern Web Browser Control (MWBC) in which it does not render/display content when you dynamically assign the MWBC's Control Source at runtime.
This is an improvement upon my prior workaround to the issue: • Microsoft Access - Mod...
Table of Contents:
00:00 - Introduction
00:42 - The Basics
02:05 - The Bug
05:02 - The Fix
10:13 - Property Sheet VS. VBA Code
12:34 - Form Updating Bug
13:13 - Blog Article
13:55 - Where's The Dev Team In All Of This?
My Links:
🏭 www.cardaconsultants.com/ (business)
📢 www.devhut.net/ (blog)

Пікірлер: 18
@xavierbatlle1828
@xavierbatlle1828 Ай бұрын
Good job! This workaround is much better than using the timer. 👏
@DanielPineault
@DanielPineault Ай бұрын
Agreed. Better yet, not having all these bugs in the first place!!!! 😞 not having to waste so much time coming up with all sorts of workarounds. Imagine a control that actually worked properly from day 1. Oh, the dream.
@schwanabdulkareem7782
@schwanabdulkareem7782 Ай бұрын
Thank you for this genius workaround.
@DanielPineault
@DanielPineault Ай бұрын
Glad to help.
@HomeEngineer-wm5fg
@HomeEngineer-wm5fg Ай бұрын
I'm following this. First time I seen any of the content creators cover this. Really appreciate the info!
@DanielPineault
@DanielPineault Ай бұрын
My pleasure. The reality is that I think many people had a solution using the legacy browser and haven't necessarily migrated to the new browser. Also many just load a static page or url and simply haven't faced many of the issues I've experienced. It's because I eagerly wanted to explore the control, try things that didn't work in the legacy browser, so I've had the great pleasure of testing the limits of the control! As more developers truly start to use the control for advanced scenarios you will slowly see more comments relating to this and many other bugs. You also have to add to that the fact that I suspect some people initially tried the modern browser and walked away after needing to deal with MS Access, Trusted Domains, ... and all sorts of other bugs.
@michaelkrailo5725
@michaelkrailo5725 6 күн бұрын
I just got around to playing with your examples on this Daniel, and I am not using your work around and it seems to be working every time without issue as long as I don't use my favorite Ctrl-Period to come out of design view. If I use F5 or used the Right-Click menu option to go to form view, it works every time. I'm wondering if they fixed the problem partially or my computer is just so fast that it doesn't have the timing problem. The only difference is I'm using a very simple function to set the ControlSource instead of your suggested code. I wanted the html files to load no matter which computer the front end was on. The only bug I encountered was due to the dashes in your form names (Invalid Character). Once I removed the dashes from the file form names, it all worked properly. Eventually, going back and forth from design view and form view does crash access, so there is that. I find access just crashes for no apparent reason while I'm developing way more than it used to. I always do debug compile and save before going to form view. Update: I put a DoEvents in the Open event code, and now everything works. Just realize that this won't work if the form names have dashes in them. Remove the dashes, and it works like a charm. Update2: Sadly, I was able to see the bug but it was very intermittent. I just kept doing Ctrl-W Enter over and over. It did show up occasionally even with your fix in. There is still some sort of timing issue going on. Update3: OK, I got it working now. I wasn't paying attention to the order you had the code. As long as the Do Loop is before the dynamic control source assignment, it all works as you demonstrated. I was so frustrated trying to get it working after that bug started to rear it's ugly head. Now I think I can rely on this and move forward with development. Thank you so much for figuring this out. ' This version works even with the Ctrl-Period method of going to form view and the form opens most of the time Private Sub Form_Open(Cancel As Integer) Private Sub Form_Open(Cancel As Integer) Do While Me.EdgeBrowser0.ReadyState acComplete DoEvents Loop Me.EdgeBrowser0.ControlSource = GetHtmlFileName("Menu-V-01.html") End Sub ' Put this in it's own module Function GetHtmlFileName(sFileName As String) As String GetHtmlFileName = "msaccess/" & Application.CurrentProject.Path & "\" & sFileName End Function
@DanielPineault
@DanielPineault 2 күн бұрын
Fun eh! I spent hours on all of this to figure out the whole problem and come up with the workaround. It once again shows how little testing was done by Microsoft.
@juanfranrodriguez
@juanfranrodriguez 22 күн бұрын
I have another crazy one! Use a file with the extension in capital letters as control source for the edge browser control. You will get lot of symbols as if you have opened it with notepad. I've tested it with images and pdf files so i think the bug happens with binary files. You can use Lcase function for a simple workaround.
@DanielPineault
@DanielPineault 22 күн бұрын
Can you explain or provide a demo as I can't replicate the issue.
@juanfranrodriguez
@juanfranrodriguez 22 күн бұрын
@@DanielPineault Get any jpg image and change its extension to JPG in capitals. Now use it as control source of an edge browser control. The browser control will not load the image but will show the binary data, something like (EÀ `€¸Á0 €,Áp0,Á `˜ÀÀ°@\ @\%\PÀ@\ !Al„ÀÀ \ „ÀÁl„„À(ÀÀ) €R) Tested in version 2406 build 16.0.17726.20078 64 bits.
@DanielPineault
@DanielPineault 22 күн бұрын
Sorry, I miss understood the issue. I'll give it a try.
@DanielPineault
@DanielPineault 22 күн бұрын
Confirmed. Thank you for sharing.
@juanfranrodriguez
@juanfranrodriguez 21 күн бұрын
@@DanielPineault Sorry for my bad explanation, glad you understood. I posted an image but i guess youtube deleted the link.
@juanfranrodriguez
@juanfranrodriguez 29 күн бұрын
I found another bug with the edge browser control. If you put an edge browser in not the first tab of a tab control, the browser flashes the page once when loading the form. 🤦‍♂😒😭 They are making it a bit hard to replace internet explorer
@DanielPineault
@DanielPineault 29 күн бұрын
Il have to test that one out. Yes, although there are some great advantages with the Edge browser control, there are major issues making it truly crappy to use. To me, once again, this wasn't properly thought out, tested, not enough feedback was collected (if any) before actually launching. When I compare it to the actual WebView2 control and what is possible there... what a letdown. Then sprinkle with Trusted Domains, msaccess/, ... oh my how things went downhill fast!
Microsoft Access - Google REST API - Send Email via Gmail
41:30
D Pineault - Tech, Programming and more
Рет қаралды 870
Microsoft Access - AutoResize Combo box and List box Columns
23:35
D Pineault - Tech, Programming and more
Рет қаралды 437
Викторина от МАМЫ 🆘 | WICSUR #shorts
00:58
Бискас
Рет қаралды 4,3 МЛН
MISS CIRCLE STUDENTS BULLY ME!
00:12
Andreas Eskander
Рет қаралды 19 МЛН
Microsoft Access - Modernizing The Interface
30:55
D Pineault - Tech, Programming and more
Рет қаралды 2,4 М.
AI in Your Web Browser is a GAME CHANGER | Microsoft Edge
10:58
Kevin Stratvert
Рет қаралды 344 М.
VBA - Including Line Numbers In Your Error Handler
10:28
D Pineault - Tech, Programming and more
Рет қаралды 546
SelectAI Part-1
8:31
Brendan Tierney
Рет қаралды 55
Petition To NOT Remove VBScript
13:59
D Pineault - Tech, Programming and more
Рет қаралды 371
WhatsApp Messenger Runs Arbitrary Python Code
13:46
John Hammond
Рет қаралды 75 М.
Microsoft Access - Microsoft Graph REST API - Send Email via Outlook.com
30:51
D Pineault - Tech, Programming and more
Рет қаралды 857
The simplest way to automate your browser for FREE
20:53
Mike Powers
Рет қаралды 88 М.
Microsoft Access - Modernizing The Interface - Part 2
19:59
D Pineault - Tech, Programming and more
Рет қаралды 855
WebRTC Crash Course
1:10:06
Hussein Nasser
Рет қаралды 224 М.
Что делать если в телефон попала вода?
0:17
Лена Тропоцел
Рет қаралды 3,2 МЛН
Проверил, как вам?
0:58
Коннор
Рет қаралды 240 М.