Creating a macro that updates table fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Fields Problem 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Two more macro questions 6
Field Calculations from Different Tables 1
Update fields when macros are disabled 1
Access Daily Entry with multiple entries per field 0
Auto Update Field Codes without Macros or F9? 1
Access Automatically Send a notification email once a record is added 0

Back
Top