[AccessD] Help with combo box

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





More information about the AccessD mailing list