这是一个错误吗？ （2） [英] Is this a bug? (2)
问题描述
这是一个转贴，我希望有一个更好的解释：
1.创建3个表，所有2个字段：
表1：字段IDnr（自动编号，密钥）和字段测试1（Alpha50）
表2：字段IDnr（数字，密钥）和字段测试2（Alpha50）
表3：字段IDnr（数字，键）和Field Test3（Alpha50）
2.在IDnr的关系窗口链接中：表2到表1（1x1）和表3
到表1（1x1）。
3.通过向导创建表单并选择这3个表中的所有字段以
显示在表单中。
4.运行表格并输入X。进入现场测试1
5.选项卡到现场测试2并再次输入X
6.再次按PageUp和PageDown
7.现在输入X进入现场测试3
8.将光标移动到字段Test1
9.您将看到表3的IDnr字段已获得正确的ID
数。
10.但是，表2的IDnr字段（之前得到了正确的ID
数字）是b $ b突然设置为零。奇怪的是，与主记录的链接仍然很明显，但是当你继续输入其他记录时，它会给出关键和双值错误。
如果我跳过第6步，这不会发生。
这怎么可能，更重要的是，我怎样才能防止这种令人讨厌的事情>
来自
的行为？访问2000和2002.
谢谢，
john
This is a repost, I hope with a better explanation:
1. Create 3 tables, all with 2 fields:
Table 1: Field IDnr (Autonumber,key) and Field Test1 (Alpha50)
Table 2: Field IDnr (Number,key) and Field Test2 (Alpha50)
Table 3: Field IDnr (Number,key) and Field Test3 (Alpha50)
2. In the relation window link on IDnr: table 2 to table 1 (1x1) and table 3
to table 1 (1x1).
3. Create a form via the Wizard and select all fields of those 3 tables to
show up in the form.
4. Run the form and enter "X" into field Test1
5. Tab to field Test2 and again enter "X"
6. Press PageUp and PageDown again
7. Now enter "X" into field Test3
8. Move the cursor to field Test1
9. You will see that the IDnr field of table 3 has gotten the right ID
number.
10. However, the IDnr field of table 2 (which previously got the right ID
number) is
suddenly set to zero. Strangely enough the link with the master record is
still in tact, but it will give ''key and double value'' errors later when you
proceed entering other records.
If I skip step 6, this doesn''t happen.
How is this possible and more importantly, how can I prevent this nasty
behavior from
happening? Access 2000 and 2002.
Thanks,
john
推荐答案
可能，如果你发布了在某个地方，一个包含（仅）表格的数据库
和表格，更多的人会检查你描述的内容和评论。如果
您无处可做，请将扩展名重命名为dat。或某事
其他无害，给我发电子邮件（我假设它很小）我会发给你
它给你它可以通过点击下载。
我跟进你说的这些问题是：
这里报告的99.44％的错误都不是错误;他们是
海报的错误。
这里所有海报的90％与他们的主题不在一起;他们忘了
或者忽略了提到他们正在做其他的事情
奇异的，在一些不寻常的环境中运行，比如说jdbc，或者说他们是b
一个不完全像他们想要描述的真实情况的例子。
我不太可能参与你的问题
描述，即显示在一个表单上链接1-1的三个表。 （我认为
就是这样）。
你可能是例外，你可能会提出有效的
点。但我不值得花时间制作三张桌子和形式
来查找。但下载？也许吧。
当然，我现在可能已经浪费了很多时间来写这篇文章，因为我会按照你的指示跟进你的b $ b。哦，好吧，这是07:21这里和
咖啡还不够。
Possibly, if you posted somewhere, a db containing (just) the tables
and form, more people would examine what you describe and comment. If
you have nowhere to do this, rename the extension to "dat" or something
else innocuous, e-mail it to me (I''m assuming it''s small) and I''ll post
it for you so that it can be downloaded with a click.
My problems in following up what you say are these:
99.44%of all bugs reported here are not bugs; they are errors by the
poster.
90% of all posters here aren''t up front with their subject; they forget
or deliberatly neglect to mention they are doing something else
bizarre, operating in some unusual environment, say jdbc, or they
present an example which is not exactly like the real situation they
want to describe.
It''s unlikely that I will ever be involved with the problem you
describe, viz showing three tables linked 1-1 on one form. (I think
that''s it).
You may be the exception of course, and you may be raising a valid
point. But it''s not worth my time to make the three tables and the form
to find out. But a download? Maybe.
Of course, I''ve probably wasted as much time now in writing this as I
would have followng up your instructions. Oh well, it''s 07:21 here and
not enough coffee yet.
John给我发了这个文件它可以在
http：// www下载.ffdba.com / downloads / lose id.dat
http://www.ffdba.com/downloads/losingid.dat
我希望我在复制过程中没有搞砸了。
虽然没有必要，但可能希望将文件扩展名重命名为
mdb。
John has sent me this file and it is available for download at
http://www.ffdba.com/downloads/losing id.dat
or
http://www.ffdba.com/downloads/losingid.dat
I hope I haven''t screwed it up in the process of copying.
While it''s not necessary, one may wish to rename the file extension to
mdb.
谢谢。我已经发送了mdb（dat）给你。
Thanks. I''ve send the mdb (dat) to you.
我不太可能参与你的问题
描述，即显示在一个表单上链接1-1的三个表。 （我认为
就是这样）。
It''s unlikely that I will ever be involved with the problem you
describe, viz showing three tables linked 1-1 on one form. (I think
that''s it).
在Re：这是一个错误吗？中查看我对David W. Fenton的回答。
john
" Lyle Fairfield" < ly *********** @ aim.comschreef在bericht
新闻：11 ******************* **@m73g2000cwd.googlegro ups.com ...
See my answer to David W. Fenton in "Re: Is this a bug?".
john
"Lyle Fairfield" <ly***********@aim.comschreef in bericht
news:11*********************@m73g2000cwd.googlegro ups.com...
可能，如果你发布了某个地方，一个包含（只）表格的数据库
和形式，更多的人会检查你描述和评论的内容。如果
您无处可做，请将扩展名重命名为dat。或某事
其他无害，给我发电子邮件（我假设它很小）我会发给你
它给你它可以通过点击下载。
我跟进你说的这些问题是：
这里报告的99.44％的错误都不是错误;他们是
海报的错误。
这里所有海报的90％与他们的主题不在一起;他们忘了
或者忽略了提到他们正在做其他的事情
奇异的，在一些不寻常的环境中运行，比如说jdbc，或者说他们是b
一个不完全像他们想要描述的真实情况的例子。
我不太可能参与你的问题
描述，即显示在一个表单上链接1-1的三个表。 （我认为
就是这样）。
你可能是例外，你可能会提出有效的
点。但我不值得花时间制作三张桌子和形式
来查找。但下载？也许吧。
当然，我现在可能已经浪费了很多时间来写这篇文章，因为我会按照你的指示跟进你的b $ b。哦，好吧，现在是07:21而且还没有足够的咖啡。
Possibly, if you posted somewhere, a db containing (just) the tables
and form, more people would examine what you describe and comment. If
you have nowhere to do this, rename the extension to "dat" or something
else innocuous, e-mail it to me (I''m assuming it''s small) and I''ll post
it for you so that it can be downloaded with a click.
My problems in following up what you say are these:
99.44%of all bugs reported here are not bugs; they are errors by the
poster.
90% of all posters here aren''t up front with their subject; they forget
or deliberatly neglect to mention they are doing something else
bizarre, operating in some unusual environment, say jdbc, or they
present an example which is not exactly like the real situation they
want to describe.
It''s unlikely that I will ever be involved with the problem you
describe, viz showing three tables linked 1-1 on one form. (I think
that''s it).
You may be the exception of course, and you may be raising a valid
point. But it''s not worth my time to make the three tables and the form
to find out. But a download? Maybe.
Of course, I''ve probably wasted as much time now in writing this as I
would have followng up your instructions. Oh well, it''s 07:21 here and
not enough coffee yet.
这篇关于这是一个错误吗？ （2）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
