David McAfee
davidmcafee at gmail.com
Wed Jul 29 20:14:33 CDT 2009
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 > > > > > >