在过滤中选择字段的灵活性 [英] flexibility of selecting fields in filtering
问题描述
我需要创建一个过滤器表单，使用户可以灵活地选择表中的任何字段，并根据条件（例如范围）过滤记录。我已经阅读了一些关于多选列表框的内容，但它没有提供选择任何字段的灵活性。任何人都可以帮我解决这个问题并告诉我应该阅读哪些主题？非常感谢提前！
[我正在使用Access 2000（Window XP）和ODBC连接到MySQL服务器表]
< blockquote>您好
如果您使用Access，您尝试过按表单过滤技术。
我个人不喜欢它，因为用户可以过滤任何东西.....然后不理解结果，或者无法恢复正常形式，或者请求支持......
但是，如果智能地使用它可以过滤多个字段，我认为包括具有正确语法的范围，无需编码！
S7
嗨
如果你使用Access，你试过按表格过滤技术。
我个人不喜欢它，因为用户可以过滤任何东西.....然后不理解结果，或者无法恢复正常形式，或者请求支持......
但是，如果智能地使用它可以过滤多个字段，我认为包括具有正确语法的范围，无需编码！
S7
感谢您回复，Sierra7！
为了恢复正常形式，您尝试使用删除过滤器/排序？
无论如何，我会按照您的建议进行更多调查，并会回来。再次感谢！
感谢您的回复，Sierra7！
为了恢复正常形式，请你尝试使用删除过滤器/排序？
无论如何，我会按照您的建议进行更多调查，并会回来。再次感谢！
问题是我需要创建一个过滤器表单，用于在''WHERE'子句中使用用户输入的信息执行select查询。这就是我的意思''灵活性''。例如，
SELECT a，b，c，d，FROM mydb WHERE xx = yy
xx和yy将由a输入用户。有人可以帮我解决这个问题吗？谢谢！
Hi,
I need to create a filter form that gives a user flexibility in selection any fields in a table and in filtering records based on conditions, such as range. I''ve read some about a multi-select list box, but it does not give flexibility of choosing any fields. Can anybody help me on this and tell me what subject I should read? Many thanks in advance!
[I am using Access 2000 (Window XP) and ODBC connection to MySQL server table]解决方案Hi
If you are using Access have you tried the "Filter By Form" technique.
I personaly don''t like it because users can filter for anything..... then not understand the results, or not be able to revert to normal form, or call for support...
However, if used intelligently it allows you to filter on multiple fields, I think including ranges with the correct syntax, without coding!
S7
Hi
If you are using Access have you tried the "Filter By Form" technique.
I personaly don''t like it because users can filter for anything..... then not understand the results, or not be able to revert to normal form, or call for support...
However, if used intelligently it allows you to filter on multiple fields, I think including ranges with the correct syntax, without coding!
S7Thanks for you reply, Sierra7!
In order to revert to normal form have you tried to use "Remove Filter/Sort"?
Anyway, I will look into more as you suggested and will get back. Thanks again!
Thanks for you reply, Sierra7!
In order to revert to normal form have you tried to use "Remove Filter/Sort"?
Anyway, I will look into more as you suggested and will get back. Thanks again!The problem is that I need to create a filter form that executing the select query with information entered by a user in ''WHERE'' clause. That''s what I meant ''flexibility''. For example,
SELECT a, b, c, d, FROM mydb WHERE xx = yy
xx and yy will be entered by a user. Can anybody help on how I should approach? Thanks!
这篇关于在过滤中选择字段的灵活性的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
