有条件的表格开放&报告过滤 [英] Conditional Form Opening & Report Filtering
问题描述
嘿兔子，
感谢您的帮助。我真的觉得这件事开始走到了一起。这是非常令人兴奋的。
还有一些我想要表格的东西，我不知道如何构建。如果你能给我一些帮助，我将不胜感激。
当我选择一个特定的员工类型时，我想要打开另一个子表单。我假设这将是事件选项卡下的内容，也许类似于点击？
我想要的另一件事就是设计一个构建一切的报告像预算一样。我认为这与[预算ID]有关。有没有办法只为特定预算的数据创建报告？这就是我的想象：打开表格，填写所有字段，为项目人员，供应品和设备填写。然后，您点击一个显示创建预算的cmd按钮，您的预算会显示为分为费用类别的报表，看起来非常类似于Excel工作表。你怎么想，这是可行的吗？
谢谢
续：计算字段返回不正确的结果
< blockquote class =post_quotes>
嘿兔子，
感谢您的帮助。我真的觉得这件事开始走到了一起。这是非常令人兴奋的。
还有一些我想要表格的东西，我不知道如何构建。如果你能给我一些帮助，我将不胜感激。
当我选择一个特定的员工类型时，我想要打开另一个子表单。我假设这将是事件选项卡下的内容，也许类似于点击？
我想要的另一件事就是设计一个构建一切的报告像预算一样。我认为这与[预算ID]有关。有没有办法只为特定预算的数据创建报告？这就是我的想象：打开表格，填写所有字段，为项目人员，供应品和设备填写。然后，您点击一个显示创建预算的cmd按钮，您的预算会显示为分为费用类别的报表，看起来非常类似于Excel工作表。你怎么看？这是可行的吗？
谢谢
报告问题是最简单的。您只需进行查询，以收集报告所需的信息。从查询中，您可以筛选特定预算。
然后根据查询进行报告，并根据需要设计它。
该按钮将打开此报告，该报告将根据输入到表单中的内容打开选择记录的查询。
至于第二个问题。这取决于每个员工类型的表单是否不同，在这种情况下，您将根据他们的选择使用选择案例的行来打开正确的表单。
你还必须决定你想怎么做。该列表是否在列表框或组合框或其他表示中。你想如何在他们做出选择时自动打开它，或者你是否希望他们先点击按钮。
你好兔子，
我想我理解你所收集的关于收集信息的查询的内容;此时我创造了大部分内容。我不太清楚我理解的是如何过滤特定预算。你能告诉我一点吗？此外，对于报告，我可以从多个查询中提取吗？现在我创建了多个查询，因为这似乎是创建条件的最简单方法。例如，我使用员工类型的标准来确定薪水，因为在一个类型中，薪水总是以相同的方式确定。
关于表格，我认为我想要它是自动的，但我想知道如果您选择这个特定员工类型的两个人会发生什么。称之为类型7，如果你选择了1,2,4,7,5,8,7会发生什么？这仅适用于7型员工。目前它是记录输入者为第一个字段选择的组合框。
谢谢。
报告问题最简单。您只需进行查询，以收集报告所需的信息。从查询中，您可以筛选特定预算。
然后根据查询进行报告，并根据需要设计它。
该按钮将打开此报告，该报告将根据输入到表单中的内容打开选择记录的查询。
至于第二个问题。这取决于每个员工类型的表单是否不同，在这种情况下，您将根据他们的选择使用选择案例的行来打开正确的表单。
你还必须决定你想怎么做。该列表是否在列表框或组合框或其他表示中。你想如何在他们做出选择后自动打开它，或者你希望他们先点击一个按钮。
Hey Rabbit,
Thanks for all of your help. I really feel like this thing is starting to come together. It''s very exciting.
There are still a few things that I would like the form to do that I don''t know how to structure. If you could give me some help, I would appreciate it.
When I select one specific employee type, I want that to open another subform. I''m assuming that this will be something under the event tab, maybe something like "on click"?
The other thing that I want is to design a report that structures everything like a budget. I assume that this would be tied to the [Budget ID]. Is there a way that I can create a report only for data from a specific budget? Here''s what I imagine: you open the form, fill in all the fields, for your project personnel, for your supplies, and for your equipment. Then you click a cmd button that says create budget, and your budget comes up as a report broken down into expense categories, and looks fairly similar to an excel sheet sans lines. What do you think, is this doable?
Thanks
Continued From: Calculated Field Returning Incorrect Results
Hey Rabbit,
Thanks for all of your help. I really feel like this thing is starting to come together. It''s very exciting.
There are still a few things that I would like the form to do that I don''t know how to structure. If you could give me some help, I would appreciate it.
When I select one specific employee type, I want that to open another subform. I''m assuming that this will be something under the event tab, maybe something like "on click"?
The other thing that I want is to design a report that structures everything like a budget. I assume that this would be tied to the [Budget ID]. Is there a way that I can create a report only for data from a specific budget? Here''s what I imagine: you open the form, fill in all the fields, for your project personnel, for your supplies, and for your equipment. Then you click a cmd button that says create budget, and your budget comes up as a report broken down into expense categories, and looks fairly similar to an excel sheet sans lines. What do you think, is this doable?
ThanksThe report question is the easiest. You just make a query that gathers the information you need for the report. From the query you can filter for a specific budget.
Then you make a report based on the query and design it how you want it to look.
The button will open this report which will open the query that selects records based on what was entered into the form.
As for the second question. It depends on if the form is different for each employee type, in which case you would use something along the lines of a select case to open the right form depending on their choice.
You also have to decide how you want to do this. Will the list be in a listbox or a combobox or some other representation. And how do you want to open it, automatically once they make a choice or do you want them to click a button first.
Hi Rabbit,
I think I understand what you are saying about the query that gathers information; I have created most of them at this point. What I''m not quite sure I understand is how I filter for a specific budget. Can you tell me a little more about that? Also, for the report, can I pull from more then one query? Right now I have created multiple queries, because that seemed the easiest way to create a criteria. For example, I used the criteria of employee type to determine salary because within a type, salary is always determined the same way.
With regards to the form, I think that I would want it to be automatic, but I wonder what would happen if you selected two people of this particular employee type. Call it type 7, if you selected 1,2,4,7,5,8,7 what would happen? This would only apply to type 7 employees. Currently it is a combo box that the record enterer selects for the first field.
Thanks.
The report question is the easiest. You just make a query that gathers the information you need for the report. From the query you can filter for a specific budget.
Then you make a report based on the query and design it how you want it to look.
The button will open this report which will open the query that selects records based on what was entered into the form.
As for the second question. It depends on if the form is different for each employee type, in which case you would use something along the lines of a select case to open the right form depending on their choice.
You also have to decide how you want to do this. Will the list be in a listbox or a combobox or some other representation. And how do you want to open it, automatically once they make a choice or do you want them to click a button first.
这篇关于有条件的表格开放&报告过滤的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
