[AccessD] Calculated Fields

Charlotte Foust charlotte.foust at gmail.com
Mon Jun 15 19:00:58 CDT 2015


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
>


More information about the AccessD mailing list