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

Max Wanadoo max.wanadoo at gmail.com
Thu Jul 30 03:50:14 CDT 2009


David,
Try COPYING a list box that works and then change the attributes to what you
need.
That sometimes works.

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee
Sent: 30 July 2009 05:01
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




More information about the AccessD mailing list