[AccessD] Generic Procedure on form controls for Drag and Drop

Stuart McLachlan stuart at lexacorp.com.pg
Thu Feb 7 04:51:23 CST 2013


John,

JC is our resident "class" and "event sink"  guru.   Pay careful attention to what he says, you 
can learn a lot from him.

-- 
Stuart  

On 7 Feb 2013 at 3:28, John Colby wrote:

> This sounds like the perfect use for a class.  A class can Sync events.  A
> class is used when you have to do the same thing over and over.  The event
> sinks you mention would be embedded in the class and the code to process
> the event sinks would be embedded in the class.
> 
> I left my computer at work so I can't look at this right now.  In the
> morning I will respond further.
> On Feb 6, 2013 1:56 PM, "John Bodin" <jbodin at sbor.com> wrote:
> 
> > Hello,
> >
> >
> >
> > New to this list and need some guidance on a form I've developed (I posted
> > this on LinkedIn and got a few links with good information, but still
> > having
> > issues).
> >
> >
> >
> > I have a grid of many text boxes on a form in an Access 2003 app that I
> > fill
> > from a table upon opening the form as well as when the user changes a date
> > box. I add some generic procedure calls on the fly to each text box where I
> > pass the control to the generic function (for instance, I'll add a
> > double-click event to text box "Txt101" as "=TxtBoxDblClick([Txt101])".
> > This
> > will pass the control to my function TxtBoxDblClick so I can react to it.)
> > This all works fine for all text boxes and I reference just one (same)
> > routine for each control.
> >
> > I'm trying to experiment with Drag and Drop and found some code that I can
> > get to work if at Design time, I add three event procedures to a text box
> > control (Mouse Down/Up/Move). If I do this to two different controls,
> > creating 3 event procedures for each at design time, I can successfully
> > drag
> > and drop between the two controls. So the drag and drop code looks like it
> > works.
> >
> > My problem is, I want to have 3 generic routines like my TxtBoxDblClick
> > function, that I can add on the fly to the On Mouse Down/Up/Move events and
> > I can't figure out the syntax and/or code to make this happen. I can add
> > the
> > custom Functions no problem, but I know I need to be able to deal with the
> > Button, Shift, X & Y parameters somehow. I can pass the control to the
> > custom function, but am unable to reference the Button, Shift, X & Y
> > parameters. I'm guessing I'll need to create some type of class possibly?
> > If
> > so, can someone provide some sample code on how to do this what the calls
> > would be?  Thanks for any ideas. John
> >
> >
> >
> > --
> > 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