[AccessD] Has anyone ever sen a listbox not display all rows?

Is the number of columns in the property sheet the same as the number of
columns in the record source?

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee
Sent: Wednesday, July 29, 2009 9:01 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Has anyone ever sen a listbox not display all rows?

The similar listbox on different forms works correctly, so I figured the
listbox was somehow corrupt.
I deleted the control, saved the form, recreated the listbox and it still
does the* *same thing!

I just noticed one thing. The listbox seems to be only showing 6 records
max.
If I look at a record with 14 items, which requires a scroll, upon scrolling
to the bottom of the list box, it repaints the list box and shows all the
reocrds. WTF!?!?!?!

On Wed, Jul 29, 2009 at 6:14 PM, David McAfee <davidmcafee at gmail.com> wrote:

> I just tried it, but it still only shows the 6 rows (yet 3 blank rows 
> are selectable underneath the visible rows)
>
> I think the listbox is corrupt.
> Im going to replace it.
>
> The same "machine history" list box on other forms correctly displays 
> the 9 rows.
>
>
> On Wed, Jul 29, 2009 at 6:05 PM, <anitatiedemann at gmail.com> wrote:
>
>> Could have something to do with the # - it looks like Access has not 
>> interpreted the data correctly
>>
>> Try just including the first column in the list and see if it returns 
>> all the records then.
>>
>> Anita
>> On 30/07/2009 10:49am, David McAfee <davidmcafee at gmail.com> wrote:
>> > I have a listbox on a tab control on a form in an ADP. A2003.
>> >
>> >
>> >
>> >
>> >
>> > A user called to tell me that a certain transaction wasn't showing 
>> > up in
>> the
>> >
>> >
>> > machine history tab.
>> >
>> >
>> >
>> >
>> >
>> > When I attempted to see why that one transaction was falling out in 
>> > the
>> >
>> >
>> > stored procedure, I noticed it was in the result set.
>> >
>> >
>> >
>> >
>> >
>> > I look at the rowsource for the list box, which is correct:
>> >
>> >
>> >
>> >
>> >
>> > EXEC stpGetMachHist 17631
>> >
>> >
>> >
>> >
>> >
>> > 17631 is a numeric ID.
>> >
>> >
>> >
>> >
>> >
>> > The listbox only displays five rows:
>> >
>> >
>> > 07/28/2009        Sold under transaction # OI/009049/09
>> >
>> >
>> > 06/26/2009        Credited under transaction # CRI/000654/09
>> >
>> >
>> > 11/27/2008        Warranty Expired
>> >
>> >
>> > 07/07/2008        Stock Transfer to 21000 under Tran# STK/000352/08
>> >
>> >
>> > 04/08/2008        Transferred to (21010) MOC Colorado under Tran#
>> >
>> >
>> > OI/004770/08
>> >
>> >
>> >
>> >
>> >
>> > If I copy and paste "EXEC stpGetMachHist 17631" from the list box
>> controls
>> >
>> >
>> > property into SQL Server Management Studio and hit F5 (Execute)
>> >
>> >
>> > I get:
>> >
>> >
>> >
>> >
>> >
>> > 07/28/2009        Sold under transaction # OI/009049/09
>> >
>> >
>> > 06/26/2009        Credited under transaction # CRI/000654/09
>> >
>> >
>> > 11/27/2008        Warranty Expired
>> >
>> >
>> > 07/07/2008        Stock Transfer to 21000 under Tran# STK/000352/08
>> >
>> >
>> > 04/08/2008        Transferred to (21010) MOC Colorado under Tran#
>> >
>> >
>> > OI/004770/08
>> >
>> >
>> > 12/11/2007        Credited under transaction # CRI/001445/07
>> >
>> >
>> > 11/28/2007        Transferred to (21010) MOC Colorado under Tran#
>> >
>> >
>> > OI/016776/07
>> >
>> >
>> > 11/28/2007        Warranty begins
>> >
>> >
>> > 07/12/2007        Machine Released from WO# EQP00H000263/07
>> >
>> >
>> >
>> >
>> >
>> > Column count is correctly set to 3 (I deleted the names of the 
>> > personal
>> from
>> >
>> >
>> > this email)
>> >
>> >
>> > It appears that the bottom (oldest) four transactions arent appering.
>> >
>> >
>> >
>> >
>> >
>> > But get this! if I click in the list box the blank rows get 
>> > selected as
>> if
>> >
>> >
>> > data is being diplayed!!!
>> >
>> >
>> > If I then go to the immediate window and type this:
>> >
>> >
>> >  ?forms!frmRentalMachines3!lstMachHist.column(2)
>> >
>> >
>> > Transferred to (21010) MOC Colorado under Tran# OI/016776/07
>> >
>> >
>> >
>> >
>> >
>> > Any ideas???
>> >
>> >
>> >
>> >
>> >
>> > David
>> >
>> >
>> > --
>> >
>> >
>> > 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