在表查找中看不到组合框值 [英] Can't see combobox values in table lookup
问题描述
我有一个包含字段的表，该字段使用组合框来填充值。表设计模式下的
查找选项卡如下：
显示控制组合框
行源类型表/查询
行源选择[员工关联] .LastName，[员工
链接] .FirstName，[员工关联] .EmployeeNumber FROM [Employee Linked];
绑定列3
列数3
列头是
列宽1" ;; 1" ;; 1"
列表行8
列表宽度3
限制列表是
当我自己运行该查询时我得到了结果。但是当我打开表格
并点击EmployeeID字段时，我可以看到下拉组合框和
列标题，但没有填充数据。造成这种情况的原因是什么？
谢谢
马克
I have a table with a field that uses a combobox to populate values. The
Lookup tab within table design mode is the following:
Display Control Combo Box
Row Source Type Table/Query
Row Source SELECT [Employee Linked].LastName, [Employee
Linked].FirstName, [Employee Linked].EmployeeNumber FROM [Employee Linked];
Bound Column 3
Column Count 3
Column Heads Yes
Column Widths 1";1";1"
List Rows 8
List Width 3"
Limit To List Yes
When I run that query on its own I get results. But when I open the table
and click on the EmployeeID field I can see the drop down combobox and the
column headings but no data being populated. What could be causing this?
Thanks
Mark
推荐答案
2008年7月15日星期二13:58:50 -0400，Mark写道：
On Tue, 15 Jul 2008 13:58:50 -0400, Mark wrote:
我有一个表格，其中的字段使用组合框来填充值。表设计模式下的
查找选项卡如下：
显示控制组合框
行源类型表/查询
行源选择[员工关联] .LastName，[员工
链接] .FirstName，[员工关联] .EmployeeNumber FROM [Employee Linked];
绑定列3
列数3
列头是
列宽1" ;; 1" ;; 1"
列表行8
列表宽度3
限制列表是
当我自己运行该查询时我得到了结果。但是当我打开表格
并点击EmployeeID字段时，我可以看到下拉组合框和
列标题，但没有填充数据。造成这种情况的原因是什么？
谢谢
马克
I have a table with a field that uses a combobox to populate values. The
Lookup tab within table design mode is the following:
Display Control Combo Box
Row Source Type Table/Query
Row Source SELECT [Employee Linked].LastName, [Employee
Linked].FirstName, [Employee Linked].EmployeeNumber FROM [Employee Linked];
Bound Column 3
Column Count 3
Column Heads Yes
Column Widths 1";1";1"
List Rows 8
List Width 3"
Limit To List Yes
When I run that query on its own I get results. But when I open the table
and click on the EmployeeID field I can see the drop down combobox and the
column headings but no data being populated. What could be causing this?
Thanks
Mark
总是包括您的Access和Windows版本号。它可能会产生一个
的差异。
您是否使用安装了Service Pack 3的Access 2003？
有一个错误。
见...
http：// support.microsoft.com/kb/945674
-
Fred
请回复此新闻组。
我不回复个人电子邮件
Always include your Access and Windows Version numbers. It may make a
difference.
Are you using Access 2003 with Service Pack 3 installed?
There is a bug.
see...
http://support.microsoft.com/kb/945674
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Mark写道：
Mark wrote:
我有包含字段的表，该字段使用组合框来填充值。表设计模式下的
查找选项卡如下：
显示控制组合框
行源类型表/查询
行源选择[员工关联] .LastName，[员工
链接] .FirstName，[员工关联] .EmployeeNumber FROM [Employee Linked];
绑定列3
列数3
列头是
列宽1" ;; 1" ;; 1"
列表行8
列表宽度3
限制列表是
当我自己运行该查询时我得到了结果。但是当我打开表格
并点击EmployeeID字段时，我可以看到下拉组合框和
列标题，但没有填充数据。造成这种情况的原因是什么？
谢谢
马克
I have a table with a field that uses a combobox to populate values. The
Lookup tab within table design mode is the following:
Display Control Combo Box
Row Source Type Table/Query
Row Source SELECT [Employee Linked].LastName, [Employee
Linked].FirstName, [Employee Linked].EmployeeNumber FROM [Employee Linked];
Bound Column 3
Column Count 3
Column Heads Yes
Column Widths 1";1";1"
List Rows 8
List Width 3"
Limit To List Yes
When I run that query on its own I get results. But when I open the table
and click on the EmployeeID field I can see the drop down combobox and the
column headings but no data being populated. What could be causing this?
Thanks
Mark
您是否考虑过使用表格？如果您需要直接编辑
而不是基于规则的数据输入，请创建一个链接到
数据表的查询。摆脱查找。
Have you considered using a form instead? If you need direct editing
and not rules based data entry, create a query instead that links to the
data table. Get rid of the lookup.
我同意弗雷德;这听起来像可怕的SP3
bug怪物的另一种表现形式。按照他的链接到这个修补程序并安装它。
-
总是有不止一种方法给猫皮肤！
基于Access 2000/2003的答案/帖子
通过AccessMonster.com发布消息
http://www.accessmonster.com/Uwe/For...ccess/200807 / 1
I agree with Fred; this sounds like another manifestation of the dreaded SP3
bug monster. Follow his link to the hotfix and install it.
--
There''s ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000/2003
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200807/1
这篇关于在表查找中看不到组合框值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
