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!
 

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
Auto update fields when opening document, problems. 1

Back
Top