问题描述
我正在使用Access 2007,我有两个列表框,用户可以在其中键入一系列日期。
然后我有一个列表框,以便用户可以选择他/她想要的提取信件或提案。
最后我有一个列表框,看看用户想要打开什么报告(收到日期文件,截止日期,文件被回复的日期)。
我希望用户能够在文本框中键入日期选择报告和文档类型,并使用这些选择的字段生成报告。
有人有这种情况的示例代码,我需要它。
提前谢谢。
I am using Access 2007 and I have two list boxes where the user is suppose to type a range of dates.
Then I have a list box so the user can select wheter he/she wants to pull letters or proposals.
Finally I have a list box to see what report the user wants to open (date document was received, deadline, date when the doc. was replied).
I want the user to be able to type the dates on the textboxes select a report and type of document and a report will be generated with those choosen fields.
Do someone has an example code for this situation, I need it badly.
Thanks in advance.
推荐答案
这只是你需要的东西。但这足以让您开始创建一个使用查询从表单中提取标准的报表。打开报告只是从您选择的事件中运行DoCmd.OpenReport。
This is only an inkling of what you need. But it''s enough to get you started on creating a report that uses a query that pulls its criteria from a form. Opening the report is a simple matter of running DoCmd.OpenReport from an event of your choosing.
这篇关于2个文本框和2个列表框的问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!