Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Accces version 2304

Copper Contributor

With the upgrade to 2304 version, I have now a problem with the Ribbon :

When starting my application, VBA returns : runtime error 5 for the following code : 

=> MonRuban.ActivateTab "Atelier"

 

Is someone have the same problem with this upgrading ?

3 Replies
Perhaps you can explain what that tab is supposed to do. Apparently "Atelier" translates to "Workshop" or "Studio" in English, not familiar terms, unfortunately. Is this a custom ribbon? If so, what is the tab for? If it's part of the standard ribbon, maybe a hint as to which tab it is....

Thanks.
Thank you for answering. Our application is running with a full custom ribbon based on an XML file starting with:
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" onLoad="RubanCharge">
<ribbon startFromScratch="true">
<tabs>
<tab id="Pixo" label="Pixo" >
<group id="Identification" label="Identification">
.etc...
'Atelier' is a tab in the XML file:
<tab id="Atelier" label="Atelier" getVisible="Atelier_Visible">

All code in VBA and XML is running well. Since some PCs have been upgraded to Access version 2305, there is a VBA runtime error as described in my first post.
Trying to diagnose runtime errors requires a good amount of detail.

First, my original question was about the tab with this "Atelier" ID. The English translation doesn't appear to be something one usually sees in an English version of a ribbon like "Print Preview" , so I assume it is a custom function. What is it supposed to do?

Second, it's apparently happening on the getVisible callback. Do other tabs use that same callback? Do they work correctly?

And finally, the error message for Error 5. Is it "Invalid Procedure Call or Argument"? Or something else?

Remember the more details you are able to share, the more likely we are to be able to help, especially given the language difference.