|
 |
access thread: Exceeding Limit Of Records In Combo Box
Message #1 by flanders@m... on Sat, 28 Jul 2001 05:56:03
|
|
All,
I have a combo box that is populated with the airports and airport codes
for the US. It uses a Value List of entries in a long string.
Works great.
The bound column is the airport code, and in the expanded view it shows
the full name. Like this:
CODE AIRPORT
---- -------
LAX LOS ANGELES INT
ATL ATLANTA, GA
etc . . .
I just upgraded the app so that it lists all the airports in the WORLD.
PROBLEM: There's too many. It gives an error "recordset too long"
Any ideas?
Pat Flanders
flanders@m...
Message #2 by erezmor@n... on Sat, 28 Jul 2001 15:14:14
|
|
gday mate
since using a value list is recommended for a short non-changing list of items (by access help),
you should use a new table with airportCode and airportName fields (adding other fields as
airportCountry will make your App even more versatile), then link the combo to the table.
hope it helps
erez.
> All,
>
> I have a combo box that is populated with the airports and airport codes
> for the US. It uses a Value List of entries in a long string.
>
> Works great.
>
> The bound column is the airport code, and in the expanded view it shows
> the full name. Like this:
>
> CODE AIRPORT
> ---- -------
> LAX LOS ANGELES INT
> ATL ATLANTA, GA
>
> etc . . .
>
> I just upgraded the app so that it lists all the airports in the WORLD.
>
> PROBLEM: There's too many. It gives an error "recordset too long"
>
> Any ideas?
>
> Pat Flanders
>
> flanders@m...
Message #3 by "Peter Kaufman" <kaufman@l...> on Sun, 29 Jul 2001 09:31:16 +0700
|
|
I *think*, at this site, there is code to limit the contents of a combobox
on the to the first letter. I.e., type 'A' and the combobox is limited to
the A's.
http://student.muskegon.cc.mi.us/~carlsonr/
HTH,
Peter
-----Original Message-----
From: flanders@m... [mailto:flanders@m...]
Sent: July 28, 2001 5:56 AM
To: Access
Subject: [access] Exceeding Limit Of Records In Combo Box
All,
I have a combo box that is populated with the airports and airport codes
for the US. It uses a Value List of entries in a long string.
Works great.
The bound column is the airport code, and in the expanded view it shows
the full name. Like this:
CODE AIRPORT
---- -------
LAX LOS ANGELES INT
ATL ATLANTA, GA
etc . . .
I just upgraded the app so that it lists all the airports in the WORLD.
PROBLEM: There's too many. It gives an error "recordset too long"
Any ideas?
Pat Flanders
flanders@m...
---
Message #4 by "Yehuda Rosenblum" <Yehuda@I...> on Mon, 30 Jul 2001 09:19:42 -0400
|
|
What is too many? As I remember a combo box can accommodate thousands
of entries. If you have that many entries a combobox is not really
helpful. Instead I would use a textbox that tests against the table and
tells the user if the entry is correct or not. Alternatively, you could
have them enter the location and give them a list of airports in the
area.
-----Original Message-----
From: flanders@m... [mailto:flanders@m...]
Sent: Saturday, July 28, 2001 1:56 AM
To: Access
Subject: [access] Exceeding Limit Of Records In Combo Box
All,
I have a combo box that is populated with the airports and airport codes
for the US. It uses a Value List of entries in a long string.
Works great.
The bound column is the airport code, and in the expanded view it shows
the full name. Like this:
CODE AIRPORT
---- -------
LAX LOS ANGELES INT
ATL ATLANTA, GA
etc . . .
I just upgraded the app so that it lists all the airports in the WORLD.
PROBLEM: There's too many. It gives an error "recordset too long"
Any ideas?
Pat Flanders
flanders@m...
|
|
|
View Cart
