[AccessD] Getting error of Ribbon argument

Thanks Martin and Max -- I feel like I'm in Bizarro World. :(

You shouldn't need a custom interface tool (Custom UI Editor) -- it should 
be just as simple in Word and Excel as it is in Access.

I did find a message from awhile back -- from David McAfee where he seems to 
accomplish what I originally tried (using ShowToolbar). Now, the original 
request was about doing this in Excel, but David doesn't say whether he 
tested it in Access or Excel. If someone got this to work in Excel, please 
share with me what event you used. Thanks!

Susan H.


----- Original Message ----- 
From: "David McAfee" <davidmcafee at gmail.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Wednesday, December 03, 2008 6:35 PM
Subject: Re: [AccessD] Turn off the ribbons programmatically


> Well, that works for me:
>
> IF SysCmd(acSysCmdAccessVer) = 12 THEN DoCmd.ShowToolbar "Ribbon",
> acToolbarNo
>
> I also put a command button on a test form to turn it back on.
>


Susan H.




>I have seen VBA solutions but XML is the general approach taken to work 
>with the Ribbon, Its usually a joint approach VBA and RibbonX. See
>
> http://www.rondebruin.nl/ribbon.htm
>
> http://www.xtremevbtalk.com/showthread.php?t=265636
>
> http://msdn.microsoft.com/en-us/library/bb421511.aspx
>
> Or better yet get this
>
> http://pschmid.net/office2007/ribboncustomizer/index.php
>
> I worked on the development of this with Patrick. Gets the job done. The 
> site also contains tons of info on RibbonX