Showtoolbar Macro

[Dartagnan]

According to the msdn microsoft site you can
"If you want to show a particular toolbar on just one form or report, you can set the OnActivate property of the form or report to the name of a macro that contains a ShowToolbar action to show the toolbar."

When I look through the various macro commands available I do not see showtoolbar available.

My goal is to show only the print preview ribbon when a user opens a report. I have already closed the ribbons using docmd.showtoolbar "ribbon", actoolbarno. For some reason docmd.showtoolbar "print preview", actoolbaryes", in the code, will not open the print preview ribbon.

Any thoughts.

Thank you in advance.

 

[SydneyGeek]

Open the form in Design view and go to its Properties. In either the All or the Other tab, you will see the Toolbar property. Pick your custom toolbar from the drop-down list, and it should display when the form is active.

Denis

 

[Dartagnan]

No luck. I don't see my custom toolbar.

Recap:
In my report On Load event I run docmd.showtoolbar, actoolbarno.

In Properties / Other I selected my custom toolbar in the Toolbar option.

 

[SydneyGeek]

If you are in 2007, toolbars don't work; you need to have a ribbon / tab that you can set up to display when the form shows. To select a ribbon, use the Ribbon Name property of the form / report. To build the ribbon, download a ribbon creator. The free version lets you build a limited number of buttons and groups.

Denis

 

[Dartagnan]

So doing a custom ribbon won't work either?

 

[SydneyGeek]

If you have a custom ribbon, you can assign it to the form but you must use the Ribbon property, not the Toolbar property.

Denis

 

[Dartagnan]

I am certain I am missing something. For security I have hidden the database window, the navigation pane and all ribbons. However, I need the print ribbon to open when a user opens a report.
In 2003 I accomplished this with the following code:
'SHOW THE CUSTOM REPORTS TOOLBAR
For i = 1 To CommandBars.Count
If CommandBars(i).name = "al toolbar" Then
CommandBars(i).Enabled = True
CommandBars(i).Visible = True
End If
Next i

In 2010 I have a custom ribbon, but can't get the ribbon to open when the report opens. I have tried code and I have tried using the ribbon property found on the Other tab.

 

[SydneyGeek]

See if this link helps.
http://msdn.microsoft.com/en-us/library/ff861708.aspx

You may have missed the step that loads the custom UI; by the sound if it the other bits are in place.
Link: http://msdn.microsoft.com/en-us/library/ff194416.aspx

Denis