[AccessD] List Box does not show all

John W. Colby jwcolby at colbyconsulting.com
Tue Apr 27 19:34:31 CDT 2004


I have seen this too.  It had to do with the wrong number of columns in the
combo's column property vs the number in the sql statement.

John W. Colby
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gregg
Sent: Tuesday, April 27, 2004 4:04 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] List Box does not show all


Yes... that's true.  Here's a recap of the facts.

1. The problem comes and goes.  It happened a couple of weeks ago but by the
time they went to show it to me it was gone.  I didn't believe them of
course until it happened again this week and I could see it.  I fooled with
it and it went away but when I undid my changes it didn't come back... very
weird. I've seen this before at another customer using A97 where the list
would go from say "A" to "M" and that's all.  That was a much longer list
but only 2 columns wide.

2. When it happens it happens everywhere

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte
Foust
Sent: Tuesday, April 27, 2004 12:42 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] List Box does not show all


So if you paste that SQL into a query, you get a different number of row
than what shows in the combo?

Charlotte Foust

-----Original Message-----
From: Gregg [mailto:greggs at msn.com]
Sent: Tuesday, April 27, 2004 9:13 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] List Box does not show all


Susan,

It's a table... here's the source...

SELECT DISTINCTROW [PLastName]+", "+[PFirstName] AS PatientName,
PatientTbl.Address, PatientTbl.City, PatientTbl.Zip, PatientTbl.Phone,
PatientTbl.AdmittingNurse,
DateDiff("h",Format([ReferralDate],"mm/dd/yy") & " " &
Format([HourOfReferal],"hh:nn:ss"),Format(Now(),"mm/dd/yy hh:nn:ss")) AS
HoursSinceReferral, PatientTbl.PatientID FROM PatientTbl WHERE
((([PLastName]+", "+[PFirstName]) Is Not Null) AND
((PatientTbl.DenialReason) Is Null) AND ((PatientTbl.dateServiceStart)
Is Null));





-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Susan Harkins
Sent: Tuesday, April 27, 2004 9:23 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] List Box does not show all


Where are the list items coming from? Sounds like you're using a
Table/Query list, so this wouldn't be the problem, but a Value list is
limited in the number of characters, and with 7 columns, you might have
reached it -- if you're using a Value list.

Susan H.

The list box is trying to display 36 rows but only shows 23.  The query
behind the list is showing 36.  It's seven columns wide.  I thinks all
users are using the same version of A97.

--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com






More information about the AccessD mailing list