Access 2007工具栏问题 [英] Access 2007 Toolbar Issue

问题描述

我们已经设置了如下所列的功能，以显示用于从报告中导出数据的自定义工具栏。该函数从每个报告的开放事件中调用：


函数CBShowPrint（）

Application.CommandBars（" BranchPrint"）。Enabled = True

Application.CommandBars（" BranchPrint"）。Visible = True

结束功能


我们最近从Access 2003转换为Access 2007.（自定义工具栏是在Access 2003中创建的。转换有3个问题：


1）用户现在必须单击菜单项目加载项以显示工具栏

2）导出到Excel不再起作用，表示格式不正确。

3）导出到Word已消失


我的问题如下：


1）可以通过编程方式绕过加载项单击，这样用户就可以看到

报告打开后立即自定义工具栏。


2）据我所知，Access 2007不再允许创建

自定义工具栏。可以通过编程方式修改上述功能

显示工具栏项目，允许提取到Excel和Word for Access

2007格式


提前谢谢

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

推荐答案

我刚看了昨天对2007 Ribbon进行自定义的选项。功能区使用XML作为其源，因此您在Access中执行的操作是在数据库中创建一个名为USysRibbons的表。 ID，RibbonName和RibbonXML字段。以适当的格式创建XML并将其放在RibbonXML字段中，然后使用Startup中的RibbonName属性或任何表单或报表加载所需的自定义功能区。


这是我在msdn上看到的关于它的教程：
http://msdn.microsoft.com/en-us/library/aa338202.aspx


没有办法使旧的2003工具栏出现在除加载项之外的任何地方。如果您要使用2007或更新版本，则应使用功能区。


本教程还介绍了如何与其他Office应用程序集成，这些应用程序应该回答有关导出到Word的问题或Excel。


编辑：PS本教程是第3部分中的第1部分。第一部分介绍自定义功能区，第二部分介绍和描述功能区的属性和元素，第三部分是常见问题解答。这三个部分在msdn站点左侧的列表框中组合在一起。

I was just looking at the options for making customizations to the 2007 Ribbon yesterday. The Ribbon uses XML as its source, so what you do in Access is create a table in your database called "USysRibbons" with ID, RibbonName and RibbonXML fields. Create the XML in the proper format and put it in the RibbonXML field, then load the custom ribbon you want using the RibbonName property in Startup or on any form or report.

This is the tutorial on it from msdn that I was looking at:
http://msdn.microsoft.com/en-us/library/aa338202.aspx

There isn''t a way to make an old 2003 toolbar appear anywhere other than "Add-Ins." If you''re going to be using 2007 or newer, you should use the Ribbon.

The tutorial also explains integrating with other Office applications, which should answer your question about exporting to Word or Excel.

P.S. This tutorial is part one of 3. The first part explains customizing the Ribbon, the second enumerates and describes the attributes and elements of the Ribbon, and the third is a FAQ. The three parts are grouped together in the list box on the left side of the msdn site.

谢谢。我已经开始浏览示例并已成功创建功能区上的项目。 （它似乎具有比以前更多的功能，但是，使用2003工具栏它曾经更简单，更容易！）

Thank you. I have already began going through the examples and have successfully created items on the ribbon. (It seems to have a lot more capability than before, however, it used to be simpler and easier with the 2003 toolbars! )

做丝带时必须有两个工具：

IDBE Ribbon Creator

A可视化功能区设计器..您可以直接将其与数据库连接，或从头开始创建功能区并将代码导出到XML。我通常在使用新功能（下拉框，复杂菜单等）时使用它，查看代码如何导出，然后将其实现到我的数据库中。

Office 2007自定义UI编辑器

简单的智能感知验证器。当你搞砸你的代码并且需要确切地知道出了什么问题时，这很好。

Two must have tools when doing your ribbons:

IDBE Ribbon Creator
A visual ribbon designer.. you can interface this directly with your database, or create ribbons from scratch and export the code to XML. I usually use this when using a new feature (drop down boxes, complex menus, etc), see how the code gets exported, and then implement that into my database.

Office 2007 Custom UI Editor
A simple intellisense validator. Good for when you screw up your code and need to find out exactly what went wrong.

这篇关于Access 2007工具栏问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！