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 >