If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating a macro that updates table fields
I have a table within a form that users will input numbers into. In several
fields, I have a sum calculation that sums the user's input. I know the fileds will not update automatically (too bad). I would like the users to either 1) hit a button that updates the fields for them or 2) the fields update when the document is closed with an "autoclose" macro. Questions: 1) can I assign a macro that updates the sums to a "floating button or image" within the document? 2) how do I create an "autoclose" macro? Thank you! |
#2
|
|||
|
|||
If this is an online form set the properties of the form fields involved in
the calculation to 'calculate on exit'. Code to update fields and how to employ it can be found at http://www.gmayor.com/installing_macro.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Gail wrote: I have a table within a form that users will input numbers into. In several fields, I have a sum calculation that sums the user's input. I know the fields will not update automatically (too bad). I would like the users to either 1) hit a button that updates the fields for them or 2) the fields update when the document is closed with an "autoclose" macro. Questions: 1) can I assign a macro that updates the sums to a "floating button or image" within the document? 2) how do I create an "autoclose" macro? Thank you! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Unable to edit records in a form or query | Merlin | Using Forms | 7 | May 10th, 2005 02:00 PM |
Access combo box-show name, not ID, in table? | write on | New Users | 30 | April 30th, 2005 09:11 PM |
Many-to-many implementation problem | Al Williams | Database Design | 15 | April 29th, 2005 05:19 PM |
Seeking some expert advice. | HD87glide | Using Forms | 14 | March 23rd, 2005 10:11 PM |
Autonumber | Ally H. | General Discussion | 7 | August 27th, 2004 04:51 PM |