[AccessD] AccessD Digest, Vol 120, Issue 4

John Bodin jbodin at sbor.com
Fri Feb 8 12:58:29 CST 2013


Thanks Jack.  In that thread, there was a link to a download of a Seat
Reservation Demo that had a generic function MakeFunctionCall() that showed
a more functional way of building an event procedure call to assign to say
OnClick or OnMouseMove events.  That's better than my direct coding (similar
to what Stuart was referencing in his response to me) and allows for a clean
way to build a parameter list.  Appreciate it.

John

Message: 18
Date: Wed, 6 Feb 2013 15:01:03 -0500
From: jack drawbridge <jackandpat.d at gmail.com>
To: Access Developers discussion and problem solving
	<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Generic Procedure on form controls for Drag and
	Drop
Message-ID:
	<CAKvidAuP-LQrMw9OZML0YZm-v+D843QabvXjB2f=cb1Jk71ikA at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

John,

Read this thread and see if it helps
http://www.access-programmers.co.uk/forums/showthread.php?t=166799

Funny I asked for a book reference on Event Procedures yesterday and got no
responses. I found this link after some searching.

Good luck.
jack

On Wed, Feb 6, 2013 at 1:55 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


End of AccessD Digest, Vol 120, Issue 4
***************************************




More information about the AccessD mailing list