@johnclark851 You know it! LOL I figure why not let the cats have a debut :-) Thank you for the compliment on the format. Always open to suggestions to make it easier for all.
Excellent video thank you. I have never tackled the ribbon myself, always avoided it because it just looked a very complicated process. But now with your instructions, I feel confident I can easily create my own ribbon!
@NiftyAccessMicrosoft That comment alone makes all the hard work creating the video worth it! The thing to watch out for is how sensitive the XML code is. Recommend using Notepad++ for editing. Feel free to reply on here if you run into any issues. Happy coding!
Thank you very much for that video! It was a great start and motivation to learn more about how to customize that ribbon. Nice and detailed enough to get started for own projects 👍 thanks!! Now only custom „context menu“ are missing 😅 maybe i will also give it a try again… 😉
@@accessisnotdead Honestly, with your short videos, it's like i have done the practice and i already create 2 tabs with several menus inside, i learned the basic, and now i can do whatever i want, thanks
'''''''''''COPY AND PASTE INTO A NEW MODULE NAMED: modUSysRibbons ' '************************************************************************************* '1.) Module name: modUSysRibbons. '2.) Go to Tools-->References and check Microsoft Office 16.0 Object Library '3.) Create Tables: 'Table Name: USysRibbons 'Fields: 'ID AutoNumber 'RibbonName Short Text 'RibbonXml Long Text 'Comments Short Text 'Table Name: USysRibbonsImages 'ControlId Short Text 'Images Attachment 'Description Short Text '4.) Form Name: frmUSysRibbonsImages '5.) Create Macro: macOpenOrders '6.) Refer to next comment for XML code for Table USysRibbons 'Access is Alive! 'ua-cam.com/channels/F1tGDa9oHe-0zD639mNWZw.html '************************************************************************************* Option Compare Database Option Explicit Public MyRibbon As IRibbonUI Sub OnLoadRibbon(ribbon As IRibbonUI) Set MyRibbon = ribbon End Sub Public Sub getRibbonImages(control As IRibbonControl, ByRef image) Dim attach As Attachment DoCmd.OpenForm "frmUSysRibbonsImages", acNormal, , , , acHidden '************************************************************************************* 'UPDATE TO BUTTON NAME AND IMAGE NAME bSetRibbonImage control, image, "btnOrders", "Orders" 'Example where the Button name is in the XML Code:
Hi @44louix The below link from Microsoft will give you a breakdown of all the different types of XML tags you can use for different menu options. A Template would only be useful if it was for a specific type of application that had common commands, but you are really going to want to customize the menu to what makes sense for your application. learn.microsoft.com/en-us/openspecs/office_standards/ms-customui/700e4451-8706-40c5-8d7b-896e4ae21b69
Hi. No need to buy anything or subscribe. All the code included in the comments and shown in the video will get you a working custom Ribbon in Access. The Etsy link is incase you do not want to go thru the UA-cam tutorial. A $2 shortcut for you but not necessary. I'll be sure to be more clear in future videos. Thank you for the feedback!
@joshua4915 I would love to hear your opinion on what made you think the video was a promo. Your opinion matters and helps us to create more helpful videos.
![Lp. Сердце Вселенной #60 РОЖДЕНИЕ ЛОЛОЛОШКИ [Финал] • Майнкрафт](http://i.ytimg.com/vi/YoR0pAV9FVQ/mqdefault.jpg)
Like Nifty, the ribbon was always a "black box" for me. I like your format and you succinct way of explaining things - not bad for a Crazy Cat Lady!
@johnclark851 You know it! LOL I figure why not let the cats have a debut :-) Thank you for the compliment on the format. Always open to suggestions to make it easier for all.
Excellent video thank you. I have never tackled the ribbon myself, always avoided it because it just looked a very complicated process. But now with your instructions, I feel confident I can easily create my own ribbon!
@NiftyAccessMicrosoft That comment alone makes all the hard work creating the video worth it! The thing to watch out for is how sensitive the XML code is. Recommend using Notepad++ for editing. Feel free to reply on here if you run into any issues. Happy coding!
Thank you very much for that video! It was a great start and motivation to learn more about how to customize that ribbon.
Nice and detailed enough to get started for own projects 👍 thanks!!
Now only custom „context menu“ are missing 😅 maybe i will also give it a try again… 😉
Great idea for another video! How to customize the right click menu. Be sure to subscribe to be alerted of new videos.
@@accessisnotdead that would be great 😀 subscribe? … already done 😉 your Video was a good inspiration for the start!! Thank you 👍
Nice presentation....awesome!
If you have any questions or get stuck on anything let me know. It can take some practice editing the Ribbon.
@@accessisnotdead
Honestly, with your short videos, it's like i have done the practice and i already create 2 tabs with several menus inside, i learned the basic, and now i can do whatever i want, thanks
@@44louix Woohoo!!!! Go @44louix!
what could be reason ms access form wizard cannot find the table (USysRibbonImages) ?
Hi @md.omerkhayyam3343 If your options to hide System tables is on then USysRibbonImages will be hidden.
'''''''''''COPY AND PASTE INTO A NEW MODULE NAMED: modUSysRibbons
' '*************************************************************************************
'1.) Module name: modUSysRibbons.
'2.) Go to Tools-->References and check Microsoft Office 16.0 Object Library
'3.) Create Tables:
'Table Name: USysRibbons
'Fields:
'ID AutoNumber
'RibbonName Short Text
'RibbonXml Long Text
'Comments Short Text
'Table Name: USysRibbonsImages
'ControlId Short Text
'Images Attachment
'Description Short Text
'4.) Form Name: frmUSysRibbonsImages
'5.) Create Macro: macOpenOrders
'6.) Refer to next comment for XML code for Table USysRibbons
'Access is Alive!
'ua-cam.com/channels/F1tGDa9oHe-0zD639mNWZw.html
'*************************************************************************************
Option Compare Database
Option Explicit
Public MyRibbon As IRibbonUI
Sub OnLoadRibbon(ribbon As IRibbonUI)
Set MyRibbon = ribbon
End Sub
Public Sub getRibbonImages(control As IRibbonControl, ByRef image)
Dim attach As Attachment
DoCmd.OpenForm "frmUSysRibbonsImages", acNormal, , , , acHidden
'*************************************************************************************
'UPDATE TO BUTTON NAME AND IMAGE NAME
bSetRibbonImage control, image, "btnOrders", "Orders"
'Example where the Button name is in the XML Code:
HI, thats so cool, would you mind sharing some template with us or any site where i can get some template 🙂
Hi @44louix The below link from Microsoft will give you a breakdown of all the different types of XML tags you can use for different menu options. A Template would only be useful if it was for a specific type of application that had common commands, but you are really going to want to customize the menu to what makes sense for your application.
learn.microsoft.com/en-us/openspecs/office_standards/ms-customui/700e4451-8706-40c5-8d7b-896e4ae21b69
@@accessisnotdead
Thanks dear
You are the best
Love you
*Promo sm* 😴
Hi. No need to buy anything or subscribe. All the code included in the comments and shown in the video will get you a working custom Ribbon in Access. The Etsy link is incase you do not want to go thru the UA-cam tutorial. A $2 shortcut for you but not necessary. I'll be sure to be more clear in future videos. Thank you for the feedback!
@joshua4915 I would love to hear your opinion on what made you think the video was a promo. Your opinion matters and helps us to create more helpful videos.