报告设计问题：Access 2007 [英] Problem with Report Design: Access 2007
问题描述
我或Access都疯了！我有一个名为MAILING_TABLE的表格。从代码中填充以创建名称和地址的邮件列表。代码工作正常，运行后表包含它应该包含的内容。此表与数据库中的任何其他表无关。 （即，我没有在关系窗口中创建关系。）
当我尝试在此表上创建报表时，例如尝试添加字段FamilyName在报告中，我进入一个奇怪的对话，询问我如何联系 FamilyName到CONTACTS中相同名称的字段。表。答案是，在这一点上，我不想...但这不是一个选择。如果我只是将字段的名称更改为，例如，FamName一切都会变好。但是，你什么时候不能在多个表中使用相同的字段名称？ （不，FamilyName甚至不是数据库中任何表的关键！）它似乎也是随意的...它没有问我关于字段Address1，它出现在另外两个表中......有时问我一下表的备份副本中的字段，而根本不询问原始表。我很难过！
我注意到报告向导似乎没有这个问题，但我根本不喜欢使用它：它有远自己的想法太多了！
（幸运的是，我还没有代码可以告诉你[还是！]，因为我不记得开始和结束代码标签对于这个网站，我找不到最初告诉我如何在我的问题中指出代码的开始和结束的网站区域。你能提醒我还是告诉我如何找到它，请？）
Either I or Access is mad! I have a table called "MAILING_TABLE" which is filled from code to create a mailing list of names and addresses. The code works fine, and after it runs the table contains exactly what it should. This table is not related to any other table in the database. (I.e., I haven''t created a relationship in the ''Relationships'' window.)
When I try to base a report on this table, and try, for instance to add the field "FamilyName" to the report, I get into a strange dialogue asking me how I want to "relate" FamilyName to the field of the same name in the "CONTACTS" table. The answer is, at this point, I DON''T want to ... but that is not an option. If I simply change the name of the field to, eg., FamName all becomes well. But since when could you not use the same field name in more than one table? (No, FamilyName is not even the key to any table in the database!) It also seems arbitrary ... It doesn''t ask me about the field Address1, which appears in two other tables ... and sometimes asks me about a field in a back up copy of a table without asking about the original at all. I''m stumped!!
I note that the Report Wizard doesn''t seem to have this problem, but I don''t like using it at all: it has far too many ideas of its own!
(Luckily there''s no code I need to show you [yet!], because I can''t remember the start and end code tags for this website and I can''t find the area of the site that originally told me about how to indicate start and end of code in my questions. Can you remind me or tell me how to find it, please?)
推荐答案
奇怪的行为......我以前从未见过这种情况。我想知道它是否与当前数据库选项下的自动更正选项（我总是关闭）有关。只是一个疯狂的猜测。
就发布代码而言，如果你使用高级编辑器，那么有一个'''''按钮用于插入CODE标签。
Strange behavior.. I''ve never seen that happen before. I wonder if it has anything to do with the AutoCorrect Options (which I always turn off), under the Current Database options. Just a wild guess though.
As far as posting code, if you use the Advanced editor there''s a ''#'' button for inserting the CODE tags.
查看表单的Record Source属性中的内容。同时查看分组选项，确保你没有任何东西。
Check out what is in the Record Source property of the form. Also looking in the grouping options and make sure you haven''t anything in there.
（幸运的是，没有代码我需要告诉你[还是！]，因为我不记得这个网站的开始和结束代码标签，我找不到最初告诉我如何指示代码开始和结束的网站区域在我的问题中。你能提醒我或告诉我如何找到它吗？）
(Luckily there''s no code I need to show you [yet!], because I can''t remember the start and end code tags for this website and I can''t find the area of the site that originally told me about how to indicate start and end of code in my questions. Can you remind me or tell me how to find it, please?)
在这里查看......
如何提问
这篇关于报告设计问题：Access 2007的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
