Combo Box not displaying all rows
Question posted by: Col
(Guest)
on
July 17th, 2006 01:25 AM
Hi - I'm using Access 2000. I have a combo box with 4 columns based on
a query with 4 columns. The query has 111 records. The combo box will
only display 11. When I had 3 columns, it displayed all records. When I
added the 4th column, it initially displayed 17 records. I made a
change to the query, and now it only shows 10 of the records. I've
compacted and repaired without any change. I tried recreating the combo
box using the wizard, and I'm now back to 17 records...
Any suggestions?
3
Answers Posted
Just wanted to add that if I change the combo box back to 3 columns, it
works fine.
Col wrote:
Quote:
Originally Posted by
Hi - I'm using Access 2000. I have a combo box with 4 columns based on
a query with 4 columns. The query has 111 records. The combo box will
only display 11. When I had 3 columns, it displayed all records. When I
added the 4th column, it initially displayed 17 records. I made a
change to the query, and now it only shows 10 of the records. I've
compacted and repaired without any change. I tried recreating the combo
box using the wizard, and I'm now back to 17 records...
>
Any suggestions?
Can you give more detail, the sql from the query would be helpful.
Might have something to do with the SELECT, SELECT DISTINCT , or SELECT
DISTINCTROW part of the query, or the grouping but without more detail
I cannot tell, I doubt that anyone else can either.
Good luck
Nick
Col wrote:
Quote:
Originally Posted by
Just wanted to add that if I change the combo box back to 3 columns, it
works fine.
>
Col wrote:
Quote:
Originally Posted by
Hi - I'm using Access 2000. I have a combo box with 4 columns based on
a query with 4 columns. The query has 111 records. The combo box will
only display 11. When I had 3 columns, it displayed all records. When I
added the 4th column, it initially displayed 17 records. I made a
change to the query, and now it only shows 10 of the records. I've
compacted and repaired without any change. I tried recreating the combo
box using the wizard, and I'm now back to 17 records...
Any suggestions?
Hi - is this what you are looking for..?
SELECT [EENames].[EEID], [EENames].[LastName], [EENames].[FirstName],
[EENames].[DateEntered] FROM EENames;
Nick 'The Database Guy' wrote:
Quote:
Originally Posted by
Can you give more detail, the sql from the query would be helpful.
>
Might have something to do with the SELECT, SELECT DISTINCT , or SELECT
DISTINCTROW part of the query, or the grouping but without more detail
I cannot tell, I doubt that anyone else can either.
>
Good luck
>
Nick
>
>
Col wrote:
Quote:
Originally Posted by
Just wanted to add that if I change the combo box back to 3 columns, it
works fine.
Col wrote:
Quote:
Originally Posted by
Hi - I'm using Access 2000. I have a combo box with 4 columns based on
a query with 4 columns. The query has 111 records. The combo box will
only display 11. When I had 3 columns, it displayed all records. When I
added the 4th column, it initially displayed 17 records. I made a
change to the query, and now it only shows 10 of the records. I've
compacted and repaired without any change. I tried recreating the combo
box using the wizard, and I'm now back to 17 records...
>
Any suggestions?
|
|
|
What is Bytes?
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 196,973 network members.
Top Community Contributors
|
