Access 03 数据库中的组合框查询显示在某些电脑的有限数据上 [英] Combobox query in Access 03 database showing on some pc's limited data

问题描述

我有一个组合框，它查看一个表并通过查询显示它的 5 列数据，就像搜索一样使用，在大多数 PC 上，所有 5 列都填充了数据，但在某些情况下，只有最后 3 列填充并显示空白的名字和姓氏列，知道这是怎么发生的或如何解决的吗?

I have a combobox which looks at a table and displays it's 5 columns of data via a query to be used like a search, on most pc's all 5 columns populate with data but on some only the last 3 columns populate and it displays blank FirstName and Surname columns, any idea how this could happen or how to fix it?

此外，组合框也不是用来选择的，只是为了确认搜索到的人在数据库中，因此没有事件，所有这些都在组合框属性中设置.

Also the combobox isn't used to select just to confirm that searched for people are in the database so there are no events and it is all setup in the combobox properties.

编辑 - 我敢打赌，如果一个人可以获得 1 个以上的 em，那么像这样的帖子主题可能会堆积那些风滚草徽章.

Edit- I bet a post topic like this could stack up those tumbleweed badges if one could get more than 1 of em.

推荐答案

可能有两个原因.

一种可能性是查询中返回的行数与组合框的列数属性不同.如果您要更改组合框 Row Source 属性，请确保更新具有相同的列数.MS 修复了此错误，但我不确定何时修复.

One possibility is that the number of rows being returned in a query is not the same as the combo box Column Count property. If you are changing the combo box Row Source property make sure the updates have the same number of columns. MS fixed this bug but I'm not sure when it was fixed.

更有可能的是，有问题的 PC 没有安装以下修补程序.Access 2003 后 Service Pack 3 修补程序包的说明:2007 年 12 月 18 日

More likely though is that the PCs in question don't have the following hotfix installed. Description of the Access 2003 post-Service Pack 3 hotfix package: December 18, 2007

这篇关于Access 03 数据库中的组合框查询显示在某些电脑的有限数据上的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！