How to Customize Microsoft Access Ribbon
ฝัง
- เผยแพร่เมื่อ 15 ต.ค. 2024
- Today we discover how to make the Microsoft Access Ribbon look like Your Application; Not Access. Get rid of that Ribbon! It is scary stuff! Teach your users to use Your application Not Access.
Main Points:
In under 5 minutes learn to Customize the Ribbon in Microsoft Access.
Refer to Top comments for VBA code and XML Code used in video.
Buy the Code:
Working Code presented in video available on Etsy:
www.etsy.com/l...
Thank you for checking-in at Data Check-in! Your source for all things data using Microsoft Access, Excel and VBA.
Subscribe to get the latest videos on Microsoft Access, Excel and VBA!
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.
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
'''''''''''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!
'th-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:
*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 TH-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.