[AccessD] Calculated Fields

Susan Harkins ssharkins at gmail.com
Mon Jun 15 20:54:29 CDT 2015


Well, with enough research and insight I could write about them, but
without the practical experience, I'm not sure I could offer much of an
opinion! ;)

Susan H.

On Mon, Jun 15, 2015 at 8:00 PM, Charlotte Foust <charlotte.foust at gmail.com>
wrote:

> Maybe you could write on the pros and cons of using such a thing.  How
> would you decide that they would be appropriate rather than dangerous.  My
> thought is always what happens if it fails?  Do you just get a big error
> message, is it silent, or what?  If they raise a trappable error, where
> would you trap it?
>
> Charlotte Foust
> (916) 206-4336
>
> On Mon, Jun 15, 2015 at 4:40 PM, Susan Harkins <ssharkins at gmail.com>
> wrote:
>
> > So, you think calculated fields are of the same ilk? A column that
> updates
> > while someone's updating a table via a web app?
> >
> > Susan H.
> >
> > On Mon, Jun 15, 2015 at 6:59 PM, Charlotte Foust <
> > charlotte.foust at gmail.com>
> > wrote:
> >
> > > Web-based solutions are really what data macros were created for, to
> > > replace the VBA and Access macros that don't work on the web.  I've
> been
> > > hearing this from MVPs for some time but I can't point to a particular
> > > article.
> > >
> > > Data macros can be very powerful but, like triggers, they can be used
> > > inappropriately too.  I tend to use them to put date/time and user ID
> > into
> > > records automagically, but I don't use them to update a totals value.
> I
> > > don't think they work across tables, either, which triggers can.
> > >
> > > Charlotte Foust
> > > (916) 206-4336
> > >
> > > On Mon, Jun 15, 2015 at 3:51 PM, Susan Harkins <ssharkins at gmail.com>
> > > wrote:
> > >
> > > > Good information -- can you expound? Not necessary, but I'm
> interested
> > in
> > > > following this comment.
> > > >
> > > > Susan H.
> > > >
> > > > Their use in Access is, I think, aimed at web-based
> > > > > solutions.
> > > > >
> > > > >
> > > > --
> > > > 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
> > >
> > --
> > 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