Access 2010 Ribbon QAT Callback Error

[Stephen]

Hi, I'm having trouble getting Access 2010 to accept an "OnRibbonLoad" and "RibbonButtonClick" callback function at startup.

I obtained a working copy online and have copied the associated table, form and module into a new database. Unfortunately I cannot get the callbacks to work in the new database. I have attached the new database for your perusal and would really appreciate your advice or guidance.

My goal is to get the QAT functioning with a button click to a form.



I have done some investigating myself and obtained various samples/examples to work this out but all fail when I copy into a new database.

I am new to this and apologize if I am missing something obvious.

Thanks in advance
Steve

[Perceptus]

Thos are not functions in your module. they are Subs. Change to Sub to Function? Dont know what "examples" you used.

[Micron]

While I agree that most/all procedure calls of this nature have to be functions, I think the db you provided is missing a required reference because fixing the functions results in a user defined function error message. Try adding the Office library for your Access version. But my guess is that this just a stripped down version of your actual db and the real thing has the reference since there's no file or table to build a ribbon with either.

[Stephen]

Good afternoon,
Thank you for both...

I changed the subs to functions but still have the same problem. I also checked my office library for my Access 2010 version which didn't rectify the issue.

The sample I used to learn from is located here: http://www.accessribbon.de/en/?Acces...__Controls:QAT

I'm certain I copied everything that is required from the sample database but it still produces an error. Any further help would be appreciated.

Thanks

[pbaldy]

Post 4 was moderated, I'm posting to trigger email notifications.