Jim Lawrence (AccessD)
accessd at shaw.ca
Wed Mar 10 04:30:42 CST 2004
Something like what you have to do to create a muti-field combo box in VB? Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jürgen Welz Sent: Tuesday, March 09, 2004 10:18 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Combo on Continuous Form Acutally I meant multiple instances of the entire form. It's been a while since I did this. Last time I used a textbox control over a combo hiding everything but the dropdown arrow. In the gotfocus event of the textbox I hid the textbox and dropped the combo. In the lost focus I unhid the textbox. This was a bit unnerving in that the values in all the rows would be identical while the combo had focus but it worked fairly well. I recall seeing a less kludgy solution but can't remember exactly where. I just tried moving a separate form sized as a combo to the coordinates of the active control but Access does not accurately report the top position of the control in the current row of a continuous form. This is one of the places where an unbound grid of display controls comes into its own and this is the manner in which I handled this kind of thing more recently. It's a lot of code to build a scrollable grid of display controls. Ciao Jürgen Welz Edmonton, Alberta jwelz at hotmail.com >From: "Mark A Matte" <markamatte at hotmail.com> >Reply-To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >To: accessd at databaseadvisors.com >Subject: RE: [AccessD] Combo on Continuous Form >Date: Wed, 10 Mar 2004 04:42:13 +0000 >MIME-Version: 1.0 >X-Originating-IP: [24.167.155.76] >X-Originating-Email: [markamatte at hotmail.com] >X-Sender: markamatte at hotmail.com >Received: from mc12-f22.hotmail.com ([65.54.167.158]) by >mc12-s11.hotmail.com with Microsoft SMTPSVC(5.0.2195.6824); Tue, 9 Mar 2004 >20:43:05 -0800 >Received: from databaseadvisors.com ([209.135.140.44]) by >mc12-f22.hotmail.com with Microsoft SMTPSVC(5.0.2195.6824); Tue, 9 Mar 2004 >20:43:05 -0800 >Received: from databaseadvisors.com (databaseadvisors.com >[209.135.140.44])by databaseadvisors.com (8.11.6/8.11.6) with ESMTP id >i2A4gBM08877;Tue, 9 Mar 2004 22:42:11 -0600 >Received: from hotmail.com (bay1-f111.bay1.hotmail.com [65.54.245.111])by >databaseadvisors.com (8.11.6/8.11.6) with ESMTP id i2A4g7M08825for ><accessd at databaseadvisors.com>; Tue, 9 Mar 2004 22:42:07 -0600 >Received: from mail pickup service by hotmail.com with Microsoft >SMTPSVC;Tue, 9 Mar 2004 20:42:13 -0800 >Received: from 24.167.155.76 by by1fd.bay1.hotmail.msn.com with HTTP;Wed, >10 Mar 2004 04:42:13 GMT >X-Message-Info: jl7Vrt/mfsrUVeJNP+9RdguElqSJX66F >Message-ID: <BAY1-F111NVYlLdHMuk0000eea9 at hotmail.com> >X-OriginalArrivalTime: 10 Mar 2004 04:42:13.0964 >(UTC)FILETIME=[0EE098C0:01C4065A] >X-BeenThere: accessd at databaseadvisors.com >X-Mailman-Version: 2.1.4 >Precedence: list >List-Id: Access Developers discussion and problem >solving<accessd.databaseadvisors.com> >List-Help: <mailto:accessd-request at databaseadvisors.com?subject=help> >List-Post: <mailto:accessd at databaseadvisors.com> >List-Subscribe: ><http://databaseadvisors.com/mailman/listinfo/accessd>,<mailto:accessd-requ est at databaseadvisors.com?subject=subscribe> >List-Archive: <http://databaseadvisors.com/pipermail/accessd> >List-Unsubscribe: ><http://databaseadvisors.com/mailman/listinfo/accessd>,<mailto:accessd-requ est at databaseadvisors.com?subject=unsubscribe> >Errors-To: accessd-bounces at databaseadvisors.com >Return-Path: accessd-bounces at databaseadvisors.com > >Jürgen, > >If by multiple instances...you mean same combo appearing on each >row/record...then yes...this is what I am trying to accomplish. > >Thanks, > >Mark > > >>From: "Jürgen Welz" <jwelz at hotmail.com> >>Reply-To: Access Developers discussion and problem >>solving<accessd at databaseadvisors.com> >>To: accessd at databaseadvisors.com >>Subject: RE: [AccessD] Combo on Continuous Form >>Date: Tue, 09 Mar 2004 21:10:58 -0700 >> >>As long as you're not using multiple instances of your continuous form you >>can set the rowsource of the combo with a where clause referencing the >>Forms.FormName.FilterControlName. The reason it doesn't work with >>multiple instances is you need the absolute form reference. There are >>workarounds to the mulit instance issue but they are not convenient. >> >> >> >>Ciao >>Jürgen Welz >>Edmonton, Alberta >>jwelz at hotmail.com >> >> >> >> >> >>>From: "Mark A Matte" <markamatte at hotmail.com> >>>Hello, >>> >>>In A2k I want a combo box on a each row of the continuous form that >>>filters by the current record on that continuous form. Suggestions >>>anyone? >>> >>>Thanks, >>> >>>Mark >>> >>>_________________________________________________________________ >>>Get business advice and resources to improve your work life, from >>>bCentral. http://special.msn.com/bcentral/loudclear.armx >>> >>>-- >>>_______________________________________________ >>>AccessD mailing list >>>AccessD at databaseadvisors.com >>>http://databaseadvisors.com/mailman/listinfo/accessd >>>Website: http://www.databaseadvisors.com >> >>_________________________________________________________________ >>Tired of spam? Get advanced junk mail protection with MSN Premium >>http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=h ttp://hotmail.com/enca&HL=Market_MSNIS_Taglines >> >>-- >>_______________________________________________ >>AccessD mailing list >>AccessD at databaseadvisors.com >>http://databaseadvisors.com/mailman/listinfo/accessd >>Website: http://www.databaseadvisors.com > >_________________________________________________________________ >Create a Job Alert on MSN Careers and enter for a chance to win $1000! >http://msn.careerbuilder.com/promo/kaday.htm?siteid=CBMSN_1K&sc_extcmp=JS_J ASweep_MSNHotm2 > >-- >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com _________________________________________________________________ Add photos to your e-mail with MSN Premium. Get 2 months FREE* http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=htt p://hotmail.com/enca&HL=Market_MSNIS_Taglines -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com