I hope that all is well with everyone who reads this...I recently began using vba and I have a unique situation that I can't seem to find a definite answer too.
Here Goes... Currently, I am using working on a VBA program and using SQL 2008 for my back end and an adp file to be the front end with Microsoft Access 2007.
*I recently found out that I am not able to edit the ribbon like in any other version of access. I also found out that to customize it I must utilize some XML coding to create a USysRibbons table.
**This is all fair enough to me but what i want to know is how do I get the db to and my Adb to interact once I have done this..I have tried but am not successful.
IF ANYONE CAN SHED ANY LIGHT ON THIS PLEASE DO ASSIST
P.S.. the furthest i have gotten is to create the table in the back end.
I created the table with 3 fields namely: id type int, RibbonName type text , and RibbonXml
. I then ran an Insert Query in the back-end to insert values into the RibbonName and Xml field.. The problem for me now is that am not certain that the xml is working and also i don't know how to let the adp and the created table interact...