[AccessD] Where do we go from here?

philippe pons phpons at gmail.com
Thu Feb 12 03:14:03 CST 2009


Using the RaiseEvent is not so  easy.
If you could give us some tricks on that
It would be usefull.

Philippe



2009/2/11 Max Wanadoo <max.wanadoo at gmail.com>

> > Perhaps an audit trail for changes
> Yes, that is topical
>
> > Have you ever inherited a database (or designed one for that matter)
> where
> dates are entered and
> displayed in different formats all over the various forms.  No consistency,
> drives the users crazy.
> That's how I write my programs!  Duh!  Now you know why it needs a
> makeover.
>
> Ok, and here is another we could look at:  Making sure that all code that
> calculate (say) basic + tax * gross profit - overheads etc etc is the same
> right across the board by hiding all the calcs in a single class.  Only one
> place to get the calculations for business rules and that is (ie)
> clsBusinessRules  Let people from the List come up with business rules and
> then, as a lesson, build the class to handle those rules.
>
> Max
>
>
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: 11 February 2009 22:45
> To: Access Developers discussion and problem solving
>  Subject: Re: [AccessD] Where do we go from here?
>
> ROTFL.
>
> You laugh but when I learned about classes, I rewrote my entire framework
> from scratch.  It was
> sooooo much cleaner and so much more functional.  Then, with the experience
> I gained from that I
> rewrote it a third time.
>
> Classes really do rock!
>
> In this case however I am looking for ideas on what simple things we can do
> to better illustrate how
> and why you would use a class.  If you get too complex people will drop
> like
> flies.  Let them get
> hooked, then we can do some more complex stuff.  Perhaps an audit trail for
> changes?
>
> For now I think the next step will be to build some tables with data and a
> form to load / edit data
> for a combo box.  Once we have that then I can demonstrate having the combo
> class double click event
> automatically open the form, seek to the right record (or the new record)
> and let the user add new
> records to the list table.  When the form closes, the combo requeries to
> get
> the changes to the list
> data.
>
> This is actual stuff that I do with my combo class, and displays how a
> combo
> can have behaviors
> added in the wrapper class to make it more useful.  Additionally it
> demonstrates how these behaviors
> can be available in any combo in any form, with a very simple "setup" to
> cause it to happen.
>
> Have you ever inherited a database (or designed one for that matter) where
> dates are entered and
> displayed in different formats all over the various forms.  No consistency,
> drives the users crazy.
>
> I also have a behavior where (in a bound form) I dig down to discover the
> data type of the field
> that a control is bound to (DAO here).  Once I have the datatype, I
> automatically cause the text box
> to display a specific date mask if the text box is bound to a date field.
> Having this behavior in
> the text class allows me to tell the system in one place what the date
> format should look like, and
> then when any form (that uses the form class) opens, it automatically
> discovers all date fields and
> sets them up to a common date mask.
>
> Stuff like that.
>
> We have pretty much learned how to build classes, and how to sink events in
> classes, so it is time
> to put this new knowledge to use.
>
> John W. Colby
> www.ColbyConsulting.com <http://www.colbyconsulting.com/>
>
>
> Max Wanadoo wrote:
> > Well, for me it would be a project.  I have suggested a fully functional
> > import/export to text for all objects to help people avoid bloat and
> recover
> > from disasters.  My second project request would be to re-write the whole
> of
> > my work project which started in 2000 and really, and I mean really, do
> with
> > a make-over.  On second thoughts, my second request is now my first
> > request!!!  When do we start?
> >
> > Max
> > Ps.  Well, you did ask!
> >
> >
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> > Sent: 11 February 2009 22:06
> > To: Access Developers discussion and problem solving
> > Subject: [AccessD] Where do we go from here?
> >
> > So what would you folks like to see next?  I still have a rabbit in the
> hat
> > and a few things up my
> > sleeve.
> >
> --
> 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