toolbars 2007

[Flynners]

Hi
Ive read and tried many post on showtoolbar and customising ribbons in Access 2007 but I am not able to get what I want to work.

I want to use DoCmd.ShowToolbar "ribbon", acToolbarNo in the onload event of my login page. Combined with the different Access options like hiding the navigation bar etc I like how this looks. I do not want the Office Button in the top corner of my screen.

When certain reports open in print preview, I want a toolbar to export to excel/word/pdf and print, page setup options etc.
I have UsysRibbons table and have created a ribbon called MYREPORT

I have in the onload event of report
'DoCmd.ShowToolbar "MYREPORT", acToolbarYES
but I get debug error saying that it cannot find MYREPORT.
I have MYREPORT as the ribbon name in the other properties of the form, (it appears in the drop down selection under Ribbon Name, so I know it is created okay). my reports are not popup

What am i doing wrong? is the onload event of the report incorrect way to show only this toolbar.

yet again, any help greatly appreciated as this is very frustrating!

 

[Ari]

Hi

Hi You may need to reactivate the Access ribbon, and then activate the ribbon of the report.

Private Sub Report_Open(Cancel As Integer)
DoCmd.ShowToolbar "ribbon", acToolbarYes
Me.RibbonName = "myReport"
End Sub

 

[Flynners]

that worked lovely for me! thank you. I just had to put in acToolbarno command in the onclose event of the report to hide the ribbon again.

thank you very much for your help