[AccessD] Refreshing open forms when something changes

Charlotte Foust charlotte.foust at gmail.com
Mon Jun 20 19:23:43 CDT 2011


In vb.net, this is the standard and expected way of doing things.  It allows
the various pieces to be black boxes that do something when they receive a
signal.  If you need another black box to do something on the same signal,
you sink the same event in the second black box.  You don't have to change
the code that raises the event.  It just raises it hand and waves, and any
black boxes that are listening do their thing.  If there are no listeners,
the hand gets some exercise but nothing else results.  Access (thank you
Microsoft) lets us be sloppy and not learn to use classes effectively.  In
fact, it makes it relatively difficult to use classes except for the built
in object classes, and even those hide much of their inner workings.

Charlotte Foust

On Mon, Jun 20, 2011 at 2:38 PM, Stuart McLachlan <stuart at lexacorp.com.pg>wrote:

> So instead of having all of your code encapsulated in one place (the
> list_modified event), you
> have it scattered all over your apllication?    Sounds like a maintenance
> nightmare to me.
>
> --
> Stuart
>
> On 20 Jun 2011 at 14:55, jwcolby wrote:
>
> > In my case, each and every recipient needs to do something different
> > but similar.  Requery something.  A pair of lists in one form, a
> > different combo in each of two other forms.  The sender just says "I
> > modified the list of cities".  The recipients says "OK, I need to do
> > this thing when the list of cities changes" and then does that thing.
> >
> >
> >
> > John W. Colby
> > www.ColbyConsulting.com
>
>
> >
> > On 6/20/2011 11:06 AM, Dan Waters wrote:
> > > Hi John,
> >  > For a separate form, first determine if the form is open:
> > --
> > 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