![D Pineault - Tech, Programming and more](/img/default-banner.jpg)
- 161
- 160 414
D Pineault - Tech, Programming and more
Canada
เข้าร่วมเมื่อ 16 มิ.ย. 2013
Just a developer trying to share some of my knowledge with others and hopefully make technology & programming a little more comprehensible and accessible.
My primary focus was Office & Office automation with Microsoft Access being my baby, but also have extensive experience automating Excel, Outlook and Word.
In later years, I have expanded into proper web development including HTML,JS/jQuery, CSS, PHP.... and will hopefully be starting to post video on this as well.
I have been awarded the title of Microsoft MVP every year since 2010, an Utter Access VIP, an Expert-Exchange Distinguished Expert and also Most Valuable Expert.
Everything on this channel is for educational purposes and provided 'as is' without any guarantees. Use at your own risk, validate for yourself ...!
You may find my content on:
✔️ TH-cam
✔️ devhut.net
✔️ cardaconsultants.com
I do not have Facebook, Twitter, Instagram, ... accounts. Only the 3 sites listed above.
My primary focus was Office & Office automation with Microsoft Access being my baby, but also have extensive experience automating Excel, Outlook and Word.
In later years, I have expanded into proper web development including HTML,JS/jQuery, CSS, PHP.... and will hopefully be starting to post video on this as well.
I have been awarded the title of Microsoft MVP every year since 2010, an Utter Access VIP, an Expert-Exchange Distinguished Expert and also Most Valuable Expert.
Everything on this channel is for educational purposes and provided 'as is' without any guarantees. Use at your own risk, validate for yourself ...!
You may find my content on:
✔️ TH-cam
✔️ devhut.net
✔️ cardaconsultants.com
I do not have Facebook, Twitter, Instagram, ... accounts. Only the 3 sites listed above.
Microsoft Access - Roadmap Review - September 2024
A monthly review, in this case September 2024, of the status of the Microsoft Access Roadmap and the entire Microsoft Access ecosystem.
What has happened since May, June, July, August, ...?
🗺️ What is the current state of the future of Microsoft Access according to the official Microsoft Roadmap!
🗺️ What are the next priorities of the Microsoft Access Dev Team?
🗺️ Where is Access headed? What can we expect coming down the pipes?
🗺️ What can we inspire ourselves with as to the future of this great product?
The roadmap mentions the "Monaco Framework", I believe they are referring to: microsoft.github.io/monaco-editor/ should you wish to get a vague idea of what might be coming.
📰 Article(s) on this Subject:
• www.devhut.net/microsoft-access-roadmap-september-2024-review/
⛐ Microsoft's Roadmap Website (filtered for Access):
• www.microsoft.com/en-us/microsoft-365/roadmap?filters=Access
🔊 Microsoft Access Dev Team's Blog:
• techcommunity.microsoft.com/t5/access-blog/bg-p/AccessBlog
📝 Microsoft 365 Various Channel Release Note:
• learn.microsoft.com/en-us/officeupdates/current-channel
• learn.microsoft.com/en-us/officeupdates/monthly-enterprise-channel
• learn.microsoft.com/en-us/officeupdates/semi-annual-enterprise-channel
• learn.microsoft.com/en-us/officeupdates/semi-annual-enterprise-channel-preview
• learn.microsoft.com/en-us/officeupdates/beta-channel
🛠️ Fixes or workarounds for recent issues in Access
• support.microsoft.com/en-us/office/fixes-or-workarounds-for-recent-issues-in-access-54962069-14f4-4474-823a-ff7e5974a570
👂 Microsoft Access Feedback Portal
•
feedbackportal.microsoft.com/feedback/forum/818e3b49-e61b-ec11-b6e7-0022481f8472
My Links:
🏭 www.cardaconsultants.com/ (business)
📢 www.devhut.net/ (blog)
What has happened since May, June, July, August, ...?
🗺️ What is the current state of the future of Microsoft Access according to the official Microsoft Roadmap!
🗺️ What are the next priorities of the Microsoft Access Dev Team?
🗺️ Where is Access headed? What can we expect coming down the pipes?
🗺️ What can we inspire ourselves with as to the future of this great product?
The roadmap mentions the "Monaco Framework", I believe they are referring to: microsoft.github.io/monaco-editor/ should you wish to get a vague idea of what might be coming.
📰 Article(s) on this Subject:
• www.devhut.net/microsoft-access-roadmap-september-2024-review/
⛐ Microsoft's Roadmap Website (filtered for Access):
• www.microsoft.com/en-us/microsoft-365/roadmap?filters=Access
🔊 Microsoft Access Dev Team's Blog:
• techcommunity.microsoft.com/t5/access-blog/bg-p/AccessBlog
📝 Microsoft 365 Various Channel Release Note:
• learn.microsoft.com/en-us/officeupdates/current-channel
• learn.microsoft.com/en-us/officeupdates/monthly-enterprise-channel
• learn.microsoft.com/en-us/officeupdates/semi-annual-enterprise-channel
• learn.microsoft.com/en-us/officeupdates/semi-annual-enterprise-channel-preview
• learn.microsoft.com/en-us/officeupdates/beta-channel
🛠️ Fixes or workarounds for recent issues in Access
• support.microsoft.com/en-us/office/fixes-or-workarounds-for-recent-issues-in-access-54962069-14f4-4474-823a-ff7e5974a570
👂 Microsoft Access Feedback Portal
•
feedbackportal.microsoft.com/feedback/forum/818e3b49-e61b-ec11-b6e7-0022481f8472
My Links:
🏭 www.cardaconsultants.com/ (business)
📢 www.devhut.net/ (blog)
มุมมอง: 159
วีดีโอ
Microsoft Access - msaccess.exe process hangs
มุมมอง 385วันที่ผ่านมา
Be sure to look at my article as more information has been provided there since this video was published! It would seem that the latest update(s) have broken Access and made it so that even after you close your database it is possible that the msaccess.exe process remains running behind the scenes (commonly referred to as a hung process, hidden process, ...). Some of the symptoms being reported...
Microsoft Access - Best Practices
มุมมอง 1K21 วันที่ผ่านมา
In this video, I try to discuss the most important best practices to implement when creating a Microsoft Access database to avoid pitfalls, avoid pain and frustrations. So if you want to get off on t he right foot then this is the video for you! Article(s) on this Subject: • www.devhut.net/access-best-practices-and-troubleshooting-steps/ My Links: 🏭 www.cardaconsultants.com/ (business) 📢 www.de...
Microsoft Access - Roadmap Review - August 2024
มุมมอง 28821 วันที่ผ่านมา
A monthly review, in this case August 2024, of the status of the Microsoft Access Roadmap and the entire Microsoft Access ecosystem. What has happened since May, June, ...? 🗺️ What is the current state of the future of Microsoft Access according to the official Microsoft Roadmap! 🗺️ What are the next priorities of the Microsoft Access Dev Team? 🗺️ Where is Access headed? What can we expect comi...
Petition To NOT Remove VBScript
มุมมอง 3932 หลายเดือนก่อน
With Microsoft's announcement about deprecating VBScript, some in the community have organized a petition to ask them to stop! So here is your only chance to have you voice heard on the matter and perhaps get Microsoft to reconsider this decision the ramifications of which will be felt in every corner of the IT world from IT Admins, to developers, to power users and beyond! Please share with yo...
Microsoft Access - Roadmap Review - July 2024
มุมมอง 3662 หลายเดือนก่อน
A monthly review, in this case July 2024, of the status of the Microsoft Access Roadmap. What has happened since May, June, ...? 🗺️ What is the current state of the future of Microsoft Access according to the official Microsoft Roadmap! 🗺️ What are the next priorities of the Microsoft Access Dev Team? 🗺️ Where is Access headed? What can we expect coming down the pipes? 🗺️ What can we inspire ou...
How To Open Internet Explorer
มุมมอง 4562 หลายเดือนก่อน
Demonstrating a few remaining options for opening/launching Internet Explorer. No, I haven't lost all my marbles! I know this seems like a weird subject to cover in 2024, but trust me it is extremely relevant for some developers! Since Microsoft has crippled our ability to directly launch Internet Explorer, here are a few techniques that still work to open Internet Explorer. This is especially ...
Microsoft Access - Modern Web Browser Control - Not Rendering - Blank - Bug
มุมมอง 4122 หลายเดือนก่อน
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: th-cam.com/video/XwfUdJ15xyI/w-d-xo.html Table of Contents: 00:00 - Introduction 00:42 - The Basics 02:05 - The Bug 05:02 ...
Microsoft Access - Modernizing The Interface - Part 2
มุมมอง 1K2 หลายเดือนก่อน
Demonstrating how we can integrate the power of HTML into an Access database to incorporate contemporary menus to give Access' interface a much needed facelift! In this, Part 2, I demonstrate how we can add security to control which items of the menu are available to different users/groups and also how we can drive the menus from tables so they are dynamically data driven (this also could be a ...
Microsoft Access - Modernizing The Interface
มุมมอง 3.2K2 หลายเดือนก่อน
Demonstrating how we can integrate the power of HTML into an Access database to incorporate contemporary menus to give Access' interface a much needed facelift! Sadly, there are certain issues with the Modern Web Browser control making it impossible to use local resources (JS, CSS) in certain cases, and making it impossible to do everything in VBA. Perhaps one day the Access Dev Team will fix t...
Microsoft Access - Roadmap Review - June 2024
มุมมอง 3513 หลายเดือนก่อน
A monthly review, in this case June 2024, of the status of the Microsoft Access Roadmap. 🗺️ What is the current state of the future of Microsoft Access according to the official Microsoft Roadmap! 🗺️ What are the next priorities of the Microsoft Access Dev Team? 🗺️ Where is Access headed? What can we expect coming down the pipes? 🗺️ What can we inspire ourselves with as to the future of this gr...
Microsoft Access - Microsoft Graph REST API - Retrieving A Users ID
มุมมอง 3313 หลายเดือนก่อน
In a continuation of my exploration of the Microsoft Graph API as a replacement for Outlook Automation (since the New Outlook will not support any VBA automation), I wanted to explore the User Id. This id is required when preforming advanced Graph REST API automation to manipulate other users calendars, contact, e-mails, ... It is also required should you wish to retrieve information regarding ...
Microsoft Access - Microsoft Graph REST API - Creating Calendar Events via Outlook
มุมมอง 5393 หลายเดือนก่อน
Demonstrating how we can use the Microsoft Graph REST API to create new Outlook.com calendar events from our Microsoft Access application using a simple VBA functions. Article(s) on this Subject: • www.devhut.net/use-the-microsoft-graph-rest-api-to-create-an-event-in-the-users-calendar/ My Links: 🏭 www.cardaconsultants.com/ (business) 📢 www.devhut.net/ (blog)
Microsoft Excel - Quick Tip - Parsing Data Without Formulas!
มุมมอง 2813 หลายเดือนก่อน
Discussing how in some instances, employing AutoFill rather than building custom parsing formulas can be much more efficient and a real time saver! The same is true if you are looking to combine data. Simple, effective and no formulas to build, no functions to understand! It's one of these "work smarter, not harder" tips! It won't be applicable to all scenarios, but when you can use it, it will...
VBA - Including Line Numbers In Your Error Handler
มุมมอง 6184 หลายเดือนก่อน
Discussing VBA Error Handling and specifically how you can add the Line Number that triggered the error to it so you can easily identify exactly where the issue occurred thus making your VBA error handler truly useful to you as a developer and saving you debugging time and frustrations. My Article On Error Handling: • www.devhut.net/ms-access-vba-error-handling/ Useful Links: • learn.microsoft....
Microsoft Access - Microsoft Graph REST API - Send Email via Outlook.com
มุมมอง 1.1K4 หลายเดือนก่อน
Microsoft Access - Microsoft Graph REST API - Send Email via Outlook.com
Microsoft Access - Roadmap Review - May 2024
มุมมอง 3504 หลายเดือนก่อน
Microsoft Access - Roadmap Review - May 2024
Microsoft Access - Google REST API - Send Email via Gmail
มุมมอง 1K4 หลายเดือนก่อน
Microsoft Access - Google REST API - Send Email via Gmail
VBA - Quick Tip - Searching Through Your Code
มุมมอง 2604 หลายเดือนก่อน
VBA - Quick Tip - Searching Through Your Code
Microsoft Outlook - Blocking SPAM from your inbox
มุมมอง 1844 หลายเดือนก่อน
Microsoft Outlook - Blocking SPAM from your inbox
Microsoft Access - AutoResize Combo box and List box Columns
มุมมอง 4594 หลายเดือนก่อน
Microsoft Access - AutoResize Combo box and List box Columns
Microsoft Access - Navigation Pane Disappearing Objects Bug
มุมมอง 1804 หลายเดือนก่อน
Microsoft Access - Navigation Pane Disappearing Objects Bug
Microsoft Access - Modern Web Browser control - URL Parameter With Local Files Bug
มุมมอง 2654 หลายเดือนก่อน
Microsoft Access - Modern Web Browser control - URL Parameter With Local Files Bug
Microsoft Access - Roadmap Review - April 2024
มุมมอง 4804 หลายเดือนก่อน
Microsoft Access - Roadmap Review - April 2024
Microsoft Access - Modern Web Browser control - Disappearing Control Source
มุมมอง 2904 หลายเดือนก่อน
Microsoft Access - Modern Web Browser control - Disappearing Control Source
VBA - Determine if a font is installed
มุมมอง 1665 หลายเดือนก่อน
VBA - Determine if a font is installed
Microsoft Access - Modern Web Browser control - Blank - Current Event Bug
มุมมอง 3145 หลายเดือนก่อน
Microsoft Access - Modern Web Browser control - Blank - Current Event Bug
Microsoft Access - Alive, Under Active Development And Not Dead
มุมมอง 1.5K5 หลายเดือนก่อน
Microsoft Access - Alive, Under Active Development And Not Dead
MS is abandoning Access. It's not as sexy as web anything.
Adding my front end's location as a trusted location has worked for me so far. Thanks for the tip on your updated blog post. It saved me a lot of grief.
Truly happy to hear. Let's hope a fix comes out on Patch Tuesday next week and we can put all of this behind us.
Many thanks Daniel, I had big problems with my application apart from the hanging one and followed your instructions to roll back. All good now waiting for Microsoft to fix it. Could be a while.
Another MVP has started a good is coming on patch Tuesday, but in the same post was asking for steps to reproduce the issue. So this has me worried. How can a fix be getting released on Tuesday if they are still trying to replicate the issue??? All I know is we're all waiting for Microsoft to fix this.
@6:49 I will let you know when I get the EdgeControlFE working, still working the BE code. Web standards is the way to go for the "modern controls" experience.
Bring able to port 'web' design is nice, but the Access controls need some love all around. It all remains very dated.
Awesome and well explained Thankyou
Glad you liked it.
This is very helpful... thank you so much... learned so much with you explaining it via video vs text... any tips to optimize queries? As well as dao vs ado recordset?
Thank you for the feedback. I've noted the suggestions for future videos.
I had that error and I saw an old solution from Computer Learning zone TH-cam channel and the issue was fixed by just adding the paths of the databases to be in the list of trusted locations. After closing any database the .laccdb disappears as a normal.
Interesting.
@@DanielPineault I saw another possible solution from Richard and it was rollingback to a previous version. In my case it was just the trusted location issue.
Yes, I mentioned that. Typically, when any big happens, rolling back the build is the best option while waiting for Microsoft to provide an official fix.
@AzulonKaiba : I've just tried this solution and indeed if fixes the issue, thanks for this
Great! 👍
I created a batch file with "taskkill /IM "msaccess.exe" /F"
Another great solution! Thank you for sharing here for others to benefit from.
Thanks for the heads up. I've been recommending 2404 for months now. after 2405 where we had that performance and freezing issue. The one they fixed in 2406 but broke it again on 2407. It's strange they actually introduce new bugs while there's not much on being shared release-notes.
The Access Dev Team has always been very poor at all forms of communication. There's no rigor in what they do on that front. They've tried all sorts of things over the years, but nothing seems to ever stick. You'd think Release Notes would be a priority, but nope, the seldom provide any at all!!! The Fixes and Workarounds page hasn't seen any updates since February. We all know there have been, and remain several issues, yet there aren't documented. There blog hasn't seen any posts since May. It's all very disappointing to say the least.
In the article on your website, you finished by saying "In the coming days I will be working further on both articles to add more information." Did this happen and where might I find it? Thanks
No, I haven't revisited the Google API any further and rather concentrated on the Microsoft Graph API. I will eventually revisit it, I just don't know when. In reality, I've played around, developed code, but haven't had the opportunity to write the article or create videos on the subject matter.
Nice compilation, most of which i knew and follow follow. The one about one subform to hold a graphic was new to me. I was amused by how many consist of turning off various conveniences that access provides.
Glad you enjoyed it!
Good on you 👍👏
Thank you
I'm with you on having as much as possible in the UI driven by the database. Have you considered keeping your templates in a table? You don't need to do all of that string concatenation.
Yes, I have. In some ne cases it would be very simple to achieve, but in other cases with CSS, J's, ... files it becomes much more problematic to implement.
Great demo! Thanks.
Thanks for watching!
Can you please teach me how to prepare this type of menu, thank you very much
The link in the description provides you with my article and demo database. Everything you need is there.
@@DanielPineault thanks
Saludos, envia este mensaje : Acceso bloqueado: Error de autorización Client missing a project id. Si eres un desarrollador de esta app, consulta los detalles del error. Error 401: invalid_client
¿Ha configurado la variable en el módulo mod_Google?
Thanks for your review and update on Microsoft Access Roadmap. Quite disappointing that Microsoft doesn't seem to give the needed attention to user feedback and improvement requests. Thanks so much for your commitment Sir. Regards
Yes, it is sad how poorly Microsoft listens, or should I say doesn't listen.
Awesome, thanks for sharing your guidelines and best practices. Very helpful.
My pleasure.
TNX FOR THE HELP
My pleasure and glad you found it useful.
Thanks for supplying the attachment method database as a download, this saves me a ton of time trying to workout it out for myself the way that it is demonstrated in the db download (method 2)
My pleasure and glad you found it helpful.
Each one of these rules deserves its own 10 minute video. And worthy of argument on the nuances. Each developer encounters their own unique challenges which may require variations on these rules but these are a very good start.
Agreed, I could easily expand on most, but I was trying to make a smaller, more easily digestible overview video. Sometimes less is more. I'm hoping this was one of those cases.
Microsoft Access - Best Practices = Don't use it, use a real database
Nope. Every database has issues and best practices, that doesn't mean that Access isn't a great system. Like everything else, it's about mastering the tool so we get the most out of it with the least issues and effort. Add to that the fact that several of these rules apply to any database, not just Access! Then there's the whole distinction between back-end vs front-end, where Access typically can't be beat on the front-end side of things.
SMH
Quite certain best practice is NOT to use Microsoft Access. Real databases exist, and for all other needs just do SQlite.
Nope. Access remains an excellent option! "Real databases", oh please. Microsoft Access remains ('one of the' - some people had an issue with the statement) the most widely used database in the world. It drives most businesses (even when management and IT don't realize it!). Heck, I don't know if it is still the case, but at one time QuickBooks, used by thousands of not millions of people, was an Access database! And I can give countless more examples of Access being just fine as a database. Access is one of the grandfathers of databases, brought mouse/GUI design to the database world and 30+ years later is still going. Like all tools, you need to know how to effectively work with it to get the most out of it. You also have to properly assess the requirements of each project and select the proper tool for the job. Access remains an excellent choice for a great many projects. Add to that the fact that many of these best practices apply to any database in reality, not just Access!!! Typically, those having issues with performance, file size and various other issues are those who simply ignore such best practices and choose to ignore advice!
The people who don't like Access are usually the ones who don't understand Access.
@@DanielPineault You wouldn't just go on the internet and tell lies would you? I am a billion percent certain SQLite is used WAAAAAAY more than Access. More than a trillion SQLite databases exist.
Now you wish to insult me, call into question my morals and ethics. Nothing to actually argue the issue you brought forth so now you try attacking me. Sad. I have no issue having real discussions, but this isn't one the way you have choosen to act. I see where this is headed. No point continuing any further. Take care.
√√√
Thank you
Thank you for the basics reminder, I have learned a few of the pitfalls.
Glad it was helpful!
I agree with you 100% of your advices. I also use a couple of features (with no issues) that you don't talk about: 1) Calculated fields on tables 2) Data macros Many access developers claim that they don't have to be used, but I dissagree with them.
I avoid both. In the right hands they are fine, but I still like to do calculations in queries and data changes and trigger them myself. There also the issue of upsizing to other RDMS with such feature implemented. But many use them and love them.
Thanks Daniel, I learned something new today. I was not previously aware of the Track name AutoCorrect and record-Level Locking properties. I don't recall seeing these discussed anywhere else (or perhaps I was not paying attention).
The 'Track name AutoCorrect info' is one of those debatable issues. Used to be an issue, not sure it still remains one, but since I never use the feature, I disable it by habit. As for Record-Level Locking it is shocking the impact it can have one a database's file size! It's one change all developers should implement. I learnt about it from a discussion where Albert Kallal explained it to someone having bloating issues.
my access database is very slow as search in list box or barcode reader its about 50k records plz guid me.
Slow? How exactly is it slow? I'd recommend posting in a good forum. Currently I'm privileging Experts Exchange.
Extraordinary. With a multi-million user base - and thousands of developers who've been through the 'wars' helping users, this level of corporate disinterest is embarrassing. It's been my experience over 30 years, that Access is the go-to solution for small consulting companies that conduct monitoring and survey programs for their clients. Access offers rapid app development, reliable data management, relatively-easy data query ('relative for non-experts), and sufficiently-sophisticated analysis, reporting and export for these consulting companies to rest assured they're providing their clients with quality data. I continue to support at least 20 of these companies with their small, but business-critical, Access 'applications' because they cannot justify the initial and on-going cost of transitioning to cloud solutions, so they rely on Access; it feeds them, it feeds their clients, and it feeds me. How many repeats of this small-scale but valuable contribution must small business be making to society, across the Globe, for Microsoft to have apparently lost interest?
It's sad, and now, with Microsoft so aggressively pushing everything to the web, killing VBA in Outlook, killing VBScript, ... one has to serious wonder what the future has in store for Access.
Any ideas why the "Get-ADUser -Filter { cn -like 'John Wick'} | select UserPrincipalName" cmdlet works but only in the PS_GetOutput example with writing to a file? In all other cases, calling PS_GetOutput with the mentioned cmdlet returns vbNullString. I use Excel 2019.
Not sure. I'd suggest making the command prompt visible and testing things that way to see if anything is reported back. Also trying the PS command at the command prompt level and see what it spits back.
Kindly share your email if you work as a freelancer
If you wish to contact me you may do so through my website at: cardaconsultants.com/contact-us/
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.
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
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.
Thanks for the vscode tip. I use it for PHP coding, but never really done any HTML, so it's nice to learn about such features. I normally just use Notepad++, but having such tools makes me want to try it out in my next project. Thanks for sharing.
@@DanielPineault With VSCode you can run liversever and see changes in the webpage automatically after saving the page, this saves a lot of time. VSCode also highlights any errors in your code.
I don't see the time saving vs my current technique and pressing refresh on the browser. I'll have to try it out and see for myself. Thanks for sharing.
@@DanielPineault It's not much, but I do like the convenience of using a form to update the menu and change the order of the menu items. The biggest thing is creating the navigation menu exactly how I want it and adding in custom logo's and such. I have started to take a deep dive into HTML & CSS lately to hopefully have the skills to create whatever I need and make it all work. The whole space is a lot better then it used to be when I first learned it back in 2014. I like the idea of the horizontal menu at the top with a mega menu drop down that automatically resizes as new item links are added or removed from it. This can all be done with HTML and CSS only which is totally awesome.
I can understand that preference, especially since it is being used within a database after all.
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.
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?
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.
AWesome!
Thanks!
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.
excelent video and concepts Thanks
Thank you for watching and your feedback.
Signed the petition out of moral support
Thank you
Could this be a way for MS to gauge demand, and then charge for it as another form of artificial segmentation?
God only knows!
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.
Oh, it's used for so much more than that! But yes, like me, it's still around!
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!