Re: Automatically updating a calculation field

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Graham Mayor (gmayor_at_NOSPAMmvps.org)
Date: 03/23/04 

Date: Tue, 23 Mar 2004 17:51:52 -0000

If this is an on-line form with form fields inserted from the forms toolbar
and locked, then check the calculate on exit check box in the last field. If
that doesn't update the calculation, run the macro suggested in my previous
post on exit from the field.

In an ordinary document, the fields do not update automatically. You must
update them. The update macro added to a toolbar is a simple workaround. 

-- 
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
     Graham Mayor -  Word MVP
   Web site www.gmayor.com
  Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Lin wrote:
> I have created a teacher's grant form which lets them list the costs
> of each item in the grant in the last column.  At the end of the
> column I want to calculate the costs. Currently I am updating the
> field by right clicking on the field and clicking on Update field.  I
> would like the field to automatically update when a cost is added to
> the column.

Relevant Pages

  • Custom Toolbars and Menu problem and questions
    ... Private Sub Form_BeforeUpdate ... Exit Sub ... toolbar button shouldbe canceled. ... Dim strFormName As String ...
    (microsoft.public.access.formscoding)
  • Complicated form problem...help!!
    ... Private Sub Form_BeforeUpdate ... Exit Sub ... toolbar button shouldbe canceled. ... Dim strFormName As String ...
    (microsoft.public.access.forms)
  • How Can i run a module in access
    ... Public Function Toolbar() ... If no entry made then exit. ... 'If correct password is entered open Adminsitration Toolbar ... run it in VB but i just cant get it to run in access. ...
    (microsoft.public.access.macros)
  • Re: Unresponsive toolbar
    ... Of course their support costs - everything you buy costs. ... Upon installing the addin (by going to com addins and adding ... ||| the dll file) the toolbar shows up and works fine in new messages. ...
    (microsoft.public.outlook)
  • Re: picture toolbar
    ... || Well, it kinda does, when you Insert, picture, new drawing, the ... || toolbar does appear but when you exit the drawing the toolbar exits ...
    (microsoft.public.publisher)