By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,734 Members | 855 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,734 IT Pros & Developers. It's quick & easy.

Access List of Values Incomplete

P: n/a
I have a combo box with a query for a list of names etc. The table has 250,000 rows. The query returns 250,000 rows. But the list returns only 97,000 rows and then shows blank columns after that, so it appears to be returning 250,000 rows but most of them incomplete. So, I have names from A to D but nothing after that.

The table was initially an SQL rdbms table but I've imported the data directly into Access with no change in results. BTW, I have another database with a combo box on essentially the same data, and it works fine. I'm at a loss.

Any ideas?

Access 97. <sigh I know, 'tis old..

Yes, I've compacted/repaired the database.
--
Brian
Sep 13 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Wed, 13 Sep 2006 09:52:21 -0400, "Brian Graham"
<Gr*****@psac-afpc.comwrote:

That's WAY too many records for a list (I'm assuming you mean a
dropdown list). You may get timing issues resulting in incompletely
filled lists.
Rather do this: have the user type the first few characters in an
empty dropdown; then query the datasource and return only a thousand
or so matching rows.

-Tom.

>I have a combo box with a query for a list of names etc. The table has 250,000 rows. The query returns 250,000 rows. But the list returns only 97,000 rows and then shows blank columns after that, so it appears to be returning 250,000 rows but most of them incomplete. So, I have names from A to D but nothing after that.

The table was initially an SQL rdbms table but I've imported the data directly into Access with no change in results. BTW, I have another database with a combo box on essentially the same data, and it works fine. I'm at a loss.

Any ideas?

Access 97. <sigh I know, 'tis old..

Yes, I've compacted/repaired the database.
Sep 13 '06 #2

P: n/a
I'll give that a try. The other database does indeed restrict the data by region and therefore is only about 10% of the size. Thanks for the quick response!
--
Brian
>>Tom van Stiphout<no*************@cox.netSeptember 13, 2006 10:14:08 am >>>
On Wed, 13 Sep 2006 09:52:21 -0400, "Brian Graham"
<Gr*****@psac-afpc.comwrote:

That's WAY too many records for a list (I'm assuming you mean a
dropdown list). You may get timing issues resulting in incompletely
filled lists.
Rather do this: have the user type the first few characters in an
empty dropdown; then query the datasource and return only a thousand
or so matching rows.

-Tom.

>I have a combo box with a query for a list of names etc. The table has 250,000 rows. The query returns 250,000 rows. But the list returns only 97,000 rows and then shows blank columns after that, so it appears to be returning 250,000 rows but most of them incomplete. So, I have names from A to D but nothing after that.

The table was initially an SQL rdbms table but I've imported the data directly into Access with no change in results. BTW, I have another database with a combo box on essentially the same data, and it works fine. I'm at a loss.

Any ideas?

Access 97. <sigh I know, 'tis old..

Yes, I've compacted/repaired the database.


Sep 13 '06 #3

P: n/a
Brian Graham wrote:
I have a combo box with a query for a list of names etc. The table has 250,000 rows. The query returns 250,000 rows. But the list returns only 97,000 rows and then shows blank columns after that, so it appears to be returning 250,000 rows but most of them incomplete. So, I have names from A to D but nothing after that.

The table was initially an SQL rdbms table but I've imported the data directly into Access with no change in results. BTW, I have another database with a combo box on essentially the same data, and it works fine. I'm at a loss.

Any ideas?

Access 97. <sigh I know, 'tis old..

Yes, I've compacted/repaired the database.
--
Brian

Do yourself a test sometime. Create a dummy form with a combo box and
select the top 10000 records. Now open the form and attempt to slide
the vertical bar of the combo. Expecting to work with 250000 rows in a
combobox is ludicrous, let alone 10000.

I suggest creating a continuous form with those records. In the header
band create a field where they can select a column to search for (if you
want to provide search options) and a field to search on the value
entered. In the footer, have 2 command buttons to select the record
or cancel the search.

When the person hits the enter key on the search field, the form filters
on that value. See the Filter and FilterOn properties in online help
for more info.
Sep 13 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.