组合输入按钮的周长值 [英] Combining Enter Perimeter Values for a Button

问题描述

我在表单中有一个按钮，在用户按下它后会运行四个查询。其中两个查询要求输入开始日期，以便它可以查找特定记录。两个quieres所需的开始日期将始终相同，但是要使查询正确搜索记录，必须输入开始状态;因此，当用户按下按钮时，用户得到2个连续的提示。有没有办法结合两个提示，所以用户不必连续两次输入相同的东西？在此先感谢。

I have a button in a form which runs four queries after a user presses it. Two of the queries ask for a start date to be entered so that it can look up specific records. The start dates required for both quieres will always be the same, but for the queries to correctly search the records, the start state must be entered; thus the user gets 2 consective prompts when he or she presses the button. Is there a way to combine the two prompts so the user doesn''t have to enter the same thing twice in a row? Thanks in advance.

推荐答案

让用户在表单上输入开始日期并完全取消提示。在查询中，将[StartDate]字段的条件设置为：

Have the User enter the Start Date on the Form and eliminate the Prompts altogether. In the Queries, set the Criteria of the [StartDate] Field to:

展开 | 选择 | Wrap | 行号

这听起来不错。我在表单上有很多其他按钮，我不想通过放入可以直接输入文本的框来更改它的界面完整性。有没有办法以任何其他方式组合2个搜索提示？

That sounds like a good idea. I have a lot of other buttons on the form and I don''t want to change the interface integrity of it by putting in boxes where you can directly enter text into. Is there a way to combine the 2 search prompts any other way?

史蒂夫，

Steve,

1. 它是可能。不建议这样做，但可以使用 InputBox（）。
2. 最友好的选项当然是使用表格，即使你必须专门打开一个表格。使用 InputBox（）时，必须修改使用的SQL。这可能涉及创建临时QueryDef以运行查询。凌乱！
3. 我注意到你使用的是另一个新的用户名。虽然只需联系管理员寻求帮助解决您的问题，这是可以接受的，但我们不允许用户在正常的活动过程中运行多个帐户。
   
   
   请告诉我任何困难你可能有，我们会看到可以做些什么来让你回到正确的帐户。

1. It is possible. It is not recommended, but it is possible using InputBox().
2. The most user friendly option is certainly to use a form, even if you have to open a new one specially. When using InputBox() it is necessary to modify the SQL used. This can involve creating temporary QueryDefs just to run the query. Messy!
3. I notice you are using a different and new user name. While this is acceptable simply to contact an administrator to ask for help resolving your issue, we do not allow users to run multiple accounts in the normal course of events.
   
   Please PM me any difficulties you may have and we''ll see what can be done to get you back using your proper account.

-NeoPa（管理员）。

-NeoPa (Admin).

这篇关于组合输入按钮的周长值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！