自定义消息框 [英] customize message box
问题描述
大家好
我有一个查询,它给出了两个给定日期之间的数据。
现在,当我运行查询时它会给我一条消息框输入日期说输入参数值。我想以这样一种方式自定义消息框:它应该说输入日期。小心说输入参数值
这是可能的。我不太清楚如何解决这个问题。
请帮助
问候
Manoj
大家好
我有一个查询给了我两个给定日期之间的数据。
现在,当我运行查询时,它会给我一个消息框,输入日期输入参数值。我想以这样一种方式自定义消息框:它应该说输入日期。小心说输入参数值
这是可能的。我不太清楚如何解决这个问题。
请帮助
问候
Manoj
您可以使用InputBox()函数将自定义消息放在一起用于此目的。
如果您粘贴在SQL为您的查询,我们将看看我们是否可以为您提供正确的语法。
另一种选择是创建一个小表单以允许您的用户输入日期,然后用于启动查询的按钮。然后,查询将引用表单上的字段作为条件。
J
在查询的设计视图中(查询标准行上的网格,对于给定的字段输入
[输入第一个日期]
或者其他什么!这是运行查询时显示的内容。
Linq ; 0)>
< blockquote class =post_quotes>
您可以使用InputBox()函数将自定义消息放在一起用于此目的。
如果您粘贴查询的SQL ,我们将看看我们是否可以为您提供合适的语法。
另一种选择是创建一个小表单以允许用户输入日期,然后按一个按钮来启动查询。然后查询将引用表单上的字段作为标准。
J
您好JConsulting
我写了以下SQL语句
SELECT sales.Date,*
FROM sales
WHERE(((sales.Date)[sales]![date]![txtFrom]和[sales]![date]![txtTo]))
ORDER BY sales.Date ;
Hi All
I have a query which gives me the data between two given dates.
Now when i run the query it gives me a message box to enter the date saying "Enter Parameter Value". I want to customize the message box in such a way that it should say "Enter date" insted of saying "Enter Parameter Value"
Is this possible. I am not quite sure about this how to work this out.
Please help
Regards
Manoj
Hi All
I have a query which gives me the data between two given dates.
Now when i run the query it gives me a message box to enter the date saying "Enter Parameter Value". I want to customize the message box in such a way that it should say "Enter date" insted of saying "Enter Parameter Value"
Is this possible. I am not quite sure about this how to work this out.
Please help
Regards
ManojYou can use the InputBox() function to put a custom message together for this purpose.
if you paste in the SQL for your query, we''ll see if we can get the syntax right for you.
Another option would be to create a small form to allow your users to enter dates, then a button to launch the query. The query would then reference the fields on the form as criteria.
J
In Design View for the Query (the Query Grid) on the Criteria line, for the given field enter
[Enter First Date]
or whatever! That''s what will show when you run the Query.
Linq ;0)>
You can use the InputBox() function to put a custom message together for this purpose.
if you paste in the SQL for your query, we''ll see if we can get the syntax right for you.
Another option would be to create a small form to allow your users to enter dates, then a button to launch the query. The query would then reference the fields on the form as criteria.
J
Hi JConsulting
I have written the following SQL Statement
SELECT sales.Date, *
FROM sales
WHERE (((sales.Date) Between [sales]![date]![txtFrom] And [sales]![date]![txtTo]))
ORDER BY sales.Date;
这篇关于自定义消息框的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!