本文介绍了从155K记录表中获取仅在组合框中列出的65K记录的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个155K记录的表.我只能在具有带有查询或sql记录源的窗体的组合框中滚动65K记录,然后从该表中选择三个字段.为什么它不列出所有的155K记录,甚至连我用作记录源的查询也显示了表格之外的所有记录.
I have a table of 155K records. I can scroll only 65K records in combo box of a form having recordsource with query or sql, selecting three fields from that table. Why it does not list all 155K records even the query, which I am using as recordsource, shows all records outside of the form.
推荐答案
也许项目索引是16位整数
perhaps the item index is a 16-bit integer
一个更好的问题是,您真的希望用户在组合框中滚动浏览155,000个项目吗?
a better question would be, do you really expect the user to scroll through 155 thousand items in a combobox?
这篇关于从155K记录表中获取仅在组合框中列出的65K记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!