William Hindman
wdhindman at dejpolsystems.com
Tue Mar 13 07:28:31 CDT 2007
...still talking to himself? :) William Hindman ----- Original Message ----- From: "Andy Lacey" <andy at minstersystems.co.uk> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Sent: Tuesday, March 13, 2007 3:37 AM Subject: Re: [AccessD] FW: Combo Box Not Showing All Records > Blimey Rocky, where would you be without the list eh? > > -- Andy Lacey > http://www.minstersystems.co.uk > >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of >> Rocky Smolin at Beach Access Software >> Sent: 13 March 2007 03:09 >> To: 'Access Developers discussion and problem solving' >> Subject: Re: [AccessD] FW: Combo Box Not Showing All Records >> >> >> Hey good solution Rocky. You're a peach. Thanks. >> >> Rocky >> >> >> >> >> >> >> >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of >> Rocky Smolin at Beach Access Software >> Sent: Monday, March 12, 2007 7:12 PM >> To: 'Access Developers discussion and problem solving' >> Subject: Re: [AccessD] FW: Combo Box Not Showing All Records >> >> OK I'll just talk to myself - nothing new. >> >> Hey. Here's your problem Rocky. You accidentally changed >> the number of columns on the combo box from 7 to 8. The >> underlying queries have only seven fields. >> >> When you tested it in A2K3 you didn't see the problem but >> when you sent it to your client who is using A2K they did >> have the problem. Why it works in A2K3 and not in A2K I >> don't know. But now you have the fix. >> >> HTH >> >> Rocky >> >> >> >> >> >> >> >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of >> Rocky Smolin at Beach Access Software >> Sent: Monday, March 12, 2007 3:37 PM >> To: 'Access Developers discussion and problem solving' >> Subject: [AccessD] FW: Combo Box Not Showing All Records >> >> Further to my post below. The problem is in the code where I >> change the row source of the combo box. Because if I change >> it on the property sheet it works OK. Here's the code: >> >> Select Case fraFindOrderBy >> >> Case 1 >> cboAgreements.RowSource = "qryAgreementsByOrderNumber" >> Me.RecordSource = "qryRentalAgreementHeaderByOrderNumber" >> Me.cboAgreements.ColumnWidths = >> "0"";0.75"";2"";1"";1.5"";0.75"";0.5""" >> Case 2 >> cboAgreements.RowSource = "qryAgreementsByCustomer" >> Me.RecordSource = "qryRentalAgreementByCustomer" >> Me.cboAgreements.ColumnWidths = >> "0"";2"";0.75"";1"";1.5"";0.75"";0.5""" >> Case 3 >> cboAgreements.RowSource = "qryAgreementsByDateOut" >> Me.RecordSource = "qryRentalAgreementByDateOut" >> Me.cboAgreements.ColumnWidths = >> "0"";1"";2"";0.75"";1.5"";0.75"";0.5""" >> Case 4 >> cboAgreements.RowSource = "qryAgreementsByPurchaseOrder" >> Me.RecordSource = "qryRentalAGreementByPurchaseOrder" >> Me.cboAgreements.ColumnWidths = >> "0"";1.5"";0.75"";2"";1"";0.75"";0.5""" >> Case 5 >> cboAgreements.RowSource = "qryAgreementsByFirstUseDate" >> Me.RecordSource = "qryRentalAGreementByFirstUseDate" >> Me.cboAgreements.ColumnWidths = >> "0"";1"";1.5"";0.75"";2"";0.75"";0.5""" >> >> End Select >> >> cboAgreements.Requery >> Me.Requery >> >> >> TIA >> >> Rocky >> >> >> _____ >> >> From: Rocky Smolin at Beach Access Software >> [mailto:rockysmolin at bchacc.com] >> Sent: Monday, March 12, 2007 3:28 PM >> To: 'Access Developers discussion and problem solving' >> Subject: Combo Box Not Showing All Records >> >> >> Dear List: >> >> I have a combo box on a form with seven fields. There is an >> option frame on the form to let the user select how the data >> in the combo box is to be sorted. The options are Order >> Number, Customer, P.O., Date Out, and First Use Date. >> >> In the after update event of the option frame I set the row >> source of the combo box, adjust the widths of the columns, >> and requery the box. I have five separate queries. >> >> Problem is that not all the records show up in the box >> although they all show up in the query. >> >> Order Number works correctly. By Customer the query selects >> 19488 records but the combo box only displays 18242. Sort by >> Date Out the query selects 19301 records but the combo box >> only shows 139. First Use date - the query selects 19733 but >> the combo box only shows 15385. Purchase Order - the query >> selects 13060 but the combo box only goes down to 13055 (so close!) >> >> This is an A2K data base running on SP-3. >> >> But the A2K format mdb all works correctly in A2K3! >> >> Any ideas what's going on here? >> >> MTIA >> >> Rocky >> >> >> >> >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> >> -- >> No virus found in this incoming message. >> Checked by AVG Free Edition. >> Version: 7.5.446 / Virus Database: 268.18.8/718 - Release >> Date: 3/11/2007 9:27 AM >> >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> >> -- >> No virus found in this incoming message. >> Checked by AVG Free Edition. >> Version: 7.5.446 / Virus Database: 268.18.10/720 - Release >> Date: 3/12/2007 7:19 PM >> >> >> -- >> 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 >