Access 2007 Toolbar Issue

[RMCompute]

We have set up a function as listed below to display a custom toolbar used to
export data from the report. The function is called from the open event of
each report:

Function CBShowPrint()
Application.CommandBars("BranchPrint").Enabled = True
Application.CommandBars("BranchPrint").Visible = True
End Function

We recently converted from Access 2003 to Access 2007. (The custom toolbar
was created in Access 2003. There are 3 issues with the conversion:

1) The user must now click on the menu item Add-Ins to display the toolbar
2) The Export to Excel no longer functions indicating an incorrect format.
3) The Export to Word has disappeared

My questions are as follows:

1) Can the Add-Ins click be bypassed programmatically, so the user sees
the custom toolbar as soon as the report opens.

2) It is my understanding that Access 2007 no longer allows the creation of
custom toolbars. Can the above function be modified to programmatically
display toolbar items which allow extracts to Excel and Word for the Access
2007 format

Thanks in advance.

 

[Alex Dybenko]

Hi,
in Access 2007 you have to use ribbon instead of toolbars, here you can find
info how to make custom ribbon:
http://www.accessribbon.de/en/

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com