Ай бұрын
3 ай бұрын
3 ай бұрын
3 ай бұрын
3 ай бұрын
Пікірлер
@brooksrimes 5 сағат бұрын
How do I retrieve all the data I see if I go to a browser, right click, and choose View Page Source? So far I have not found VBA code that will return 100% of the information.
@DanielPineault 4 сағат бұрын
If you look at my article on the Modern Web Browser Control www.devhut.net/everything-you-never-wanted-to-know-about-the-access-modern-web-browser-control/ I cover this under the heading Retrieving a Page’s HTML Source Code
@michaelkrailo5725 5 күн бұрын
I think where the data driven menu comes into play more is for quickly implementing a new database using the same menu system. Not a huge amount of time savings, but nice for duplicating the same accordion menu on a new setup. If you edit the html in VSCode, there is an in editor color picker that makes it real easy to change the color scheme. I'm still kicking my self in the head after developing an accordion menu system using actual controls that are repositioned around and controlling all the visibility logic. This just blows what I was doing out of the water. Hopefully the edge browser control is improved to fix all those bugs you mentioned before. Thanks for all your hard work on this.
@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 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.
@ashiem1 12 күн бұрын
Great content as always Daniel, you enrich the Access community immensely. One solid mention than may need to be highlighted... After downloading the sample files, following the video and still failing (due to a number of errors) to have benefited from the functionality you highlighted, seems my Access v 2406 in MS Professional Plus 2021 still is using the prior browser control and not the new Edge Browser control. Unsure but the EB control may only be available in Office 365?
@DanielPineault 9 күн бұрын
I elaborate on the required build in my article on modern web browser control www.devhut.net/access-new-modern-web-browser-control/ The perpetual licenses versions 2016,2019, 2021, ... Don't normally get new features, so yes, this is only available on MS365 and future versions of perpetual versions.
@Jcroffe 14 күн бұрын
AWesome!
@DanielPineault 9 күн бұрын
Thanks!
@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 22 күн бұрын
Can you explain or provide a demo as I can't replicate the issue.
@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 22 күн бұрын
Sorry, I miss understood the issue. I'll give it a try.
@DanielPineault 22 күн бұрын
Confirmed. Thank you for sharing.
@juanfranrodriguez 21 күн бұрын
@@DanielPineault Sorry for my bad explanation, glad you understood. I posted an image but i guess youtube deleted the link.
@fernandovilchez736 27 күн бұрын
excelent video and concepts Thanks
@DanielPineault 27 күн бұрын
Thank you for watching and your feedback.
@TheRealWillM 28 күн бұрын
Signed the petition out of moral support
@DanielPineault 27 күн бұрын
Thank you
@FragEightyfive 28 күн бұрын
Could this be a way for MS to gauge demand, and then charge for it as another form of artificial segmentation?
@DanielPineault 28 күн бұрын
God only knows!
@lboston4660 29 күн бұрын
VBScript is still around? Hahaha. Throwback to being a script kiddie in 2005. I remember it being convenient for getting code executed on my 'friends' computers until Windows caught up with it.
@DanielPineault 29 күн бұрын
Oh, it's used for so much more than that! But yes, like me, it's still around!
@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 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!
@NormanLacap 29 күн бұрын
done
@DanielPineault 29 күн бұрын
Thank you and please share with your network.
@ozairkhalid 29 күн бұрын
I have signed it, thanks for the heads up!
@DanielPineault 29 күн бұрын
Thank you and feel free to spread the word.
@AdBass59 Ай бұрын
I signed the petition. I have Apps that use the Scripting Runtime and File System Object. My Apps are small and have a limited audience, but I can't imagine having to do major rewrites of them with who knows what.
@DanielPineault Ай бұрын
Thank you.
@gseach Ай бұрын
Hi Daniel, What stands out to me is that there are ONLY two features in development.
@DanielPineault Ай бұрын
Yes and no. The biggest issue is the Access Dev Team is small, so they can only do a few things at a time. Then there's bugs, bugs and more bugs. So they have to continually devote time to those which takes away from everything else. Then there's also the fact that they are also continuing of things like DataVerse which also takes away from new feature development. Then there's their approach. They used to post everything they were striving towards, but a few years back switched to only posting items that they were 90% confident in delivering in the next few months or so. So they could very well have other things in development, but don't post them on the roadmap because they still remain unsure of when they might actually materialize. We've long told them we'd love more visibility, but they've never listened.
@ryanrainey1646 Ай бұрын
Thank you for all this information and your efforts. I have signed the petition.
@DanielPineault Ай бұрын
Thank you!
@JANDERSO5554 Ай бұрын
Not a VBScript user, but I signed it.
@DanielPineault Ай бұрын
Thank you!
@HomeEngineer-wm5fg Ай бұрын
Not going to lie, I never use VBScript so I am not the demographic of Access user affected. Not sure if this effort is to close the door of potential security risks causing bloat on the platform. I know support for previous development is a requirement but considering as old as MS Access is, I have it in back of my mind to not cling to the "old way of doing things" if this sentiment is appropriate. I wish I could get info into whether or not TypeScript is being integrated into MS Access. I really believe MS Access's future is webdev on the edge. A real data science platform.
@DanielPineault Ай бұрын
I doubt that will be the direction Access will take, then again, I've been wrong before! They've bombed with web implementations 3 times now, I don't think they're going to do much on that front again. As for not being the demographic, you might be surprised, vbscript libraries are responsible for File System Object (FSO), scripting dictionaries, RegEx and much more. So if you've ever used any of those, and much more, this risks impacting even you! A lot of people aren't realizing that this might very well impact them because vbscript drives several libraries. Heck, FSO is one of the most used VBA libraries there is!
@tuffley2175 Ай бұрын
New vision for the future - awesome It will be useful if you could generously include html code for the security part in the download please (username part) It helps people like me who are on the other side of scale follow and absorb bit of your vision 📚👏🤓 Thanks
@DanielPineault Ай бұрын
I have 1 more video to put out on the subject to demonstrate this and I will have an updated demo file at that time.
@tuffley2175 Ай бұрын
@@DanielPineault Thank you Appreciated 🫡
@tuffley2175 9 күн бұрын
All,these days I am trying to understand html code behind web menu V1 If you could point me where to change font-colour of the menu items please Thanks in advance
@DanielPineault 9 күн бұрын
Yes, I get that feeling too. Sadly, HTML appears to be the only way to improve/extend Access since we are seeing no real interface improvements coming from Microsoft. We have to use what we can to try and modernize Access. As for your question, everything is controlled in the CSS, so in the HTML file between <style> </style> tags. In this case, you want to modify the Color: #fff; entries.
@tuffley2175 9 күн бұрын
Thanks for the response and directions I keep digging
@andrewabaye6603 Ай бұрын
I am having this issue with a Network Shared Access Database. Active Content is being blocked. How can treat this please?
@DanielPineault Ай бұрын
Have you configured a Trusted Location for the Front-End folder (or file)?
@andrewabaye6603 Ай бұрын
@@DanielPineault, I have tried to add the network drive to the trusted location but it says it is not allowed to add a network location even though I have Allow Trusted Location on my networks checked
@DanielPineault Ай бұрын
What about mapping the drive and then adding the mapped drive to the Trusted Locations? Perhaps you're IT has blocked trusted location creation. You may need to put in a request to then to deal with this.
@HomeEngineer-wm5fg Ай бұрын
I dont even care about improving the charts where I could use any JavaScript framework with the modern Edge browser control to replace the Forms 2.0 interface/limitations.
@DanielPineault Ай бұрын
It's that they're trying to fix the half-baked Modern Charts they put in place a couple years ago. It was never completed by a long shot and I guess they're trying to fix that mess now. I don't quite get it either.
@bumpersmith Ай бұрын
I have started putting my time into learning python and SQLite. It may be time to get more serious about Lenox. At least this can be a cross-platform solution in the future.
@DanielPineault Ай бұрын
All good options, but sometimes hard to get clients onboard with. I chose PHP and any back-end I want specifically because it is common and less resistance to.
@shaun120879 Ай бұрын
Had the same problem with office 365 with my work account. I don't know what they did to fix it
@DanielPineault Ай бұрын
I'm going to completely uninstall office and then reinstall it in the hopes that resolved things. If that doesn't work, I'm simply moving on. MS 365 holds no real value for me over any prior version. In reality, Access 2000 is just as good, faster, ...
@filipinadatingwithbrazilia4597 Ай бұрын
Thank you very much for your help. I was facing issues with my printer not working after updating Microsoft Office. I'm grateful I came across this video, as it provided the solution I needed. Thanks again.
@DanielPineault Ай бұрын
My pleasure and glad it helped!
@JasonHayes-ui2lm Ай бұрын
I have always considered MS 365 incomplete.... It's typical of MS in general... 2 steps forward 1 step back... How long has MS being going now! It's simply not acceptable and if you need support forget it... For app builders and development its simply too frustrating to use to the point where you have to simply walk away at some stage...
@DanielPineault Ай бұрын
Yep, pretty much sums it up
@michaelglover9187 Ай бұрын
I came to the same conclusion else here: just leave Access open and then your applications will run immediately.
@DanielPineault Ай бұрын
Yes, leaving an instance live and switching databases in that instance gives good performance. The issue is you can't always leave an open instance, so we are faced with the issue one way or another. The real answer is Microsoft needs to cleanup their code to not waste time performing checks when there's no internet connection. Not very hard for them to do, obviously their timeout is easy too long or they have other code issues.
@OfficewithAtiq Ай бұрын
I have changed the color, font and icons of the slide bar but I'm not able to load another design, could you please make another video to demonstrate how to load another design and how we can allow to users which option they can use, means admin security. I’m waiting for another video thanks a lot for your kind support.
@DanielPineault Ай бұрын
I did plan on doing one more video, so I'll try to add these into the mix.
@OfficewithAtiq Ай бұрын
@@DanielPineault I'll be very thankful if you could share the video
@OfficewithAtiq Ай бұрын
Awesome, i will try to use this in my projects thanks alot for such a awesome information.
@DanielPineault Ай бұрын
Truly glad you find it useful. Thank you for your feedback.
@suzannedorman8945 Ай бұрын
Perfect! Great explanation and worked perfectly. I noticed I had to open each of the Office apps twice before seeing the changes even though they showed the correct build number. Thank you!
@DanielPineault Ай бұрын
You're most welcome. And thank you for watching my content and providing your feedback. I truly appreciate it!
@InViewSmartIntegration Ай бұрын
"I don't control what the access dev team does" - now that's a real shame.... Maybe if you did i would consider using MS access for more projects. Excellent work as always...
@DanielPineault Ай бұрын
Oh, trust me, if I had been in charge the focus would have been on improving the database, SQL editor, a web browser control that actually works. Not 15-20 years after people asked for it! Alas, we have what we have! A product that truly hasn't moved forward much in 10-15 years. Backwards compatibility, what Access was known for, is no more... A corporate mentality of just release it and we'll fix things later, maybe... The potential has been lying there for 15-20 years just rotting away. I don't know why there's so much incompetence, I don't see the Dev Team as not knowing what needs to be addressed (many a discussions have been had over the decades), so it must be management forcing them to work on things of no real value and ignore what would have moved the product forward. Well, that's my best guess. All I know is it is sad!
@schwanabdulkareem7782 Ай бұрын
Thank you for this genius workaround.
@DanielPineault Ай бұрын
Glad to help.
@romeus2012 Ай бұрын
solo me queda decir ! Excelente ¡ Saludos desde Perú
@DanielPineault Ай бұрын
Muchas gracias desde Canadá (Quebec). Me alegra que hayas encontrado útil la información.
@Ziahasan222 Ай бұрын
Cool... Ty sir. You are awsome. Very helpful.
@DanielPineault Ай бұрын
Your most welcome. Glad you found the video useful.
@kiyabonhende8394 Ай бұрын
Thanks you very much!
@DanielPineault Ай бұрын
Your welcome. Glad you found it useful. Thank you for watching.
@HomeEngineer-wm5fg Ай бұрын
I'm following this. First time I seen any of the content creators cover this. Really appreciate the info!
@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.
@dunnobe Ай бұрын
Any chance you will upload this VBA/database as well? I can't seem to find it on your website :(
@DanielPineault Ай бұрын
The basic version is there (part 1), part 2 is coming in the near future.
@michaelkrailo5725 3 күн бұрын
It's on his site now. Very exciting stuff. www.devhut.net/table-driven-modern-menus/
@DanielPineault 3 күн бұрын
There will be one more video and sample in September. I'm off until then.
@bumpersmith Ай бұрын
Has anyone used or are using Claris FileMaker lately? if so, can you share comments on your experience?
@DanielPineault Ай бұрын
When I looked into it, the licensing cost simply made no sense to even think of using it.
@xavierbatlle1828 Ай бұрын
Good job! This workaround is much better than using the timer. 👏
@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.
@EvJahvan Ай бұрын
This is awesome, can't wait to see more on this UI Enhancement Series, Ms Access. Thanks for your sharing
@DanielPineault Ай бұрын
Thanks for watching!
@shaun120879 Ай бұрын
This is great because the site I'm working for I had to alter this to work on the WebBrowser Control instead of the EdgeControl
@DanielPineault Ай бұрын
Yes, new Modern Web Browser control has solved a lot of compatibility issues. That is its greatest improvement that it has brought to Access. We were basically stuck with IE 11 before that, sirca 2013! A lot of newer HTML, CSS and JavaScript were simply incompatible, well until this new control came along.