473,847 Members | 2,440 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

3rd try: COMBOBOX not displaying all rows

Sorry..I keep hitting the wrong key and sending the post too soon...

The problem: COMBOBOX not displaying all possible rows.

The RecordSource (generated by SQL view of the Query Builder) is:
SELECT tblTPSTeam.empI D, [fname] & " " & [lname] AS ReqAnalyst
FROM tblTPSTeam
ORDER BY tblTPSTeam.lnam e;

I have gone to Form Design and displayed the RecordSource of the
combobox and then gone to the Build Query Screen and run the query. I
get 35 rows. Then when the application is run and the form is opened
and I try to select a row in the drop-down portion of the combobox, only
around 8 to 10 rows are shown.

Funny thing is ... this used to work. I don't know what has changed.
This is a working database. Please send help quick. Thanks.
Regards,
SueB

*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #1
7 3271
Some more information..

1. Acc 2K
2. I meant RowSource, not RecordSource

Regards,
SueB

*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #2
If you are seeing only 10 rows out of 35, and the query itself returns the
correct values, you probably need to apply the JET 4 service pack.

You can download it from:
http://support.microsoft.com/gp/sp

If you do not have SP3 for Office 2000, you should apply that also.

It is just possible that you have a ridiculously low value set under:
Tools | Options | Edit/Find | Don't Display ...
but I suspect the JET SP is the real issue, and have seen those symptoms.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Susan Bricker" <sl*****@verizo n.net> wrote in message
news:WI******** ********@news.u swest.net...
Some more information..

1. Acc 2K
2. I meant RowSource, not RecordSource

Nov 13 '05 #3
Allen,

Thank you for the information. Since I am at work I will probably have
to work with some support group here to get the service pack update.
Two more questions ...

1. How do I find out the latest service pack that is loaded on my
machine?
2. I just checked, and the value for the maximum number of rows in a
list to display is currently defined as 1000. For this particular
combobox that number should be sufficient. However, for other
applications, is it acceptable to bump that number up to a VERY LARGE
number? How large a number is acceptable and what are the constraints?

Thanks much.

Regards,
SueB

*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #4
Susan Bricker <sl*****@verizo n.net> wrote in
news:kD******** ********@news.u swest.net:
Sorry..I keep hitting the wrong key and sending the post too
soon...

The problem: COMBOBOX not displaying all possible rows.

The RecordSource (generated by SQL view of the Query Builder) is:
SELECT tblTPSTeam.empI D, [fname] & " " & [lname] AS ReqAnalyst
FROM tblTPSTeam
ORDER BY tblTPSTeam.lnam e;

I have gone to Form Design and displayed the RecordSource of the
combobox and then gone to the Build Query Screen and run the
query. I get 35 rows. Then when the application is run and the
form is opened and I try to select a row in the drop-down portion
of the combobox, only around 8 to 10 rows are shown.

Funny thing is ... this used to work. I don't know what has
changed. This is a working database. Please send help quick.


Is there, perhaps, a mismatch between the number of columns defined
for the combo box and the number of columns returned by the SQL?

If, for instance, your combo box says there's two columns, but your
SQL returns only one, then you'll see half as many rows, since row
1's data will be in column 1 row 1, and row 2's data will be in 1:2,
etc.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #5
Locate the file msjet40.dll on your hard disk. There should be one copy
only, and it will typically be in windows\system3 2. Right-click it, and
choose Properties. On the Version tab, you should see:
4.08.xxx.0
The xxx numbers don't matter, but if you don't see the 8, get SP8 for JET 4.

Access works fine with hundreds of records in the RowSource of a combo, and
even into thousands. If you need to refer to tens of thousands, consider
delay-loading the combo, i.e. don't load the rowsource until the 3rd or 4th
keystroke, so only a few hundred records are actually loaded and it all
happens between keystrokes. There's an example of how to do that in:
Combos with Tens of Thousands of Records
at:
http://allenbrowne.com/ser-32.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Susan Bricker" <sl*****@verizo n.net> wrote in message
news:s3******** ********@news.u swest.net...
Allen,

Thank you for the information. Since I am at work I will probably have
to work with some support group here to get the service pack update.
Two more questions ...

1. How do I find out the latest service pack that is loaded on my
machine?
2. I just checked, and the value for the maximum number of rows in a
list to display is currently defined as 1000. For this particular
combobox that number should be sufficient. However, for other
applications, is it acceptable to bump that number up to a VERY LARGE
number? How large a number is acceptable and what are the constraints?

Nov 13 '05 #6
Susan Bricker wrote:
I have gone to Form Design and displayed the RecordSource of the
combobox and then gone to the Build Query Screen and run the query. I
get 35 rows. Then when the application is run and the form is opened
and I try to select a row in the drop-down portion of the combobox, only
around 8 to 10 rows are shown.


First thought - have you accidentally changed the column count?
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Nov 13 '05 #7
Thank you ALL for the information. I believe that it was a column count
problem. I had an extra column in the column widths but in the query I
had a column with "show" not checked. I reduced the number of columns
and widths and the display works now. For the life of me, I would swear
that this used to work properly. Oh well, at least it works now.

And additional thanks to Allen for the info about displaying large
numbers of rows. I definitely will go look at your example.

Regards,
SueB

*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
6096
by: Ronny Sigo | last post by:
Hello all, On my form I have an unbound combobox based on a query displaying two rows. The rows are : 1) Zipcode (Leftmost (In the query this field is sorted ascending 2 City The BoundColumn property is set to 2, because the value of Citymust appear in another control When selecting a unique zipcode there is no problem, it does what is expected but ...
2
1248
by: Susan Bricker | last post by:
Regards, SueB *** Sent via Developersdex http://www.developersdex.com ***
0
1213
by: Elliot M. Rodriguez | last post by:
I am having difficulty loading and displaying data from an XML file into a ComboBox Compact Framework control. The XML file has 1 parent node and one child node, which contains the data I want: - node1 --- node2 ------ dataitem1 ------ dataitem2
2
3498
by: Rey | last post by:
Howdy all. This may have been covered previously but I've had no success in retrieving it... Where may I find what the limitations are of the various controls, i.e. number of records/items that can be displayed in a dropdown combobox. In Paradox, this is 2500 items. If, for instance, a customer table has more than the limitation, I'm looking at somehow displaying a table containing the alphabet such that when the user clicks on a...
4
1378
by: John Suru | last post by:
I am loading up a combobox with data from an access database. The field I am loading is a date/time datatype. The data in the field is a short date(ex. 01/22/2004). When I load the combobox with the data it appears correct. When I click on the dropdown arrow of the combobox, all of the entries have 12:00:00 AM added to the end of the date entries. Instead of displaying 01/22/2004 the combobox displays 01/22/2004 12:00:00 AM. What do I need to...
20
2045
by: MadCrazyNewbie | last post by:
Hey group, I keep getting the following error: "An unhandled exception of type 'System.IndexOutOfRangeException' occurred in system.data.dll Additional information: There is no row at position 1." on the following line of code:
6
1791
by: Doug Bell | last post by:
Hi I have a datagrid with a combo box, I need to populate the combo with data dependant on the record value. eg for record 1, field Warehouse = 2R so combo would allow selection of locations valid for 2R record 2 has Warehouse = 2M so combo on that row has a selection of locations valid for 2M I can set the combo datasource but can't see how to set it on a row by row basis.
2
1701
by: Brian Tkatch | last post by:
This is mostly for the fun of it. Just saw it in the FAQ and figured i'd quickly give it a shot. The syncfusion FAQ <URL:http://www.syncfusion.com/FAQ/WindowsForms/FAQ_c44c.aspx#q480q> mentions: "5.9 How can I put a combobox in a column of a datagrid? There are several ways to go about this task. The simplest way involves
0
2255
by: sixths3ns3 | last post by:
My DataGridView has two columns. Combobox Column 2 displays list based on Combobox Column 1 selected value. The code below works fine when I select a value on Column 1, and select a value on Column 2. But on the next row, when I leave Column 1 blank and click on Column 2, it generates error DataGridViewComboBoxCell value is invalid. And the code below works fine the first time I click Column 2, leaving Column 1 blank. I just want to...
0
9879
marktang
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9727
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10981
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9477
agi2029
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7879
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5716
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5907
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
4113
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3158
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.