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.
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.
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
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.
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 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.
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
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!
Good job! This workaround is much better than using the timer. 👏
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.
I'm following this. First time I seen any of the content creators cover this. Really appreciate the info!
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.
Thank you for this genius workaround.
Glad to help.
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
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.
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.
Can you explain or provide a demo as I can't replicate the issue.
@@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.
Sorry, I miss understood the issue. I'll give it a try.
Confirmed.
Thank you for sharing.
@@DanielPineault Sorry for my bad explanation, glad you understood. I posted an image but i guess youtube deleted the link.
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
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!