David McAfee
davidmcafee at gmail.com
Wed Jul 29 19:49:27 CDT 2009
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