我无法更新子表单中的信息 [英] I Can't Update Info in my subforms
问题描述
我是论坛的新手，我正在设计一个数据库，我的同事可以使用这个数据库来预订我们的课程。
我有一个表格设置有两个子表格。主要形式是具有课程细节的形式，然后我有一个子表单，其中包含全年的个人日期。我还有一个子表格，显示谁在我适用的课程和日期预订到每个日期。
不幸的是我似乎无法向任何一个添加新记录我只能更改当前记录的详细信息。然而，我可以在主表单中添加新记录。
我哪里错了？
我很感激你能给我的任何帮助。
Nikki
< blockquote> Nikki有很多种可能性。
首先是基于查询的子表单。如果是这样，请尝试在表单外运行这些查询。如果你不能在最后添加一个记录，那么查询是不可更新的。
如果是你的查询的sql发布的情况，我们将看看它们。
如果没有，请告诉我，我们会尝试别的。
玛丽
您好，我是论坛的新手，我目前正在设计一个数据库，我的同事可以使用这个数据库来预订我们的课程。
我有一个表格设置有两个子表格。主要形式是具有课程细节的形式，然后我有一个子表单，其中包含全年的个人日期。我还有一个子表格，显示谁在我适用的课程和日期预订到每个日期。
不幸的是我似乎无法向任何一个添加新记录我只能更改当前记录的详细信息。然而，我可以在主表单中添加新记录。
我哪里错了？
我很感激你能给我的任何帮助。
Nikki
子表单基于查询。我试图更新表单，查询的第一部分可以更新，但是当我再次进入第一个子表单时，它不会让我更新。
这样做帮助识别问题？
Nikki有很多种可能性。
首先是你的子表格基于查询。如果是这样，请尝试在表单外运行这些查询。如果你不能在最后添加一个记录，那么查询是不可更新的。
如果是你的查询的sql发布的情况，我们将看看它们。
如果没有，请告诉我，我们会尝试别的。
Mary
子表单基于查询。我试图更新表单，查询的第一部分可以更新，但是当我再次进入第一个子表单时，它不会让我更新。
这样做帮助识别问题？
不是真的Nikki。
目前我想忘记表格，看看是否有问题与查询。唯一的方法是在查询窗口中运行查询，看看是否可以在其末尾添加完整记录并保存。您可以随时删除该记录。
我担心的是问题在于查询而不是子表单。
Mary
Hi, I''m new to the forum and I am currently designing a database that my colleagues can use to book people onto our courses.
I have a form set up with two subforms. The main form is one that has the course details, I then have a subform with the individual dates throughout the year. I also have a further subform that shows who has booked onto each date when I am on the course and date applicable.
Unfortunately I do not seem to be able to add new records to either of the subforms I can only change details of current records. I can however add new records to the main form.
Where am I going wrong??
I would appreciate any help you can give me.
Nikki
There are a number of possibilities Nikki.
Firstly are your subforms based on queries. If so try running those queries outside the forms. If you cannot add a record at the end then the query is not updateable.
If this is the case post the sql for your queries and we''ll take a look at them.
If not, let me know and we''ll try something else.
Mary
Hi, I''m new to the forum and I am currently designing a database that my colleagues can use to book people onto our courses.
I have a form set up with two subforms. The main form is one that has the course details, I then have a subform with the individual dates throughout the year. I also have a further subform that shows who has booked onto each date when I am on the course and date applicable.
Unfortunately I do not seem to be able to add new records to either of the subforms I can only change details of current records. I can however add new records to the main form.
Where am I going wrong??
I would appreciate any help you can give me.
Nikki
The subforms are based on a query. I tried to update the form and the first part of the query could be updated but then when I got to what would be the first subform again it would not let me update.
Does that help with identifying the problem?
There are a number of possibilities Nikki.
Firstly are your subforms based on queries. If so try running those queries outside the forms. If you cannot add a record at the end then the query is not updateable.
If this is the case post the sql for your queries and we''ll take a look at them.
If not, let me know and we''ll try something else.
Mary
The subforms are based on a query. I tried to update the form and the first part of the query could be updated but then when I got to what would be the first subform again it would not let me update.
Does that help with identifying the problem?Not really Nikki.
For the moment I want to forget about the form and see if there is a problem just with the query. The only way to do that is to run the query in the query window and see if you can add a complete record to the end of it and save it. You can always delete the record later.
What I''m worried about is that the problem is with the query and not the subform.
Mary
这篇关于我无法更新子表单中的信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
