访问Web查询问题 [英] Access web-query problem
问题描述
我希望有人可以帮我解决以下问题。
我的目标是从组合框中选择一个值（确定），并将选择的值作为标准传递给网络查询。
当我输入标准框>>
= [Forms]！[formThatContainsTheCombobox]！[NameOfComboBox]<<
保存和关闭，这个东西工作正常。查询运行且报告准确。
如果我在我的sharepoint网站上发布了数据库并尝试访问它，它就无法运行。它说有关无效的表达参考。当然，如果我删除了这个表达式，数据库会在网络上正确显示，但当然查询会返回所有记录（而不是我在组合框中的选择过滤）。
我发誓，由于这个原因，我已经在我的电脑前面超过三天了，所以你可以知道信息的有用性。
< blockquote>我认为，您可以将所有表导出到SharePoint，然后将Access数据库表链接到SharePoint ，而不是创建Web应用程序（通过发布）。这样，您的访问数据库将像您的其他普通数据库一样工作，您的查询将开始正确响应。
通过创建Web应用程序（在sharepoint上），您无法在查询中提供表单的名称参考只是因为所有这些表格实际上都不在sharepoint网站上。
问候..
Sagar先生感谢您的回复。
所以，
1）我将不得不在非网络模式下重建我的数据库......正常的方式，对吧？
2）怎么做你的意思是将数据库表链接到sharepoint？
重点是我希望db的用户使用浏览器来填充表单..我的意思是在表单之前打开浏览器和表单或其他内容，弹出...这是可能的，只需导出表并链接它们吗？
我是否必须使用Sharepoint Designer来创建网站，或链接到表单的按钮??
你明白我有一些基本的东西我不知道，但相信我只是一条指令来自你，我会成功！ :)非常感谢
亲爱的乔治先生，
方法是你可以创建表并作为列表导出到sharepoint站点（这将是后端为您的数据库）。然后，您可以将表链接到Access数据库本身到sharepoint站点。现在，您可以在Access数据库中创建查询/表单/报表等所有内容（它将作为数据库的前端），并分发此前端。现在，您可以为用户分发此数据库的副本以供日常使用。
请注意，您需要拥有MS Access 2010 for this 。 （我对MS Access 2007不太确定）
这样用户可以充分发挥MS Access数据库的潜力。这样做的好处是，即使用户离线或网站链接中断（由于任何原因），用户仍然可以正常工作，并且只要链接正常，数据就可以同步。
你不需要sharepoint设计师。 （但如果你有它，你当然可以使用它）
希望我很清楚..
最好的问候
I wish someone could help me on the following.
My target is to choose a value from a combobox (ok with that) and pass that chosen value as a criteria to a web-query.
When I type to the criteria box>>
=[Forms]![formThatContainsTheCombobox]![NameOfComboBox]<<
and save and close, the thing works ok. The query runs and the report is accurate.
If I published the db on my sharepoint site and try to access it, its is not working. It says somehting about invalid reference to expression. Ofcourse if i removed this expression, the database is displayed properly on the web but of course the query returned all the records (and not filtered by my choise in the combobox).
I swear i been infront of my computer more than three days because of that, so you can tell how useful an information would be.
I think, instead of creating web application (by publishing), you can export all your tables to the SharePoint, and then link your Access Database tables to the SharePoint. This way, your access database will work just like your other normal database, and your query will start responding properly.
By creating web application (on sharepoint) you can not give name of forms in the query as a ref. simply because all those forms are actually not on the sharepoint site.
regards..
Mr Sagar thank you for replying.
So,
1)I will have to recreate my database in a non web-mode..the normal way, right??
2)how do you mean "link the database tables to the sharepoint"?
the point is that i want the users of the db to fill up the forms using the browser..i mean by just opening the browser and the form or something else before the form, pops up...is this possible, by just exporting the tables and linking them??
Do i have to use Sharepoint Designer to create the site, or the button that link to the form??
you understand that there are some basic things i am not aware of, but believe me just a piece of instructions from you and i will make it ! :) thank you very much
Dear Mr George,
The method is that you can create tables and exported to a sharepoint site as lists (This will be backend for your database). Then you can link the tables to the Access database itself to the sharepoint site. Now you can create everything like queries/forms/reports etc. in the Access Database (which will act as front end for your database), And distribute this frontend. Now you can distribute users the copy of this database for their routine use.
Please note that you need to have MS Access 2010 for this. (I am not quite sure for MS Access 2007)
This way user can have full potential of MS Access database. The beauty of this is that, even when the user is offline or if the site link is down (due to any reason) users can still work normally and the data can be synchronized whenever the link is up.
You don''t need sharepoint designer for this. (But if you have it you can o course use it)
Hope I am clear..
best regards
这篇关于访问Web查询问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
