I have encountered some known bugs in VBA app development for Access 07 before, so I searched extensively for this issue but to no avail.
I have built a custom ribbon, hand-coding the xml along with the schema and verified that the ribbon itself loads without a problem and the callbacks are set up to work properly.
But the problem is that they are not working. I am getting the error message about not being able to find the macro or callback function name, even though I have done the following:
- Put the callback in an attached module both as a public sub and function (even updating the xml's callback name string to "=Function()" as appropriate
- Loaded the ribbon by using the Current Database's custom ribbon field in Access Options ~and~ with the ribbon field in form properties.
- Loaded another 2007 database with a working custom ribbon stored in a table just like mine and could find absolutely no differences in the usage of xml or the method of calling an OnAction sub or function.
I would gladly post any of the code I have done if that would help solve this. Switching to an MDI full-screen interface would greatly benefit this project but this custom ribbon bit is all that stands in the way, and I am truly stumped.
Thanks everyone in advance..