2个文本框和2个列表框的问题 [英] problem with 2 text boxes and 2 list boxes
问题描述
我正在使用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.
推荐答案
Form1
txtStartDate
txtEndDate
Query1
Form1
txtStartDate
txtEndDate
Query1
谢谢你先生;
但是我不太熟悉sql代码，那是我需要的所有代码吗？这与第一部分有什么关系？我只需要声明第一部分的文本框吗？
再次感谢
Thank you Sir;
However I am not too familiarize with sql code, is that all the code that I need? and how is that related with the first part. Do I only need to declare the text boxes for the first part?
Thanks again
这只是你需要的东西。但这足以让您开始创建一个使用查询从表单中提取标准的报表。打开报告只是从您选择的事件中运行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个列表框的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
