如何在组合框中列出所有可用的报告? [英] How to list all available Reports in a combo box?
问题描述
我不断为一组用户创建报告。
对于简单的用户界面,我想创建一个表单,在下拉列表(组合框)中列出报表。
用户只需从下拉列表中选择所需的报告,然后点击打印按钮。
如何创建列出所有可用报告的下拉列表?
I am constantly creating reports for a group of users.
To simply the user interface, I would like to create a form that will list the reports in a drop down list (combo box).
The user would just need to select the desired report from the drop down list and click on a print button.
How can I create the drop down list that list all available reports?
推荐答案
嗨..
我不断为一组用户创建报告。
对于简单的用户界面,我想创建一个表单,在下拉列表(组合框)中列出报表。
用户只需从下拉列表中选择所需的报告,然后点击打印按钮。
如何创建列出所有可用报告的下拉列表?
问候,
Clarence
Hi..
I am constantly creating reports for a group of users.
To simply the user interface, I would like to create a form that will list the reports in a drop down list (combo box).
The user would just need to select the desired report from the drop down list and click on a print button.
How can I create the drop down list that list all available reports?
Regards,
Clarence
1 。为组合框的RowSourceType属性设置用户定义的函数(下拉列表) - 有关详细信息,请参阅RowSourceType的访问帮助。
2.要创建报告列表,请使用以下内容:
1. Set user-defined function for RowSourceType property of your combobox (drop down list) - see Access help for RowSourceType for the details.
2. To create a list of the reports, use something like this:
这是我前一段时间跑步的一步一步:
在表格上放置一个组合框。当向导出现时,单击取消。进入组合框的属性
设置名称为 ComboReports
将行源类型设置为表/查询
在RowSource框中输入:
Here''s the step-by-steps from a routine I ran up a while ago:
Place a combobox on your form. When the Wizard comes up click on Cancel. Go into the combobox?s Properties
Set Name to ComboReports
Set Row Source Type to Table/Query
In the RowSource box enter this:
嗨Linq,
你们得到了很大的帮助!
我偶然发现这个网站并且非常及时回复我发布的所有问题。
我印象深刻!
干杯!
Clarence
Hi Linq,
You have been a great help!
I stumbled into this website and get very prompt response to all my questions posted.
I am impressed!
Cheers!
Clarence
这里是我前一段时间的常规步骤:
在表格上放置一个组合框。当向导出现时,单击取消。进入组合框的属性
设置名称为 ComboReports
将行源类型设置为表/查询
在RowSource框中输入:
Here''s the step-by-steps from a routine I ran up a while ago:
Place a combobox on your form. When the Wizard comes up click on Cancel. Go into the combobox?s Properties
Set Name to ComboReports
Set Row Source Type to Table/Query
In the RowSource box enter this:
这篇关于如何在组合框中列出所有可用的报告?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!