Yes! Glad you are playing with a vision on the future of MS Access interfaces. All HTML/CSS/JS.... Also, you can dynamically load JS frameworks like htmx, bootstrap....etc. GUI possibilities are endless. I am working on htmx incorporation, still a WIP. What's best yet, you can go crazy with data visualizations with things like the D3.js framework. If MS ever goes full blown TypeScript support integrated, it is "swoon" for the MS Access community.
Agreed, several years ago, there's a post on my site, I integrated Chartjs to get better charts in Access and it worked quite nicely. Did another one which incorporated Code.js to provide a better SQL editor. Done others for image editing, pdf work, ... Lots of possibilities. The issue right now is there are several bugs with the Modern Web Browser control that are making development a lot harder than it should be!
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.
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.
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 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.
thanks mate, can you please dedicate a video for making combo box modern like the html CSS models and your video about date picker maybe it can be updated today we have the new web control that support edge browser
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
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
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 tags. In this case, you want to modify the Color: #fff; entries.
This is awesome, can't wait to see more on this UI Enhancement Series, Ms Access. Thanks for your sharing
Thanks for watching!
Yes! Glad you are playing with a vision on the future of MS Access interfaces. All HTML/CSS/JS.... Also, you can dynamically load JS frameworks like htmx, bootstrap....etc. GUI possibilities are endless. I am working on htmx incorporation, still a WIP. What's best yet, you can go crazy with data visualizations with things like the D3.js framework. If MS ever goes full blown TypeScript support integrated, it is "swoon" for the MS Access community.
Agreed, several years ago, there's a post on my site, I integrated Chartjs to get better charts in Access and it worked quite nicely. Did another one which incorporated Code.js to provide a better SQL editor. Done others for image editing, pdf work, ... Lots of possibilities.
The issue right now is there are several bugs with the Modern Web Browser control that are making development a lot harder than it should be!
Thank you for your great ideas, hard work, and for sharing your knowledge.
My pleasure. I'm just glad you enjoyed it and found it useful!
Awesome, i will try to use this in my projects thanks alot for such a awesome information.
Truly glad you find it useful. Thank you for your feedback.
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
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.
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.
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 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.
I did plan on doing one more video, so I'll try to add these into the mix.
@@DanielPineault I'll be very thankful if you could share the video
thanks mate, can you please dedicate a video for making combo box modern like the html CSS models and your video about date picker maybe it can be updated today we have the new web control that support edge browser
Thank you for the ideas.
Any chance you will upload this VBA/database as well? I can't seem to find it on your website :(
The basic version is there (part 1), part 2 is coming in the near future.
It's on his site now. Very exciting stuff. www.devhut.net/table-driven-modern-menus/
There will be one more video and sample in September. I'm off until then.
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
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.
@@DanielPineault
Thank you
Appreciated 🫡
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
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 tags. In this case, you want to modify the Color: #fff; entries.
Thanks for the response and directions
I keep digging
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/