可编辑的表格 [英] Editable forms

问题描述

我有一个基于和SQL查询的表单，我希望我能够更新表单中的一些细节，主要是DB中每个条目的注释文本框。我将属性设置为允许编辑，但它无法帮助我只是不能在文本框中键入任何内容。我想知道这是否与SQL有关，因为我自己没有写那个部分，我不知道一点一点地做什么


这里是SQL

I have a form that is based on and SQL query, i was hoping that i would be able to update some of the details in the form, mainly a comments text box for each entry in the DB. I have the properties set to allow edits, but it is not helping i just cant type anything into the textbox. I am wondering if this has something to do with the SQL as i did not write that part myself, im not sure what the group by bit does

here is the SQL

展开 | 选择 | Wrap | 行号

推荐答案

嗨。 Group By查询不可更新我很遗憾地说。此类查询通常用于提供高于所涉及的各行的级别的总计等，因此如果您希望用户修改或添加条目，则无法保留分组。


查看查询它似乎没有进行任何聚合，因此根本没有必要使用GROUP BY子句。在设计视图中打开查询并取消选中View，Totals，以新名称保存它（以便不为了测试目的覆盖原始文件）然后运行查询并尝试修改条目。如果一切正常，您可以在原始查询中关闭View，Totals，然后您的表单可以为您的用户更新。


-Stewart

Hi. Group By queries are not updatable I''m sorry to say. Such queries are generally used to provide totals etc at a level above that of the individual rows involved, so as it stands you can''t keep the grouping if you want users to modify or add entries.

Looking at the query it does not appear to be doing any aggregation, so it may not be necessary to have the GROUP BY clauses at all. Open the query in design view and untick View, Totals, save it under a new name (so as not to overwrite the original for test purposes) then run the query and try modifying an entry. If all is ok you can just take the View, Totals off on the original query and your form should then be updatable for your users.

-Stewart

谢谢你，我不知道是什么组和有线，但我把它们拿出来，查询一切正常，我可以编辑表格中的字段

thanks for that im not sure what the group by and having lines did but i took them out and the querys all work fine and i can edit fields in the form

他们改变了查询从一个可编辑的一个到一个不是： - >


这些东西通常是从开发中遗留下来的，或者是从具有类似要求的其他地方开始的。显然这不够相似;）


斯图尔特的好地方虽然：）

They changed the query from an editable one to one which wasn''t :->

These things are usually left over from development or they have been nicked from somewhere else with similar requirements. Clearly this wasn''t similar enough ;)

Nice spot by Stewart though:)

这篇关于可编辑的表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！