[AccessD] Refreshing open forms when something changes

Drew Wutka DWUTKA at Marlow.com
Tue Jun 21 09:18:22 CDT 2011


But .Net doesn't magically make classes more understandable....  It just
makes them the 'default' per se, where as Access/VBA hides it better.
You are almost always using classes in VBA and VB 6, unless you build
something without an interface.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte
Foust
Sent: Tuesday, June 21, 2011 12:08 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Refreshing open forms when something changes

Agreed, John.  But you have to work at understanding classes in order to
use
them properly, and MS provided all these sloppy "shortcuts" ....

Charlotte Foust

On Mon, Jun 20, 2011 at 6:14 PM, jwcolby
<jwcolby at colbyconsulting.com>wrote:

> I would argue it isn't difficult to use classes, such as they are.
You can
> still do many useful things with them.
>
> Like a message class to send messages around an application.  ;)
>
>
>
> John W. Colby
> www.ColbyConsulting.com
>
>
>
> On 6/20/2011 8:23 PM, Charlotte Foust wrote:
>
>> 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 <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<http://databasead
visors.com/mailman/listinfo/accessd>
>>>>
>>>>
>>>>
>>>
>>>  Website:
http://www.databaseadvisors.**com<http://www.databaseadvisors.com>
>>>>
>>>>
>>>>
>>>
>>>
>>>>
>>>
>>>
>>> --
>>> AccessD mailing list
>>> AccessD at databaseadvisors.com
>>>
http://databaseadvisors.com/**mailman/listinfo/accessd<http://databasead
visors.com/mailman/listinfo/accessd>
>>>
>>>
>>>
>>>
>>> Website:
http://www.databaseadvisors.**com<http://www.databaseadvisors.com>
>>>
>>>
>>>
>>>
>>>
>>>  --
> AccessD mailing list
> AccessD at databaseadvisors.com
>
http://databaseadvisors.com/**mailman/listinfo/accessd<http://databasead
visors.com/mailman/listinfo/accessd>
>
>
> Website:
http://www.databaseadvisors.**com<http://www.databaseadvisors.com>
>
>
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
The information contained in this transmission is intended only for the person or entity 
to which it is addressed and may contain II-VI Proprietary and/or II-VI Business 
Sensitive material. If you are not the intended recipient, please contact the sender 
immediately and destroy the material in its entirety, whether electronic or hard copy. 
You are notified that any review, retransmission, copying, disclosure, dissemination, 
or other use of, or taking of any action in reliance upon this information by persons 
or entities other than the intended recipient is prohibited.





More information about the AccessD mailing list