[AccessD] Refreshing open forms when something changes

So you only use tables, queries and macros... with no code at all, other
than functions that never use class objects  (like tables and queries or
recordsets....)?

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
McLachlan
Sent: Wednesday, June 22, 2011 5:25 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Refreshing open forms when something changes

No, I just don't bother with trying to use Classes in Access.

-- 
Stuart

On 22 Jun 2011 at 18:09, jwcolby wrote:

> I assume that you don't program in Access then since you can't inherit
> anything?
> 
> ;)
> 
> John W. Colby
> www.ColbyConsulting.com
> 
> On 6/22/2011 4:41 PM, Stuart McLachlan wrote:
> > Hear, hear.
> >
> >>
> >> A. I don't use classes for the most part with Access.  Without full
> >> inheritance, I don't think it's worth the effort.  I can (for the
> >> most part) achieve the functionality of classes without the
> >> overhead of dealing with them.
> >>
> >
> > Apart from the lack of inheritance, the other problem with Access is
> > the single interface.
> >
> >>
> >>    So I see the need for the functionality it provides, but I don't
> >>    implement
> >> it in that way.  The way I have implemented that is through a
> >> specific class and middle tier business objects. It goes back to
> >> the comment I made about objects registering/unregistering for
> >> services.
> >
> > The way I implement this in other environments is using an event
> > interface or interfaces in the server object (in this case the form
> > where the changes are made)  and have client objects subscribe to
> > that interface.   The I can raise a specific event when a control
> > changes or whatever on an appropriate interface and the objects
> > which subscribe to it receive and act on the event.
> >
> > Just a few extra lines of code. No need for the kludge of a special
> > class when WIndows already provides a message pump.
> >
> >
> >
> -- 
> 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
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.