Ribbon Not Showing In Packaged Solution

[funderburgh]

I have recently updated to 2010 (Wow!) and I have a long running distributed application that I have raised from a troubled child. The conversion went smoothly except for one issue (so far). I have an option on my reports menu to view a report in preview mode (acPreview) and in 2007 the report was displayed with a ribbon that allowed page formatting, printing and a close botton for the preview. In 2010 there is no ribbon showing on the preview. For clarity, the Access ribbion doe not appear anywhere else in either paclage, 2007 or 2010, just the controls I have programmed. I have examined the documentation but I can't find a new parameter or such to get the ribbon to display in the print preview mode. My users are getting uruly. Any help is welcome.

 

[Old Man Devin]

So have you generally disabled the ribbon, but use code to have certain controls show when relevant?

Answer might be to just enable the ribbon completely when previewing. Or if its the case the ribbon is just hidden rather than disabled, I think pressing Ctrl+F1 makes it appear and disappear.

But no I haven't ever seen something that controls just the print preview ribbon unfortunately!

 

[funderburgh]

Thanks for the response.

So have you generally disabled the ribbon, but use code to have certain controls show when relevant?

No, it has been so long since I created the application I don't remember explicitly disabling ribbons (there were no "ribbons" when I started). And I am not using anything specifically to create the ribbon on the prior (2007) version of the packaged solution. Here is the code that opens the preview window:

DoCmd.OpenReport [ReportName], acViewPreview

I examined the and properties on the Do Cmd method to see if there is an option to present a ribbon, but I can't find one.

Still stumped and getting gripes from the users. Any help is most welcome.

 

[Old Man Devin]

Possibly of help is the line:
DoCmd.ShowToolbar "Ribbon", acToolbarYes
Perhaps have on in the 'On Open' event for the report.

For me, opening using that line keeps the ribbon visible. It must be disabled as a result of the conversion, so perhaps running that enabling line just once will keep it there forever and it will behave as normal.

 

[prley]

Possibly of help is the line:
DoCmd.ShowToolbar "Ribbon", acToolbarYes
Perhaps have on in the 'On Open' event for the report.

For me, opening using that line keeps the ribbon visible. It must be disabled as a result of the conversion, so perhaps running that enabling line just once will keep it there forever and it will behave as normal.

+1 Like Old Man Devin said just issue the code above on all of your report open procedures. Then change the acToolBarYes to acToolBarNo to hide the menu again in the report close proc. I had to do this to all my reports that use the preview since I didn't want the user to see the ribbon anywhere else in the application.