Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-17-2012, 07:34 AM
PMR PMR is offline Allow user to add rows to Word '03 table....how? Windows XP Allow user to add rows to Word '03 table....how? Office 2003
Novice
Allow user to add rows to Word '03 table....how?
 
Join Date: May 2012
Posts: 2
PMR is on a distinguished road
Default Allow user to add rows to Word '03 table....how?

I have a form which includes an 8 column table, each cell in the row has a Text Form Field with various lengths/output formats. My problems are two fold:



1) I need to allow users to insert additional rows if needed, the new row needs to contain the same empty Text Form Fields and I cant for life of me figure out how to do this.

2) I need to auto sum one of the columns by adding the bookmarks for each cell above in that column....if users add additional rows I'm lost.....

I've created a similar form for a similar purpose but that form has a fixed number of rows. I was unable to use {=SUM(ABOVE)} as some cells may remain blank. Adding default values to the cells was unacceptable for end users, so I went with blanks and writing an excessively long formula to add 15 bookmarks. Bulky and complicated, but it works...

I suppose users would need to make some condition "True" (entering "Y" in a Text Field, clicking a button, something) and then have the new row appear, 1 row per one click.

Any suggestions are greatly appreciated.

PMR
Reply With Quote
  #2  
Old 05-17-2012, 05:03 PM
macropod's Avatar
macropod macropod is offline Allow user to add rows to Word '03 table....how? Windows 7 64bit Allow user to add rows to Word '03 table....how? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

See 'Add a row to a table in a protected form' at: http://www.gmayor.com/word_vba_examples.htm
For the summing problem, perhaps the simplest solution is to split the table (which will also make it easier to add the new rows), bookmark it, then use a formula field coded like:
{=SUM(MyTable C:C)}
where 'MyTable' is the bookmark name and 'C' is the column you want to sum.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-18-2012, 06:16 AM
PMR PMR is offline Allow user to add rows to Word '03 table....how? Windows XP Allow user to add rows to Word '03 table....how? Office 2003
Novice
Allow user to add rows to Word '03 table....how?
 
Join Date: May 2012
Posts: 2
PMR is on a distinguished road
Default

Thank you, sir! I've been searching Word/Window forums for nearly a week, I don't know how I managed to not find that thread before. Also, thanks for the split table/code field advice, it is truly appreciated. I've actually read dozens of your replies to other users, when I saw your name in the response e-mail I read this morning, I was pleased knowing I would receive a helpful reply instead of another "I don't know how to answer your question so I would do something else...." answer that I've been getting elsewhere.

Thanks again!
Reply With Quote
Reply

Tags
conditional, insert row, tables



Similar Threads
Thread Thread Starter Forum Replies Last Post
Allow user to add rows to Word '03 table....how? Odd behaviour of table - keep rows together Stephan Lindner Word Tables 1 09-10-2011 05:31 AM
Allow user to add rows to Word '03 table....how? adding rows to word table hklein Word VBA 4 07-18-2011 12:21 AM
Allow user to add rows to Word '03 table....how? Fixing number or rows in a table burnsie Word 2 07-12-2011 02:59 AM
Repeating table rows in template? TheWedgie Word 0 09-11-2010 09:35 PM
Help Autoformating a Table w 2 header rows Julie713 Word Tables 0 03-01-2010 08:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:17 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft