Darren DICK
darrend at nimble.com.au
Tue Feb 28 22:47:08 CST 2006
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