David & Joanne Gould
dajomigo at tpg.com.au
Tue Feb 28 23:18:49 CST 2006
Thanks Darren. As you said, less elegant, but logic says its the only way to go. can't believe I didn't think of something like that. Again, thanks. David At 03:47 PM 1/03/2006, you wrote: >Howdy >The on Double click - by its very event - will also activate the 'Enter' (on >first click) ,"Got Focus', 'Mouse Down', 'Mouse Up', Click and of course >'Double >Click' >SO if you've got code in nay of 'em - they get fired >So - when it gets a bit too crowded like that I put a small button to the >right >hand side of the combo - I know it's not as nice >To do whatever the double click code would have done > >See ya > > >Darren >------------------------------ >T: 0424 696 433 > > >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David & Joanne >Gould >Sent: Wednesday, 1 March 2006 3:36 PM >To: Access Developers discussion and problem solving >Subject: Re: [AccessD] Help with combo box > >Pity > >David >At 03:19 PM 1/03/2006, you wrote: > >David: > > > >AFAIK, no, the down arrow is not a separately programmable part of the > >control. But AFAIK may not go all that far. > > > >Rocky > > > > > >David & Joanne Gould wrote: > > > Rocky > > > > > > The Double-click event is set to open another form to change the > > > Rental Type for this movie title. What I was wondering was if there > > > was a way to access the drop-down arrow on the combo box as a > > > separate thing. This > > might > > > separate the main part of the control where all the other code is > > > connected. Can it be done? > > > > > > TIA > > > > > > David > > > > > > At 01:18 PM 1/03/2006, you wrote: > > > > > >> Sorry about the late response. I was out all day. Can you use the > > >> click event? What additional function are you trying to implement? > > >> > > >> Rocky > > >> > > >> > > >> David & Joanne Gould wrote: > > >> > > >>> Thanks for your prompt response Rocky. > > >>> > > >>> At 05:11 PM 28/02/2006, you wrote: > > >>> > > >>> > > >>>> What event is the current code attached to? > > >>>> The database form is the Hiring form for a video library. There > > >>>> is currently code attached to the "Before update" event, the "After >Update" > > >>>> event and the "On Double-click" event. The Double-click event > > >>>> allows the user to add oir change the hiring code (overnight, weekly, >etc). > > >>>> > > >>>> > > >>> > > >>>> Can you use the 'Got Focus' event to run your new code? > > >>>> > > >>>> > > >>> The other issue I forgot to mention is it's on a continuous form. > > >>> I have tried to make the combo box inactive if there is anything > > >>> entered in it, but that just makes it inactive for all the records > > >>> in the > > transaction (so > > >>> I would only be able to enter one movie per sale). > > >>> > > >>> > > >>> > > >>> > > >>>> Rocky > > >>>> > > >>>> > > >>>> David & Joanne Gould wrote: > > >>>> > > >>>> > > >>>>> I have a combo box on a form that has quite a lot of code > > >>>>> attached > > to it. > > >>>>> > > >>>>> Is there a way to run code when the user clicks on the drop-down > > >>>>> arrow > > >>>>> > > >>>>> > > >>>> that > > >>>> > > >>>> > > >>>>> won't interfere with other code that runs when the user > > double-clicks on > > >>>>> the combo box? > > >>>>> > > >>>>> TIA > > >>>>> > > >>>>> David > > >>>>> > > >>>>> > > >>>>> > > >>>>> > > >>>>> > > >>>> -- > > >>>> Rocky Smolin > > >>>> Beach Access Software > > >>>> 858-259-4334 > > >>>> www.e-z-mrp.com > > >>>> > > >>>> -- > > >>>> AccessD mailing list > > >>>> AccessD at databaseadvisors.com > > >>>> http://databaseadvisors.com/mailman/listinfo/accessd > > >>>> Website: http://www.databaseadvisors.com > > >>>> > > >>>> > > >>> > > >>> > > >> -- > > >> Rocky Smolin > > >> Beach Access Software > > >> 858-259-4334 > > >> www.e-z-mrp.com > > >> > > >> -- > > >> AccessD mailing list > > >> AccessD at databaseadvisors.com > > >> http://databaseadvisors.com/mailman/listinfo/accessd > > >> Website: http://www.databaseadvisors.com > > >> > > > > > > > > > > > > >-- > >Rocky Smolin > >Beach Access Software > >858-259-4334 > >www.e-z-mrp.com > > > >-- > >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 > >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com