将过滤器应用于报告 [英] Apply Filter to A Report
问题描述
我已根据报告设计了一份报告。当我在Forms
或Tables中使用过滤时，当我在Reports中时，我看不到选择过滤列表的方法，并且
似乎没有办法做当我在报告时过滤。
我收到了两条回复此消息，几天前发布在
另一个主题内。一个需要编写类型语句。这应该不需要
- 访问必须有一个快速的方法来点击某些东西
将过滤器应用于我已经格式化的报告布局。另一个回复说
基于一个查询的报告 - 在我看来，如果我那么我只能这样做
创建一个新的报告。
感谢任何能给我简单说明的人，
Access，但肯定不在帮助菜单中。
Neil
Carol Wilson画廊的猫画作品
http： //www.carolwilsongallery.com
2004年11月11日19:52:27 GMT，Nhmiller写道：
我已经在Reports下设计了一个报告。当我在Forms
或Tables中使用过滤时，当我在Reports中时，我看不到选择过滤列表的方法，并且当我在Reports中时似乎无法进行过滤。
我收到了两条对此消息的回复，几天前发布在另一个主题内。一个需要编写类型语句。那应该没有必要 - 访问必须有一个快速的方法来点击某些东西来将过滤器应用到我已经格式化的报告布局。另一个回复说基于一个查询的报告 - 在我看来，如果我再创建一份新的报告，我只能这样做。
感谢任何人可以给我一些必须在访问中的简单说明，但肯定不在帮助菜单中。
尼尔
卡罗尔威尔逊画廊的猫画
http://www.carolwilsongallery.com
Are您使用表单，并使用过滤按
选择过滤记录或按表格过滤或工具按钮？
如果是这样，请在表单中添加一个命令按钮。
代码点击事件：
DoCmd.OpenReport" ReportName"，acViewPreview ,, Me.Filter
过滤表单上的记录，然后点击按钮。
-
Fred
请回复此新闻组。
我不回复个人电子邮件。
>您是否正在使用表单，并使用按选择过滤来过滤记录。或按表格过滤或工具按钮？
是，按选择过滤
如果是，请在表单中添加一个命令按钮。
编码它的点击事件：
DoCmd.OpenReport" ReportName"，acViewPreview ,, Me.Filter
我的报告名为Roster。我只是用名册代替吗？对于ReportName？我继续试试这个并没有发生任何事情，我继续如下：
过滤表格上的记录，然后点击按钮。
你知道我做错了什么吗？另外，怎么会有人知道使用这样的声明
？我很惊讶微软没有一个简单的方法来完成这个
任务。
谢谢。
Neil
Carol Wilson画廊的猫画作品
http：// www.carolwilsongallery.com
>您是否正在使用表单，并使用按过滤来过滤记录选择"或按表格过滤或工具按钮？
是，按选择过滤
如果是，请在表单中添加一个命令按钮。
编码它的点击事件：
DoCmd.OpenReport" ReportName"，acViewPreview ,, Me.Filter
我的报告名为Roster。我只是用名册代替吗？对于ReportName？我试图把这个陈述放在事件标签中，但是字符不会出现
。
过滤表格上的记录，然后点击按钮。
你知道我做错了吗？另外，怎么会有人知道使用这样的声明
？我很惊讶微软没有一个简单的方法来完成这个
任务。也许如果你可以在我这里使用向导按钮
并在我的表单中放置命令按钮来指导我，这可能更容易。
。
谢谢。
Neil
Carol Wilson画廊的猫画
http://www.carolwilsongallery.com
I already have a report designed under Reports. When I use filtering in Forms
or Tables, I see no way to select that filtered list when I am in Reports, and
there appears to be no way to do the filtering when I am in Reports.
I have received two replies to this message, posted a few days ago within
another Subject. One requires making programming type statements. That should
not be necessary -- Access must have a quick way to just click on something to
apply the filter to my already formatted report layout. The other reply said to
base the report on a query -- it appears to me I can only do that if I then
create a new report.
Thanks to anyone who can give me the simple instructions that must be in
Access, but sure are not in the Help menus.
Neil
Cat Paintings At Carol Wilson Gallery
http://www.carolwilsongallery.com
On 11 Nov 2004 19:52:27 GMT, Nhmiller wrote:
I already have a report designed under Reports. When I use filtering in Forms
or Tables, I see no way to select that filtered list when I am in Reports, and
there appears to be no way to do the filtering when I am in Reports.
I have received two replies to this message, posted a few days ago within
another Subject. One requires making programming type statements. That should
not be necessary -- Access must have a quick way to just click on something to
apply the filter to my already formatted report layout. The other reply said to
base the report on a query -- it appears to me I can only do that if I then
create a new report.
Thanks to anyone who can give me the simple instructions that must be in
Access, but sure are not in the Help menus.
Neil
Cat Paintings At Carol Wilson Gallery
http://www.carolwilsongallery.com
Are you using a form, and filtering the records using the "Filter by
Selection" or "Filter by Form" tool buttons?
If so, Add a command button to the form.
Code it''s Click event:
DoCmd.OpenReport "ReportName", acViewPreview , , Me.Filter
Filter the records on the form, then click the button.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
>Are you using a form, and filtering the records using the "Filter bySelection" or "Filter by Form" tool buttons?
Yes, Filter By Selection
If so, Add a command button to the form.
Code it''s Click event:
DoCmd.OpenReport "ReportName", acViewPreview , , Me.Filter
My report is called Roster. Do I just substitute "Roster" for "ReportName"? I
tried that and nothing happened after I continued as below:
Filter the records on the form, then click the button.
Do you know what I did wrong? Also, how would anyone know to use a statement
like that? I''m surprised Microsoft does not have an easy way to accomplish this
task.
Thanks.
Neil
Cat Paintings At Carol Wilson Gallery
http://www.carolwilsongallery.com
>Are you using a form, and filtering the records using the "Filter bySelection" or "Filter by Form" tool buttons?
Yes, Filter By Selection
If so, Add a command button to the form.
Code it''s Click event:
DoCmd.OpenReport "ReportName", acViewPreview , , Me.Filter
My report is called Roster. Do I just substitute "Roster" for "ReportName"? I
tried putting the statement in the Event Tab but the characters wouldn''t
appear.
Filter the records on the form, then click the button.
Do you know what I did wrong? Also, how would anyone know to use a statement
like that? I''m surprised Microsoft does not have an easy way to accomplish this
task. Perhaps if you could instruct me on this with me using the Wizard button
in conjunction with placing the Command button in my form, that might be
easier.
Thanks.
Neil
Cat Paintings At Carol Wilson Gallery
http://www.carolwilsongallery.com
这篇关于将过滤器应用于报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
