子窗体中的空白记录 [英] Blank record in subform

问题描述

大家好，


我无法在每次输入数据和关闭表单时向子表单添加空白记录访问权限

（表单和

子表单基于一个表格）


将数据输入子表单时，我得到铅笔图标以显示数据

另外，但在记录下面我输入的数据记录是

空白，带有星号（*）图标，这是记录（空白）总是得到

保存了所有实际拥有数据的记录。


我知道必须有一些我可以忽略的简单，但

的生命周期我无法解决这个问题。


提前感谢所有天才。


Joe

Hi all,

I am having trouble with access adding a blank record to a subform
everytime I finish entering data and closing the form. (The form and
subform are based on the one table)

When entering data into the subform I get the pencil icon to show data
addition, but underneath the record I am inputting data the record is
blank with a star(*)icon and this is the record(blank)that always gets
saved with all the records that actually have data.

I know that there must be something simple that I am overlooking, but
for the life of me cannot work it out.

Thanking all you geniuses out there in advance.

Joe

推荐答案

如果新记录可以添加
，您的表单将始终具有新记录行（星形图标）。单独存在这一行不会产生空白记录。

必须有一些东西弄脏新记录才会写入另外一张记录到你的桌子上。例如，在

表格的当前事件中是否有代码？


在设计视图中打开您的表格，并选择一个您可以标记的字段

必需（下部窗格）。这将至少阻止Access进入一个完全

的空行，并可以帮助您确定问题发生的位置。


-

Allen Browne - 微软MVP。西澳大利亚州珀斯。

访问用户提示 - http：// allenbrowne.com/tips.html

回复群组，而不是mvps dot org的allenbrowne。


" Joe Scully" <已经*** @ whoever.com>在消息中写道

news：11 ************************** @ posting.google.c om ...

Your form will always have the new record row (star icon) if new records can
be added. The presence of this line alone will not generate blank records.
There must be something that is dirtying the new record before it will write
another record to your table. Is there code in the Current event of the
form, for example?

Open your table in design view, and choose a field that you could mark
Required (lower pane). This will at least stop Access entering a completely
blank row, and may help you identify where the problem is occurring.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Joe Scully" <ve***@whoever.com> wrote in message
news:11**************************@posting.google.c om...

每次输入数据并关闭表单时，我都无法在子表单中添加空白记录。 （表单和
子表单基于一个表格）

当将数据输入子表单时，我得到铅笔图标以显示数据
另外，但在记录下面我是输入数据记录是空白的，带有星号（*）图标，这是记录（空白）总是与所有实际拥有数据的记录一起保存。

我知道我必须有一些简单的东西可以忽略，但是对于我的生活来说无法解决这个问题。

提前感谢你们所有的天才。

Joe

I am having trouble with access adding a blank record to a subform
everytime I finish entering data and closing the form. (The form and
subform are based on the one table)

When entering data into the subform I get the pencil icon to show data
addition, but underneath the record I am inputting data the record is
blank with a star(*)icon and this is the record(blank)that always gets
saved with all the records that actually have data.

I know that there must be something simple that I am overlooking, but
for the life of me cannot work it out.

Thanking all you geniuses out there in advance.

Joe

" Allen Browne" <铝********* @ SeeSig.Invalid>在消息新闻中写道：< 3f ********************** @ freenews.iinet.net。 au> ...

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message news:<3f**********************@freenews.iinet.net. au>...

如果可以添加新记录，您的表单将始终具有新记录行（星形图标）。单独存在这一行不会产生空白记录。
必须有一些东西弄脏新记录才会将另一条记录写入你的桌面。例如，在
表单的Current事件中是否有代码？

在设计视图中打开表格，并选择一个可以标记的字段
必需（下方窗格） 。这将至少阻止Access进入一个完全空白的行，并可以帮助您确定问题发生的位置。

-
Allen Browne - Microsoft MVP。西澳大利亚州珀斯。
访问用户提示 - http://allenbrowne.com/ tips.html
回复群组，而不是alvbrowne在mvps dot org。

Your form will always have the new record row (star icon) if new records can
be added. The presence of this line alone will not generate blank records.
There must be something that is dirtying the new record before it will write
another record to your table. Is there code in the Current event of the
form, for example?

Open your table in design view, and choose a field that you could mark
Required (lower pane). This will at least stop Access entering a completely
blank row, and may help you identify where the problem is occurring.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

不，当前事件中没有代码表单，我刚刚基于一个表构建了一个

简单的表单/子表单。


我尝试了你的建议并逐个将每个字段更改为

需要并重试表格但无效，表格一直保存

空白记录，直到我遇到一个字段给我一个消息

box"该字段不能包含空值，因为此字段所需的

属性设置为True。在此字段中输入一个值。


当我尝试输入一个值时，消息框会一直弹出。

我已经完成了丢失。

No, there is no code in the Current event of the form, I just built a
straightforward Form/Subform based on a single table.

I tried what you suggested and one by one changed each field to
required and retried the form but to no avail, the form kept on saving
blank records, until I came across one field the gives me a message
box "The field cannot contain a null value because the required
property of this field is set to True. Enter a value in this field.

When I try to enter a value the message box just keeps on popping up.
I''m at a complete loss.

表单的RecordSource属性是什么？

它是表的名称还是查询？


如果是查询，查询中有多少个表？你可以把它改成

表（暂时）吗？


当必填字段是
$时，访问权限不能保存记录b $ b null。


-

Allen Browne - 微软MVP。西澳大利亚州珀斯。

访问用户提示 - http：// allenbrowne.com/tips.html

回复群组，而不是mvps dot org的allenbrowne。


" Joe Scully" <已经*** @ whoever.com>在消息中写道

news：11 ************************** @ posting.google.c om ...

What is in the RecordSource property of your form?
Is it the name of a table, or a query?

If it''s a query, how many tables are in the query? Could you change it to a
table (temporarily)?

Access should not be able to save the records while the Required fields are
null.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Joe Scully" <ve***@whoever.com> wrote in message
news:11**************************@posting.google.c om...

" Allen Browne" <铝********* @ SeeSig.Invalid>在消息中写道

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message

news：< 3f ********************** @ freenews.iinet.net。 au> ...

news:<3f**********************@freenews.iinet.net. au>...

如果可以添加新记录
，您的表单将始终具有新记录行（星形图标）。单独存在这一行不会产生空白的
记录。在
将另一条记录写入你的桌子之前，必须有一些东西弄脏了新记录。例如，在
表单的Current事件中是否有代码？

在设计视图中打开表格，并选择一个可以标记的字段
必需（下方窗格） 。这至少会阻止Access输入
完全空行，并可以帮助您确定问题发生的位置。

-
Allen Browne - Microsoft MVP。西澳大利亚州珀斯。
访问用户提示 - http://allenbrowne.com/ tips.html
回复群组，而不是mvps dot org的allenbrowne。

Your form will always have the new record row (star icon) if new records can be added. The presence of this line alone will not generate blank records. There must be something that is dirtying the new record before it will write another record to your table. Is there code in the Current event of the
form, for example?

Open your table in design view, and choose a field that you could mark
Required (lower pane). This will at least stop Access entering a completely blank row, and may help you identify where the problem is occurring.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

不，表格的当前事件中没有代码，我刚刚建立了一个基于单个表格的简单表格/子表格。

我尝试了你的建议并逐个改变每个字段
要求并重试表格但是没有有效，表格一直保存空白记录，直到我遇到一个字段给我一个消息
框该字段不能包含空值，因为该字段所需的属性设置为True。在此字段中输入一个值。

当我尝试输入一个值时，消息框会一直弹出。

我完全失去了。

No, there is no code in the Current event of the form, I just built a
straightforward Form/Subform based on a single table.

I tried what you suggested and one by one changed each field to
required and retried the form but to no avail, the form kept on saving
blank records, until I came across one field the gives me a message
box "The field cannot contain a null value because the required
property of this field is set to True. Enter a value in this field.

When I try to enter a value the message box just keeps on popping up.
I''m at a complete loss.

这篇关于子窗体中的空白记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！