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  1625 
Just wanted to add that if I change the combo box back to 3 columns, it
works fine.
Col wrote:
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:
Just wanted to add that if I change the combo box back to 3 columns, it
works fine.
Col wrote:
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:
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:
Just wanted to add that if I change the combo box back to 3 columns, it
works fine.
Col wrote:
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?
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Dave N |
last post by:
I have a combo box that displays the names of all the users in my "Users"
table. I set the RowSource to a Query from the "User" and "Project" tables.
I can select any name from the list and that...
|
by: Inquiring_Mind |
last post by:
i am creating a database. i have the following question..
as per the specs...
i need to be able to pull other forms from the master form using either
a list or a combo box. what is the...
|
by: Doug |
last post by:
Hi
I have the following code (not mine) that populates a datagrid with some
file names. But I want to replace the datagrid with a combo box.
private void OnCurrentDataCellChanged(object sender,...
|
by: Ron L |
last post by:
I have a dataset whose source is a SQL 2k stored procedure that I am trying
to display in a datagrid. This datasource has 4 columns that I am
interested in here, a text column and 3 value columns...
|
by: Erich Kohl |
last post by:
Okay, here's the deal:
Let's say a form is based on a table.
This form has Field1 (PrimeKey), Field2, Field3, etc.
This form also has a subform which shows related records in another
table....
|
by: sparks |
last post by:
I have a combo box that when you go to the next combo box it is
filtered based on the value in the previous one.
so if combo box 1 has fred as its value then combo box 2 has
1 2 3 for values....
|
by: biganthony via AccessMonster.com |
last post by:
Hi,
I decided to install Office 2003 Service Pack 3 on my home computer to test
(in full knowledge that there may be some issues with it). After installation,
I have noticed that with a small...
|
by: ypytt |
last post by:
Hi all,
I'm using C#. I have a DataGridView with a ComboBoxColumn. I'm filling the combo box Items collection programatically, because it is different for each row.
Each string in the Items list...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |
