Word and formulas

Tutorials Win: Microsoft Windows Forum

- Previous
  - 1
    - test test Tag: Word and formulas Tag: 69620
  - 2
    - Choose to pick entry Hi everyone, I have a form that I use with many clients. I want to have a section where I can just click to the area where thei Name, Address, etc. can be placed. Possibly it could show just the firs name of the person and I could just click the name and the address an other information could be filled in the area. Anyone that can assist in this, it will be greatly appreciated. Thank you, Crai -- Message posted from http://www.ExcelForum.com Tag: Word and formulas Tag: 69613
  - 3
    - How do I create drop down box in Word I'd like to create a drop down box in a Word table. When I get to the V area, I'm not sure where to type in my list of items to get it to work :confused: Can anyone help me with this? Thanks -- Message posted from http://www.ExcelForum.com Tag: Word and formulas Tag: 69611
  - 4
    - Selecting the right document Private Sub CommandButton1_Click() ActiveDocument.Unprotect WordBasic.MailMergeFindEntry Application.ScreenUpdating = False Windows("SERVICE AGREEMENT (Read-Only)").Activate Selection.WholeStory Selection.Copy Documents.Add DocumentType:=wdNewBlankDocument Selection.PasteAndFormat (wdPasteDefault) Selection.TypeBackspace ActiveDocument.Protect Password:="", NoReset:=False, Type:= _ wdAllowOnlyFormFields Windows("SERVICE AGREEMENT (Read-Only)").Activate ActiveDocument.Protect Password:="", NoReset:=False, Type:= _ wdAllowOnlyFormFields End Sub Okay, here is my script. As you can see after a new document i created the origingal merged document (read-only) is selected t protect it. Now my problem is that although i want "Servic Agreements" protected I want the new document to be showing. Wha would be the script that would allow me to leave the new documen active but still protect 'service agreement' NOTE: Making the new document active after the at the end would no work as there can be several new documents created ie 'document 1' 'document 2' etc. I want the most recent document to be active. Thanks -- Message posted from http://www.ExcelForum.com Tag: Word and formulas Tag: 69609
  - 5
    - test test Tag: Word and formulas Tag: 69603
  - 6
    - Weird message on closing Word This may be related to a recent installation of Norton Anti-Virus because I don't recall seeing it before, but now every time I close Word I get a dialog box asking Do you want to save the changes you made to "Windows In Taskbar.dot"? The options are yes, no or cancel, and I'm saying no because I have no idea what this is. I'm using Word 2000 with Windows 2000 and everything is fully updated. Thanks for any help. Maggie Tag: Word and formulas Tag: 69596
  - 7
    - Favorites gone in 2003 I recently upgraded from Office 2000 to Office 2003. Now whe I open word documents from Word, I no longer have the Favorites folder on the left side of the screen. I can add items to "My Places", but I have many folders in the "My Places" and each is listed individually in the dialog box and scrolling through them is not worth the effort. Is there a way to get the favorites folder back? TIA George Tag: Word and formulas Tag: 69594
  - 8
    - WEB Fields into Word Document Is there a way to enter text fields on a WEB page and then when you click on a SUBMIT button, it places these entered fields onto a preformated Word Document and then sends that document (by email) to a preset email address. Anyone know of any examples or how to perform this task. Many thanks. Steve Tag: Word and formulas Tag: 69591
  - 9
    - What is a 25-character CD code I need to enter? I keep being told that "to use Microsoft Word 2000, please enter your 25-digit CD code". However, as I installed Word from a certified Microsoft Works Package, Product ID 11200-OEM-0047316-65002, i don't know what this code is. Where can i find it? Or can one be sent to me? Tag: Word and formulas Tag: 69589
  - 10
    - Form AutoText Completion I have designed a protected form with fields to be completed. Is there a way that once, say one field is completed, this text is then duplicated in certain other fields. So for example, if you input a name, then this name is then autocompleted in other sections to save entering the details time and time again. Cheers Tag: Word and formulas Tag: 69588
  - 11
    - Email hyperlinks not working I've pretty much posted this everywhere - maybe someone here can help. I'm using Word 2003 as my email editor. When I click on a hyperlink in an incoming email message, it opens Internet Explorer, BUT, nothing comes up. The only way it will open the hyperlink is if another instance of Internet Explorer is open. It is as if the hyperlink is not triggering IE to launch totally. Any ideas? All information will be greatly appreciated. Thanks, Sue Tag: Word and formulas Tag: 69586
  - 12
    - Possible Virus ?? The last few times I have used Word 2002 my work has been interrupted by an error message which, when cancelled, shows that all my work is lost as Word has shut down. The error message is: MICROSOFT VISUAL C++ RUNTIME LIBRARY Runtime Error! Program C:\ ...\ WINWORD.EXE abnormal program termination. I have run Norton Antivirus on the full computer but it found nothing. Can anyone tell me what is happening & how to put it right? -- Many thanks, Robert. Tag: Word and formulas Tag: 69577
  - 13
    - float word art using microsoft word 2002. new dell desktop computer, 2 weeks old. in my old computer, using word 97. when i create a word art box, i am able to drag the box anywhere on the page by holding down the left button & dragging. in word 2002, i cannot do this. the word art box will not drag. is there a setting i can change in word 2002 which will allow it to float on the page? thank you, len kiesling. Tag: Word and formulas Tag: 69576
  - 14
    - Most Recently Used Font List Is there a way to clear this? (Not disable it, just clear it out.) Word 2002, SP3 Thanks. ~ Peri Tag: Word and formulas Tag: 69575
  - 15
    - how do i reinstall microsoft word i have done something to my computer and cannot use word. please help! Tag: Word and formulas Tag: 69568
  - 16
    - Auto-selecting entire fields within a doc? I'm using Word 2002, and this feature seems to have disappeared. As fa back as I can remember, I've been able to easily select an entire fiel displayed in a document by dragging the mouse over the first couple o characters. (Similar to the auto select entire word.) Now it only doe one character at a time. This isn't a big deal until I want to edit the definition for a TOC b highlighting the whole thing and clicking "Edit Field". It doesn' recognize it as a field and I have to recreate the TOC entirely. Is there a setting somewhere for this? I couldn't find it in the Wor options list. I've done a lot of VB customization and I'm wondering i I mistakenly set something through VB. Thanks for any help! Cristin -- Message posted from http://www.ExcelForum.com Tag: Word and formulas Tag: 69565
  - 17
    - Word Form Letter - If - then statements I have created a form letter that pulls information from a loca database and populates the letter. However, I can't figure out how t insert an if-then statement. Example: The letter reads "Dea <<Borrower>>, <<CoBorrower>>" Instead of the comma seperating the two I would like the form to inser the word "and" IF the CoBorrower exists and leave it blank if th CoBorrower does not exist. Can anyone help me with this? Thank you -- Message posted from http://www.ExcelForum.com Tag: Word and formulas Tag: 69563
  - 18
    - Text at 45°C alignment. how I can do any text (in text box or any other way) at 45°C alignmen like Excel. I want to print "By Courier" on upper left corner of a envelop. can anyone help me. Thanks in advance. s kara -- Message posted from http://www.ExcelForum.com Tag: Word and formulas Tag: 69562
  - 19
    - won't copy/ paste Running win98SE with Word97 SR-1. I highlight >Edit>Copy article in OE e-mail, open an existing Word doc and cannot paste the selected text into it (at the end of the doc.). All I get is _0;. We're talking about copying about 6 small paragraphs. This is a doc that I've been adding to weekly in the same manner for over a year. About 243 pages and 550,000 characters so far. Any ideas? Thank you, Steve T. Tag: Word and formulas Tag: 69559
  - 20
    - update resume I am new to Microsoft Word 2003 . And my Question is. How do I install a new work history into my already made resume that I have on file. Tag: Word and formulas Tag: 69555
  - 21
    - Header and footer question When I use the footer feature to put page numbers in a document the font size is 14 instead of 12 like I want it. I then have to select and change it to 12 everytime. How do I get the 12 font to always appear on the document? Tag: Word and formulas Tag: 69554
  - 22
    - Word 2003 for Word 97 User We have been using Word 97 for a couple of years. We have just installed Word 2003 in 2 machines while most of us still using Word 97. We would like to know in order to make our documents compatibitble. What settings should we set up in Word 2003 ? Under Tools --> Save, Should we select "Disable features introduced after Word 97" ? Under Tools --> Compatibility, Should we select "Recommended options for Windows 97" ? OR we don't need to do anything and they (Word 2003 and Word 97 documents) are compatible ? Thanks Tag: Word and formulas Tag: 69552
  - 23
    - fix the enter key problem-mentioned in 187985 PLEASE just have an option for the forms format to ignore enter key when protected Tag: Word and formulas Tag: 69551
  - 24
    - Unable to print Name Tent in Word 2000 using mail merge I've created a mail mailmerge file that prints name tents (the name is sideways on the page, I can fold the page in half lengthwise to make a tent). When I try to print the document from my Dell Computer, it will not print anything at all. When someone else opens the file and selects print, it prints as it should. Why won't my printer print this document? Tag: Word and formulas Tag: 69549
  - 25
    - figuring page x of y Hi Honestly - I seldom use Word, so this might be a overly basic question...So don't laugh ! A document was faxed to me for editing (this doc not available to us electronically) The pages were numbered 1 of 125 to 125 of 125. However, corrections weren't required on all the pages. How do I use the x of y pages in the footer, but with numbers of my choosing, e.g.; 2 of 125, then 8 of 125, 15 of 125, etc. I want to email the finished product back, without blank pages. Thanks -- Chi dara fine al gran dolore? L'ore. Tag: Word and formulas Tag: 69548
- Next
  - 1
    - division mark how do i insert a division mark. eg. 12 (divided by) 2 Tag: Word and formulas Tag: 69547
  - 2
    - can I put my own pictures on calander 2005, and do I need word 20. Tag: Word and formulas Tag: 69544
  - 3
    - aspx files I have been trying to use files obtained from a VA database as downloded to either XP Professional MSword or Excel. The files are always wrapped to 2 rows of columns. How can I unwrap the colums into a single line so that I can editthe files? I have querried the National Service Specialists at VA Central in Washington and they tell me that the downloaded files are useless for other than printing. Can anyone help? Thanks cspoonerr@yahoo.com Clay Tag: Word and formulas Tag: 69542
  - 4
    - Want to invert text I have a daily diary in a word document. January first is at the top of the document and the latest date at the end. I would like to invert it putting the latest date and the top and January first at the end. Is there a way to do this? Tag: Word and formulas Tag: 69534
  - 5
    - Word lists (as opposed to word count) Is there a facility to list all the words used in a Word document? I don't need to know the word length but the vocabulary list of any given piece of text. Frequency of occurence would be useful but not essential. It would not need to be used with a dictionary or spell-checker, but simply to list every different combination of letters separated by spaces. This would mean I could find out what sort of language complexity a text has in any language by knowing which words it uses (useful both in my capacity as a language teacher and a language learner). If there is no such function in Word, are there any commercially available programs on the market that do this? ***************************************** * This message was posted via http://www.officekb.com * * Report spam or abuse by clicking the following URL: * http://www.officekb.com/Uwe/Abuse.aspx?aid=8497f874a12c4950a0c30bcbab66b7c0 ***************************************** Tag: Word and formulas Tag: 69533
  - 6
    - Microsoft Works 7.0 - highlighting text I find Microsoft works much different than the Microsoft word - How do I highlight text (not the paragraph) in a document? - If I send a file (say, file.wps) which is in Microsoft works format to a person using Microsoft word (version 2000 or earlier), can he/she open this file? - If I want to install Microsoft word, is it possible? where do I download it from? link please. I think Works does not have Index and galleries option in word. true? Many thanks. Sunil Tag: Word and formulas Tag: 69525
  - 7
    - How do you set a backround Tag: Word and formulas Tag: 69524
  - 8
    - In need of a brief summary of my job description and have no idea. I am in need of an idea on how to write a brief, but professional description of my job field and skills. Can anyone help? Tag: Word and formulas Tag: 69520
  - 9
    - FlashCards How can you use Word 2003 or any office products to create printable flash cards Tag: Word and formulas Tag: 69516
  - 10
    - My page setup in File doesn't work. I need to reconfigure Microsoft Word & MS Works 2002 so that I have Page Setup available so that I can reset page margins, etc. What did I do to screw this option from not being available? And how can I correct this problem? Tag: Word and formulas Tag: 69515
  - 11
    - Page orientation. Change to landscape inWorks 7word processor When I change page layout from portrait to landscape and click o.k, error message comes up for the default height measurement "invalid measurement. should be between %0 and ????". I find this simple change most frustrating. Can any one help? Tag: Word and formulas Tag: 69510
  - 12
    - word table auto format when I bold a single cell in a word table...i assume it is the autoformat function that takes over...but the whole table is bolded...how do I stop this Tag: Word and formulas Tag: 69504
  - 13
    - Drop down menus When adding drop downs to a form can you format it so that the drop down arrow does not print? Tag: Word and formulas Tag: 69503
  - 14
    - print grid in calendar using windows xp pro, sp2, with microsoft office 2002. i'm trying to print the grid lines in the calendar created in calendar wizard. i used to be able to do it in word 97, but i'm unsucessful with word 2002. how do you print the grid in calander? thank you, len kiesling Tag: Word and formulas Tag: 69502
  - 15
    - how to get rid of license agreement on start of office applicatio. Everytime I start an office application, a license agreement pops up. I am using office 2003 small business edition. Tag: Word and formulas Tag: 69496
  - 16
    - File - Open - takes a really long time! Hello, I am using Office 2003. When I try to open a file, the open file dialog comes up and when I click the drop down arrow in the Look In: field, it takes a minute or two for the directory list to drop down. It never used to take this long; however, recently, a dialog popped up and said something about indexing or searching (I didn't read it very closely - but clicked the OK button), then the next thing I know, every time I try to open a file, it takes forever to get the directory list. Any idea how to turn this feature OFF. Thanks for any suggestions. -- TLF Tag: Word and formulas Tag: 69492
  - 17
    - Field Code issue in printing comments Hi I am printing a doc in W2000, and for some reason some of the comments on the last page show the page number before the comment entry text, and the remainer don't. I have tracked this to a field code issue, however cannot find how to resolve it to make them all the same. I actually want to print the page number preceding each comment, so assume that the field code is somehow responsible for this. I did not do anything deliberately to turn the code on to make some of the comments display page numbers and others no to. I have tried Shift + F9 on the comments not displaying the page number however it has not worked. Appreciate advice on how to include the page number before each comment when I print the comments page out. Bill --- Message posted from http://www.ExcelForum.com/ Tag: Word and formulas Tag: 69491
  - 18
    - grid in WORD I am not sure which group is more appropriate, so I'll post it here and in the doc management group: I teach mathematics. I type my math tests on WORD 97 (I use it in conjunction with MATh Type). Is there a way to incorporate a small grid on my tests (for graphing problems)? I know on the bottom of the screen if I click on Draw I can then choose grid and it asks for some settings. But I don't know how to put a grid in my document and I can't seem to find it in the Help Index. Currently, I made a grid on a MS WORKS spreadsheet and I can copy and paste, but I would like to do it in WORD. (I can also create one in Geometer's Sketchpad and do the same) Any ideas? I must be missing something simple. Mel Tag: Word and formulas Tag: 69486
  - 19
    - file path in title bar possible? Word 2002 Is it possible to have Word 2002 display the path to the folder opened up in Word? How? TIA Tag: Word and formulas Tag: 69485
  - 20
    - my word document is in symbols instead of English im having trouble changing my word files into english so that i can read them when i download something. it always comes up in symbols of some sort. Tag: Word and formulas Tag: 69481
  - 21
    - my word document is in symbols instead of English im having trouble changing my word files into english so that i can read them when i download something. it always comes up in symbols of some sort. Tag: Word and formulas Tag: 69480
  - 22
    - Data Sorting Hello from Steved I have Headings (A1) How do I get word to sort on Name A1 please. Thankyou. Tag: Word and formulas Tag: 69469
  - 23
    - Is there any easy way to delete a selected doc section? In the old days, we could easily select a few words or a section in the Microsoft Word and hit the 'Delete' button and the selected portion of the document would vanish. Is there any easy way to setup the Microsoft Word XP to do the same? Appreciate help. Tag: Word and formulas Tag: 69464
  - 24
    - icons in word I wanted to add a toolbar button for "Paste-Special-Unformatted" text, but according to Word Help, "Some commands don't have icons associated with them and can only be displayed as text" Is there a work-around? Tag: Word and formulas Tag: 69458
  - 25
    - correction by syntax Are ony of the word processors set to make corrections by syntax? Tag: Word and formulas Tag: 69457

Is Word able to use formulas on a form, like to ones in Excel, to return
values on the same docuement?

RE: Word and formulas by Greg

Greg
Thu Nov 04 07:59:02 CST 2004

Andrew,

Sure. If you are using a protected form, you can use expressions in
calculation type formfield. Insert the fiedl, double click and change type
to calculation. You must also set each variable field to calculate on exit
(double click each field and select calculate on exit).

If you are using a non-protected document as a form then you can simply add
formula fields. Type "formula field" in Word help for tips to get you
started.

"ANDREW MC" wrote:

> Is Word able to use formulas on a form, like to ones in Excel, to return
> values on the same docuement?
>
>
>

Re: Word and formulas by macropod

macropod
Thu Nov 04 15:29:51 CST 2004

Hi Andrew,

For a 'tutorial' with examples of how you can use formulae in Word, download
the Word document at:
www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=365442
(url all one line)

Cheers

"ANDREW MC" <QWERTY@AOL.COM> wrote in message
news:uTHmhDnwEHA.2624@TK2MSFTNGP11.phx.gbl...
> Is Word able to use formulas on a form, like to ones in Excel, to return
> values on the same docuement?
>
>

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.778 / Virus Database: 525 - Release Date: 15/10/2004