Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 09-17-2014, 11:35 AM
regwitt regwitt is offline Form auto fill based on a different field value. Windows 7 32bit Form auto fill based on a different field value. Office 2010 32bit
Novice
 
Join Date: Sep 2014
Location: Columbus, IN
Posts: 11
regwitt is on a distinguished road
Default I believe this might work.

Quote:
Originally Posted by macropod View Post
Given that all the fields are the same, why not just bookmark the first one, then insert cross-references to that one bookmark? You certainly don't need to bookmark every field. Indeed, you don't need to bookmark any of them if all you're going to do is replicate the formula field wherever you want the output repeated.



Now, suppose you bookmark just the first instance, with 'RPM' as the bookmark name. In that case, wherever you want the same results to appear, simply insert a cross-reference to the RPM bookmark. Done.

To output the RPM +/- 10, simply use another formula field, coded as:
{=RPM+10}
or:
{=RPM-10}


I believe this will work for me, but I'm having trouble picturing what you mean by, "To output the RPM +/- 10, simply use another formula field, coded as:
{=RPM+10}
or:
{=RPM-10}[/quote]".

Would you mind please elaborating or showing me an example?

Thanks again! Your help is appreciated!
Reply With Quote
  #17  
Old 09-17-2014, 01:10 PM
Charles Kenyon Charles Kenyon is online now Form auto fill based on a different field value. Windows 7 64bit Form auto fill based on a different field value. Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,083
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

He did show you an example. The fields that start with = are formula or calculation fields.
Reply With Quote
  #18  
Old 09-17-2014, 02:59 PM
regwitt regwitt is offline Form auto fill based on a different field value. Windows 7 32bit Form auto fill based on a different field value. Office 2010 32bit
Novice
 
Join Date: Sep 2014
Location: Columbus, IN
Posts: 11
regwitt is on a distinguished road
Default Error message!

Quote:
Originally Posted by Charles Kenyon View Post
He did show you an example. The fields that start with = are formula or calculation fields.
Then why do I repetedly get an error message? Guessing your responce will be, "you're doing it wrong". Hense the request for said example.

Do I need to add something like this, {=RPM+10\# "0000 rpm"}, without referencing anything? This, {=RPM+10}, gives me an error.
Reply With Quote
  #19  
Old 09-17-2014, 04:01 PM
macropod's Avatar
macropod macropod is offline Form auto fill based on a different field value. Windows 7 64bit Form auto fill based on a different field value. Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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 attached.
Attached Files
File Type: doc EngineDemo.doc (37.5 KB, 45 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #20  
Old 09-18-2014, 05:25 AM
regwitt regwitt is offline Form auto fill based on a different field value. Windows 7 32bit Form auto fill based on a different field value. Office 2010 32bit
Novice
 
Join Date: Sep 2014
Location: Columbus, IN
Posts: 11
regwitt is on a distinguished road
Default Thanks!

Quote:
Originally Posted by macropod View Post
See attached.
I really appreciate the help. One more thing.....

Is it possible to not have the 10's show up. It would be ideal to have that place blank when there isn't a product chosen.
Reply With Quote
  #21  
Old 09-18-2014, 05:43 AM
macropod's Avatar
macropod macropod is offline Form auto fill based on a different field value. Windows 7 64bit Form auto fill based on a different field value. Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

You could change the:
{=RPM+10}
and:
{=RPM-10}
field codes to:
{=(RPM>0)*(RPM-10) \# 0}
and:
{=(RPM>0)*(RPM+10) \# 0}
respectively. This will cause them to display 0s while ever the RPM field is empty. To suppress even the 0s, change the final 0 in each field to:
"0;;"
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #22  
Old 09-18-2014, 06:26 AM
regwitt regwitt is offline Form auto fill based on a different field value. Windows 7 32bit Form auto fill based on a different field value. Office 2010 32bit
Novice
 
Join Date: Sep 2014
Location: Columbus, IN
Posts: 11
regwitt is on a distinguished road
Default You are the man!

Quote:
Originally Posted by macropod View Post
You could change the:
{=RPM+10}
and:
{=RPM-10}
field codes to:
{=(RPM>0)*(RPM-10) \# 0}
and:
{=(RPM>0)*(RPM+10) \# 0}
respectively. This will cause them to display 0s while ever the RPM field is empty. To suppress even the 0s, change the final 0 in each field to:
"0;;"
That worked beautifully! Is there a book that you might recommend that I might use as a reference so I don't have to bug you guys all the time? My next project is to have a link within the document the user will click on that will search our database for a specific .map file, then search that file for specific parameters. I really like to read books that i can reference in the future.

Again, Thanks a million!!!!
Reply With Quote
  #23  
Old 09-18-2014, 07:52 AM
macropod's Avatar
macropod macropod is offline Form auto fill based on a different field value. Windows 7 64bit Form auto fill based on a different field value. Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

You won't find any books that go into field coding in much detail. I did contribute to one some years ago (Word Hacks, by A Savikas, published by O'Reilly Media in 2005 (Word Hacks - O'Reilly Media)) but even that doesn't cover anywhere near as much as the tutorials I've written on the subject. Indeed, my tutorials probably contain more detail than you'd find in all the books you could buy on the subject.

To start with, check out my Mailmerge Tips & Tricks:
https://www.msofficeforums.com/mail-...ps-tricks.html

To see how to do a wide range of calculations in Word, check out my Microsoft Word Field Maths Tutorial:
https://www.msofficeforums.com/word/...-tutorial.html

To see how to just about else you might want to do with dates in Word, check out my Microsoft Word Date Calculation Tutorial, at:
https://www.msofficeforums.com/word/...-tutorial.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #24  
Old 09-22-2014, 11:18 AM
regwitt regwitt is offline Form auto fill based on a different field value. Windows 7 32bit Form auto fill based on a different field value. Office 2010 32bit
Novice
 
Join Date: Sep 2014
Location: Columbus, IN
Posts: 11
regwitt is on a distinguished road
Default Cross-References

I'm having trouble with cross references. They used to show up in the middle of a sentence at the very most three dots.

Now I'm getting around 25 or so dots and it's causing huge formatting issues. Is there a way to change this?

I have a line later on in the document referencing a drop down choice:

Selected _Product_ID. ___________

It's pushing everything off the page and really looks horrible. I thought it might be a setting in options, but I couldn't find anything to do with cross references.

Thanks in advance!
Reply With Quote
  #25  
Old 09-22-2014, 02:28 PM
macropod's Avatar
macropod macropod is offline Form auto fill based on a different field value. Windows 7 64bit Form auto fill based on a different field value. Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

The only reason that would occur is because whatever you're cross-referencing has the same setup.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #26  
Old 06-15-2019, 12:27 PM
jhansrod jhansrod is offline Form auto fill based on a different field value. Windows 10 Form auto fill based on a different field value. Office 2016
Novice
 
Join Date: Jun 2019
Posts: 16
jhansrod is on a distinguished road
Default

Hi Macropod

The attached example is a great starting point for another idea you have given me.

Instead of assigning a value to Code or Location, can it be set to be a text input field ?

Thank you
J
Reply With Quote
  #27  
Old 06-15-2019, 04:08 PM
macropod's Avatar
macropod macropod is offline Form auto fill based on a different field value. Windows 7 64bit Form auto fill based on a different field value. Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

I'm not sure what you mean - the document already contains two dropdowns for data selection. Although a text formfield could be used for the input, that introduces the possibility of the input being invalid for any number of reasons and, hence, not being amenable for generation of the output.

I nay event, your other threads have all concerned the use of content controls, not formfields, and content controls & formfields should not be used in the same document. They weren't designed to be used that way and trying to do so is a known source of problems.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
MACRO - Insert row based on Form Field Criteria Elan05 Word VBA 5 04-16-2013 06:39 AM
Form auto fill based on a different field value. Nested if field that contains a fill-in field is not prompting for fill-in info Nccadm Mail Merge 2 04-02-2013 03:15 AM
Form file timesheet, auto fill date from calander jkeeney Word 1 03-21-2012 12:21 AM
Macro to populate a text form field based on dropdown selection koloa Word 0 10-20-2011 11:52 AM
Form auto fill based on a different field value. How can I fill in form I received in email that used underlines instead of text field Gail L. Word 2 05-17-2009 12:38 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:11 PM.


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