Over 1 million tech questions and answers.

Creating dynamic hyperlinks in Word - embedding fields inside fields using VB

Q: Creating dynamic hyperlinks in Word - embedding fields inside fields using VB

I am trying to create links to specific locations with each document between two documents. The document names will change. I can update the current name of the other document by creating a custom property called "otherDoc". I have solved most problems, however, I am unable to insert a field into the address of the link (to make the link dynamic) without utilizing the showfieldcodes command (which is very memory and time consuming since the documents I am working on are very large). Below is my code. I was wondering if there is any way to set the address as a field? Or somehow input an address and it would be understood by word to be field.
Sub link_to_other()

'pastes hyperlink to the other document
Selection.PasteSpecial Link:=True, DataType:=wdPasteHyperlink, Placement:= _
wdInLine, DisplayAsIcon:=False

'selects the hyperlink that was just inserted
Set myField = Selection.PreviousField

'creates variables
Dim temp_address As String
Dim temp_subaddress As String

'sets variables
temp_address = ActiveDocument.CustomDocumentProperties("otherDoc").Value & ".doc"
temp_subaddress = Selection.Range.Hyperlinks(1).SubAddress

'changes the hyperlink the the dynamic value
Set SCut = ActiveDocument.Hyperlinks.Add( _
Anchor:=Selection.Range, _
Address:=temp_address, SubAddress:=temp_subaddress)
End Sub

Read other answers
RELEVANCY SCORE 200
Preferred Solution: Creating dynamic hyperlinks in Word - embedding fields inside fields using VB

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

RELEVANCY SCORE 109.2

Hello.

I am trying to create a contract template for our lawn care business. There are 22 different services that our customers can choose to add, each with a price specific to their own property. At the bottom of the service and pricing list there is a "sub-total" line, with a "5% discount" line underneath, and under that the "total" line.

Like so:

weekly lawn maintenance $35.00 Is there a way to "make" these numbers add up, and
Shrub trimming $150.00 appear in the areas below? So that we don't have to
Fertilization $35.00 manually do all of the calculations, thereby saving
ourselves literally days of work.​Sub-total $220.00
5% discount $11.00
Total $209.00

Also, on the contract we have payment options for our customers. Another big time consumer has been manually calculating these options.

Like so:

$209.00 payable at a flat rate over 9 months (March through November) = $23.22/month
If I can get the "total" number from above to automatically calculate and "jump" to the figures in red above, that would be simply wonderful.

I know that in excel the calculations can be done by creating a spreadsheet (although I do not know how to make a spreadsheet), but I this contract is a legal document and needs to appear so. I'm hoping that Word has a way to do this as well.

FYI, I tried to upload the document but for some reason the only way I can get to the template is if I want to create a docum... Read more

A:Help creating automatically calculating fields in word 2007

Read other 6 answers
RELEVANCY SCORE 97.6

Hi pro,
I have two fields, one called [value] and the other called [scores], I want to link them together. The field [value] has multible choice record and in form of dropdown, for example, Yes/No, or numeric values such as 0-10,10-20....). Each choice will be having different score value. For example (yes) will have score '1' and (No) will have '0' score.I do this links in
excel but in Access I don't know the format how it's work , so please
could you tell me how I can do't.
Thanks.
Rona
 

A:link two dynamic fields together.

Read other 6 answers
RELEVANCY SCORE 97.6

Hi all,

I?m really in need of some help from some Access experts! I?m a newbie to Access, but I got myself busy with quite a big project... I?m trying to map out the product supply to shops in the whole country. I?ve come quite far for a starter, but I keep having 3 questions, it would be great if you could help me with this!

I have, amongst other tables, two tables called Stock_counted and Reported_quantity.

The table Stock_counted has the following fields:
- Shop_number
- Product_code
- Quantity_counted

The table Reported_quantity has the following fields:
- Shop_number
- Product_code
- Quantity_in
- Quantity_lost_or_returned
- Quantity_out

1. What I would like to do is to make it one table based on Shop_number AND Product_code. So in one record I would like to have Shop_number, Product_code, Quantity_in, Quantity_lost_or_returned, Quantity_out and Quantity_counted. How do I do this, making sure that the quantities end up behind the right product and shop? It is possible that some shops don?t have all items, while other shops might not have all products reported, or both. On top of that, I have another table with a price for each product, which needs to be related to it as well.

2. It happens that some products are found more than once in one specific shop and therefore appear more than once in the table, with the same shop number and product code. How do I automatically SUM these quantities, so that this product only shows up once per shop?

3.... Read more

A:How to combine fields in Access 2010 based on 2 equal fields?

  
Quote: Originally Posted by Josephine87



2. It happens that some products are found more than once in one specific shop and therefore appear more than once in the table, with the same shop number and product code. How do I automatically SUM these quantities, so that this product only shows up once per shop?



select shop, product, sum(quantityfield1), sum(quantityfield2)
from sometable
group by shop, product

Read other 1 answers
RELEVANCY SCORE 94.4

Hello everyone,

I've been reading in this board for a while, but I felt the need to take action as well now because of a problem I have been experiencing for some time now.

I am using Windows 7 Professional 64-bit and in some applications (e.g.: Windows Notepad, Registry Editor, Task Manager), I experience extreme flickering of some window elements. For example, when trying to resize the column sizes on top of the values in the registry editor, the text flickers constantly while pulling them with the mouse. A similar effect occurs sometimes with the mouse pointer when I'm trying to rename files in the explorer, especially while trying to rename elements in the favorites list on the left - the pointer seems to disappear randomly when any key is pressed, but not every single time I press a key. Also, the tabs in the task manager will flicker when trying to resize the window while in the "performance" tab.

This does not only happen with windows applications, also with other programs. I am a media design student and similar flickering occurs in the UI of Adobe InDesign while typing (the font-size selection boxes on top and the color-picker randomly start to flash white or disappear for a fraction of a second and then just reappar while typing). Other programs however show no signs of this issue at all, for example Firefox, Winamp, LibreOffice or any games I have tested so far.

I have done many searches for a solution to this problem, but could not find an answer yet... Read more

Read other answers
RELEVANCY SCORE 90.4

This is how the DB looks like:

tbl 1
ID Name
123 XYZ
145 ABC

tbl 2
ID Docs
123 Paper 1
123 Paper 2
123 Paper 3
145 Paper 1
145 Paper 2

I am trying to build a query that works with Mail merge in Word that returns:
ID Docs
123 Paper 1, Paper 2, Paper 3
145 Paper 1, Paper 2

I have managed to do this with VB and it works very well but it gives me "An error has ocurred, undefined function" when i open word to mail merge.

Can you help me, guys ? I'm kinda stuck here.
Thank you!
 

A:Creating a query with concatenated fields in Access

Read other 12 answers
RELEVANCY SCORE 88.4

Hi,

I got a form A and a subform B. I use B to display data retrieved from a table while use B to simutaneously update that data. More particularly, if I click a row in B, that row will be display on A and the user will be able to edit that data. The forms were designed by someone in MS Access 97. I converted it to MS Access 2003 format. Therefore, I have to link form A and form B. However, I couldn't find Link Master Fields and Link Child Fields in MS Access 2003!

Any ideas? Thanks in advance!
 

A:Link Child Fields and Link Master Fields in MS Access 2003

climbingrose said:

Hi,

I got a form A and a subform B. I use B to display data retrieved from a table while use B to simutaneously update that data. More particularly, if I click a row in B, that row will be display on A and the user will be able to edit that data. The forms were designed by someone in MS Access 97. I converted it to MS Access 2003 format. Therefore, I have to link form A and form B. However, I couldn't find Link Master Fields and Link Child Fields in MS Access 2003!

Any ideas? Thanks in advance!Click to expand...

It really sounds like form A and subform B are both using the same table, and are not a Master/Child field link situation. But rather, form B (the subform) will have code in the "On Current" event that will find the current record on the form B within the form A, therefore allowing that record to be edited. Review your original post, I think you used the "B" one place where you meant to say "A". No matter what, you need to clear up with us out here if both form A and form B are using the same table.

Vic
 

Read other 1 answers
RELEVANCY SCORE 87.6

Can anyone tell me how to setup a field in a word templet/form that will auto fill in another field when the data is entered. I would like to type in the name field and have it fill in the same name in all the name fields on the form. I would appreciate any help you can give. Thanks..
 

A:MS WORD fields

You can use "Reference" (REF) form fields to accomplish what you want. I will give you the basic steps of creating one and you'll have to play around with it on your own to learn the rest.
Click VIEW--> TOOLBARS --> FORMS

From the Forms Toolbar insert a text form field by clicking the button labeled ab Double click the newly inserted field and check the box marked "Calculate on Exit." Make note of the bookmark name that is assigned to this newly inserted field (By default it will be named Text1, Text2, etc)

After inserting text form field hit enter several times to move down a few lines in the document.

From file menu across the top of your document click INSERT--> FIELD. Choose the category "Links and Reference" and choose field name "REF." Next click the options button and from the Bookmark listbox select the bookmark name that you want this new field to reference. With the bookmark name highlighted click the "Field Codes" button and make sure the proper reference has been set it should say something like REF Text1. Click OK to create the reference. Now protect the form document by clicking TOOLS --> PROTECT DOCUMENT --> FORMS. Now type some text into the first field you added and click TAB. You will now see that whatever text you type in the first form field will also appear in the newly added refererence field. Hope this helps!

Rollin
 

Read other 2 answers
RELEVANCY SCORE 86.8

Hey there folks! I had an issue with clearing fields and that was resolved but the resolution presented another problem. A problem which I have been unsuccessful in resolving on my own.

I have tried about 3 different methods using command buttons and the VBE but nothing is working.

I need 2 buttons: One to clear all form fields and one to clear all form fields then close the form.

I know how to make a button to close a form but I am unable to make it clear the fields prior to closing. I have also been unsuccessful in creating a button to simply clear the form fields.

Any help is greatly appreciated.

Jason
 

A:Solved: MS Access 2007: Creating a 'Clear All Form Fields' button that actually works

Read other 11 answers
RELEVANCY SCORE 86.8

Hey folks,

Just an idle productivity question.

Assuming I wish to key in the name "John Doe" in the beginning of a contract document as a field and have the same name reappear in other fields within that same document, is this possible at all via MS Word 2000 independent of another supporting merge document?

Or am I restricted to the merge feature alone where I require another MS Word document with tables or an MS Excel table?

Thanks.

Mr Al-B
 

A:MS Word 2000 and Use of Fields

Hi, welcome to the board. Haven't done this for a year, maybe 2. Here's one method I've used before. (?How would you key in as a field?)

First type it in, then select it (the whole string), then Insert a Bookmark. Throughout the doc, you can then Insert -- Field(s) (Category = Links & Refs, Field names = Ref). In the Field codes text box you'll need "REF Name", where Name = the name of the bookmark you inserted. You may want to turn on "Show Bookmarks" in the doc (Tools -- Options -- View) to make editing the actual bookmark easier, when required.

The Ref fields should update automatically when you print ; if not, CTRL+A to select the whole doc, then rightclick one of them & "Update Field".

HTH,
Andy
 

Read other 3 answers
RELEVANCY SCORE 86.8

Hi - I am not a complete beginner but am having terrible trouble using basic fields. All I want to do is create a template with variable Fields ie I use Ctrl+F9 to insert a field and then type in something like "Insert Name" etc. I need to be able to print the document showing the fields - I go into Printer Options - Advanced - Print Section - tick "Print Fields Codes instead of their values". This works but when I go back into my document it comes up with "Error! Bookmark not Defined". What am I doing wrong and can anyone help me fix this without going into anything too complex.

Thank you
Macky65
 

Read other answers
RELEVANCY SCORE 86.8

I have made a template form on Word 2003 that uses many fill in text fields. I would like to have the information inserted on some of these fields to show on other parts of the same document without having to entered a again. So the question is how I ref a field in word to show the same information over again. Have it entered once and show in many parts. Please help.
 

A:Word Fields Automation

I would think you could edit the document and insert a new field and in that field refer to an exisitng field name then the data from that field would populate , Word 2007 go to mailings tab>Write&Inseert Fileds Select Insert Merge Field
 

Read other 2 answers
RELEVANCY SCORE 86.8

i have created a form in word, adn i want it to be read only for most of the form. However, i do want certain fields to allow users to type in. Is there any way that i can easily do this. i know that this may seem kind of vague, let me know if you need any other info.
 

A:MS Word; only type in certain fields

[edit]
Too bad there's not a strikethrough text format. Anyway, ignore the stuff in red.

This is a common question that has no easy answer. There is no way to permanently lock the text of a document while leaving the fields open. There are some workarounds, such as using a background graphic instead of body text.

I don't know what I was thinking about when I wrote that, but it wasn't forms. It might have been converting a PDF document to a protected Word form. Another of Dreamboat's articles.
[/edit]

If you search the forums for something like Word form protect text, you might get some hits. The question gets worded differently from time to time, so play around with the search criteria until you get a thread that works for you.

Here are a couple of similar threads (searching word form lock text):

http://forums.techguy.org/t389564
http://forums.techguy.org/t159508

And here's a link with some general info. Thanks to Dreamboat for that.

Sorry.

chris.
 

Read other 3 answers
RELEVANCY SCORE 86.8

In Word, there are some auto-correct fields that I have changed. When I do that, some of them stay saved, but some won't stay changed.

I changed it so that 2 hyphens instantly becomes a dash instead of waiting until I type the next word; that change stays. I changed the ... to become . . . because that is required in academic writing; that change stays.

But some changes won't stay. Right now, --> becomes an arror. I want -> to become an arrow because the -- before the > automatically becomes a dash. I make the change, but the next time I go into Word, the change is gone. I cannot seem to get it to stay. Anybody know why?

Also, there are many auto-suggestion replacements that I like, but there is one that I really don't like. When I type 2005 in a document, it automatically suggests 2005-09-04 and replaces it if I hit enter. I NEVER use that format for dates, but I often am doing a form where I need to be able to hit enter after I put in the year. I cannot find a way to remove this one date field without disabling all the others.

Help!
 

Read other answers
RELEVANCY SCORE 86.8

I use fields in my Word document. Is ther some way to update these automaticly. At the moment I'm going thru the document and doing it one at a time.
 

A:Update fields in Word

Have you tried F(?

The following id from the Help within Worf 2007.
Function key reference
Function keys
To do this Press
Get Help or visit Microsoft Office Online. F1
Move text or graphics. F2
Repeat the last action. F4
Choose the Go To command (Home tab). F5
Go to the next pane or frame. F6
Choose the Spelling command (Review tab). F7
Extend a selection. F8
Update the selected fields. F9
Show KeyTips. F10
Go to the next field. F11
Choose the Save As command (Microsoft Office Button ).
 

Read other 2 answers
RELEVANCY SCORE 86.8

Hi, recently I was asked to produce a document format, that once opened had a pop-up that prompted the user for information....eg. company name, address etc. and this information is then to be inserted throughout the document wherever applicable.

I used FILLIN fields, but these dont allow the information to be reused throughout a document. I then used ASK fields and assigned the promted response to a bookmark, which i then referenced throughout the document. This however, has another problem in not automatically updating the field (and therefore asking for information to be entered) when the template is opened. I got around this by setting up a macro to update all fields by pressing F2 when the file is opened.

The guy I made the document said its ok, but basically now he wants just ONE popup with all the fields to be entered in the file to come up at once, like a popup form, rather than one by one, and having to press the OK button for each peice of information.

Can anyone help me create this popup form?? with references to be inserted once it is filled in??? i know this one is a big ask!! Who is king?
 

A:Microsoft Word: Help with fields!

Read other 6 answers
RELEVANCY SCORE 86.8

Hello..I just discovered this place

I am writing up a legal doc. in Word. I know how to protect the document, however I need to UNPROTECT 3 lines (to allow date, name and address). Is there a way to only make those 3 fields (created with FORM) unprotected?

TIA Anyone
 

A:Need Help with Protecting Fields in Word

I'm not an expert at Word, but I believe if these are text form fields (from your forms toolbar), when you protect your document ONLY those form fields will be able to be edited. Everything else will be protected, which is, I believe, what you want. However, when the document is unprotected, you CANNOT enter or edit text in those fields.
 

Read other 1 answers
RELEVANCY SCORE 86.8

I have created a form in word, and there are two locations on the form where the project number needs to be entered, is there a way to link the fields so that the number, when entered in the first field will also show up the second field?
 

Read other answers
RELEVANCY SCORE 86.8

I have created a mail merge document in Word that also incorporates several word fields ( ask, if..then..else ) The primary document includes an If..then..else field that calls for IncludeText of another document. Within that document are more ask and if..then..else statements. In the final merge, Word asks the Ask fields twice...even though I have checked the ask once box and am only merging to one record. Any ideas on what I have done wrong? I have been working in both Word 2000 and Word 2002.
 

A:Problem with Word fields

Read other 6 answers
RELEVANCY SCORE 86

MS Access:
I have several fields in a form that uses two tables. I would like to set up a command button so that when you are on a current record, it will copy the field information from the record you are on to other fields in the same record. I do not know the SQL commands to set this up.

For example, there are name fields, address fields, and phone to be copied. Reason: One is contact information; one is survey information. In most cases the information is the same but on rare instances, the information needs to be entered (when different).
This is not an update for all records in the database. This is based individually on each record.
Not sure if you need to do On current, on click, or after update.
Not sure if default value in form can be used.
Please help.
 

A:Copy data fields in same table to other fields in same table MS Access

Read other 16 answers
RELEVANCY SCORE 85.6

Hi,

Currently I'm trying to create a macro in Word 2007 that will allow me to disable a number of form fields so the next user can't change anything. For example:

1) User 1 fills out fields A, B, C and D and then sends the form back to me.
2) I unprotect the Word form and run my macro that will prevent User 2 from changing the data entered by User 1. Now I send the form to User 2 for input.
3) User 2 fills out fields E, F, G and H (fields A, B, C and D are disabled so User 2 can't alter the data already entered by User 1). User 2 then sends the form back to me.

To try and accomplish this, I created the macro below:

Sub DisableFields()

Selection.MoveUp Unit:=wdLine, Count:=1
Selection.MoveRight Unit:=wdCell
With Selection.FormFields(1)
.Name = "CAR_No_Assigned"
.EntryMacro = ""
.ExitMacro = ""
.Enabled = False
.OwnHelp = True
.HelpText = "QMR to assign CAR No., i.e.: 3DC-CAR-2012-001."
.OwnStatus = False
.StatusText = ""
With .TextInput
.EditType Type:=wdRegularText, Default:="", Format:=""
.Width = 0
End With
End With
Selection.MoveRight Unit:=wdCell
Selection.MoveRight Unit:=wdCell
With Selection.FormFields(1)
.Name = "Name_of_Initiator"
.EntryMacro = ""
.ExitMacro = ""
.Enabled = False
.OwnHelp = False
.HelpText = ""
.OwnStatus = False
.StatusText = ""
With .TextInput
.EditType Type:=wdRegularText, Default:="", Format:="&... Read more

A:How to disable fields in Word 2007

Just to clarify, when I do this manually (without using the macro) the previously entered data seems to disappear as soon as I unprotect the form and double-click on a field within the form.

As an after thought, could there be a simpler way of preventing User 2 from accessing the existing data?

Thanks again.
 

Read other 1 answers
RELEVANCY SCORE 85.6

Okay, I thought I had this figured out yesterday, but I guess I didn't. I was using continuous section breaks in the form to try and solve the problem. The only problem with this method, though, is that Word seems to only allow one break per line, which means the most precise I could get this way was to place a break at the beginning of the line I want to leave editable and then another break at the beginning of the following line. This won't work for me because it will still allow someone to use the enter key to create a new line in the editable part of the form, thus pushing everything below it down and changing the layout of the form. So, is there a way to get more precise when it comes to locking areas of the document around certain fields? Sorry if my post is a little confusing. Any help would be greatly appreciated.
 

A:Lock certain fields in MS Word form?

Could you e-mail me the form so I can take a look at it please? Have you locked the form as well so the user cannot edit it?
 

Read other 2 answers
RELEVANCY SCORE 85.6

I am trying to fill in a weekly dates using a form field start date.
It is setup as such:

Start Date: ________ (user enters date here in format ddMMMYY)
This is setup as a Text form field, set to date, with calculate on exit checked and bookmark as DateField.

Later in the document, I have a weekly calendar that I want to fill in the dates for Mon - Fri based on Monday as the start date from above.
I have been using the insert>Quick Parts>Field but cannot figure out the calculations even after multiple guides and searches.
I am able to reference the bookmark and repeat the date for Monday, but cannot figure out how to set Tue-Fri dates.

Please give me the exact code to put in if possible.
I could figure it out using VBA but want to do this without macros if possible.

Thanks
 

A:Solved: Form Fields in MS Word

Read other 6 answers
RELEVANCY SCORE 85.6

Hi everybody,
I have the problem that Word 2000 updates fields (with date) in documents, when I don't want it to. According to my information, Word 2000 only updates these fields when you select a field, right click it and choose update or when you print it, if that option is set in options. In my documents, however, it seems that Word 2000 updates the field every time I open the document.

Does anybody know how I can stop Word from doing this?
 

A:Word 2000 updates fields when I don't want it to

Read other 10 answers
RELEVANCY SCORE 85.6

The State of Florida is using an MS Word Document as a test document that can have answers placed in it. Some "Computer expert" unlocked it so that everything moved with 'tab', or 'space' or 'answer' entry. How are the fields supposed to be designed so you can Lock some fields (questions), but allow entry in others(your answers)?

How can anyone change that function in a state form?
 

A:Word -- Lock some fields, allow entry in others

Read other 6 answers
RELEVANCY SCORE 85.6

I have set up a .dot file which uses reference fields. I have set up the input field as a drop down box with bold text.

My query is when the ref field populates the first word is bolded the second one is not.

Can anyone assist?

Cheers!
 

A:Reference Fields - Word 2003

Read other 11 answers
RELEVANCY SCORE 85.6

I produce my departmental purchase plans on MS Access so that I can attach my own symbols eg prioritising and run queries. I have been told that I can transfer/link/export individual fields from Access into a template order form set up in MS Word. Is this possible? How is it done? Is there an easier way?
Any suggestions?
John.
 

A:Linking Access Fields to Word

Hey there.

Is there some reason a mailmerge from Word won't work?

www.thewordexpert.com/word.htm

Check out how to set up a mail merge.
 

Read other 1 answers
RELEVANCY SCORE 85.6

I have developed a form in word 2003 with drop down boxes. I want users to complete mandatory fields before progressing to the next field. I understand that this is activated by a macro. I am unsure how to do this. How do I start the process so that a form cannot be completed without the necessary fields being answered. Please try to keep the answer fairly simple with examples if possible.
Thanks
 

A:How to set up mandatory fields in Word 2003

Welcome to the forum. I am not good with VBA but it would be including an If>>Then>>Else statement to test the object to see if it is null or blank. You would probably want to it do it before you save and then have it select the objects that are not filled in correctly. I am posting this in the hopes one of our VBA people will respond to it. :0
 

Read other 1 answers
RELEVANCY SCORE 85.6

I am trying to create a customer letter template with the name of the sales rep and their title under the signature line (I got the sales rep name). So far the only way I see to add a title is in the employee additional fields, but when I try to use the employee toolbar for a customer letter it won't allow me to do that. Is there a way to do this? Please help - I need to get these letters out! Thanks!
 

Read other answers
RELEVANCY SCORE 85.6

Hello there!

I am trying to figure out how to construct an invoice in Word 2007 that performs calculations just like in Excel. If someone would care to correct the steps I already know, or add on to them to get me to a final solution, I will be extremely grateful!

Okay, so I have a table set up. Each of the top lines should take the number of items ordered and multiply it by the value of the item. For example:

5 Apples @ $1.00 - $5.00

The user should be able to change the number of items or the price of the item and have the total update itself when you update the field.

Next, the bottom part of the document will total all of the items, and multiply it by the tax rate (which is a value entered in the table).

Seems simple, right?

So, I know how to enter fields... I've gone to the Insert tab, clicked "Quick Parts", then "Field...". At which point I am presented with a dialog box and I think my next step is to click "Formula...", but I have no idea how to set it up. I know how to total columns, but I don't know how to multiply specific fields with other fields. I'm guessing it has something to do with assigning a bookmark to them and using this in the formula somehow?

A thousand thanks in advance!

[Another note: I'm learning how to do these sorts of things for an office software competition next fall, so I actually need to know how to do this using calculated fields... I don't need a work-around, like using Excel in... Read more

Read other answers
RELEVANCY SCORE 85.6

Hello everyone,

I'm new to the TechSupport Forums, so I'd like to start out by saying hello to everyone! I need some help with a (possibly) unanswerable inquiry.

I have created a protected document with form fields for users to enter information. When they hit enter, I would like for the document to go to the next form field rather than do a hard return. Is there a way to do this? Any help anyone can provide would be great!

Read other answers
RELEVANCY SCORE 85.6

hey there,
Does anyone know how to make fields or right text fields etc for letter templates, that contain 'client name' for example, that automatically fills all the other client name fields etc in the document. I KNOW It CAN BE DONE! ahh. Just like how word has its own fields for document title and author that it reproduces...
I can't figure it out. ??
 

Read other answers
RELEVANCY SCORE 85.6

I'm trying to build an index for a long book (200,000 words). I don't think my computer will handle doing this if the book is all in one file. Word Help talks about indexing by using referenced documents, or RD fields. Right now I have the book stored in separate chapters, each with correct pagination (so the pagination is continuous throughout the book).

I can't get the RD indexing feature to work, but get a message that Word can't locate the referenced documents. I've entered RD fields that look like:

{ RD C:\\Documents\\Chapter 1.doc }

but this doesn't work.

Many thanks for any help!

Tecolote
 

A:How to create index in Word with RD fields?

Have you read this?
http://www.word.mvps.org/faqs/numbering/Createindex.htm
 

Read other 2 answers
RELEVANCY SCORE 85.6

Based on this formula, how would I change it to validate 2 or more fields simultaneously? More specifically, [If "this field" equals "yes" and the "next field" equals "", then MsgBox...]

Correct for verifying "This field" only:

If Trim(fld.Result) = "" Then
MsgBox "You must complete " & fld.Range.Bookmarks(1).Name & " before you can print.", vbOKOnly + vbExclamation, "Error"
Cancel = True
fld.Select
Exit Sub
End If

My attempt at verifying the "next field":

If Trim(fld.Result) = "Yes" And fld.Next = "" Then
MsgBox "You selected 'Yes' for " & fld.Range.Bookmarks(1).Name & ". Please answer Question 'b' after " & fld.Range.Bookmarks(1).Name & " before printing.", vbOKOnly + vbExclamation, "Error"
Cancel = True
fld.Select
Exit Sub
End If
 

Read other answers
RELEVANCY SCORE 85.6

I am trying to create a form with required fields for a document at work. I was able to use code provided by Anne Troy to easily do this. However, I just have one additional question to complete a modification I had. Basically, on certain questions, I want the form to verify that the "Next" field is completed. So that if on question 7a "Yes" is selected from a drop down box, then question 7b must be answered. Here is an excerpt with the IF statements...
For Each fld In ReqFields
If Trim(fld.Result) = "" Then
MsgBox "You must complete " & fld.Range.Bookmarks(1).Name & " before you can print.", vbOKOnly + vbExclamation, "Error"
Cancel = True
fld.Select
Exit Sub
End If
If Trim(fld.Result) = "Select..." Then
MsgBox "You must select an answer for " & fld.Range.Bookmarks(1).Name & " before you can print.", vbOKOnly + vbExclamation, "Error"
Cancel = True
fld.Select
Exit Sub
End If
If Trim(fld.Result) = "Yes" And "NextField" = "" Then
MsgBox "You selected 'Yes' for " & fld.Range.Bookmarks(1).Name & "." & vbNewLine & "Please answer Question 'b' after " & fld.Range.Bookmarks(1).Name & " before printing.", vbOKOnly + vbExclamation, "Error"
Cancel = True
fld.Select
Exit Sub
End If
Next fld
End Sub
 

A:Word Form - Required Fields

See if this helps?
http://pcnorb.blogspot.com/2008/04/word-and-vba-forms.html
 

Read other 3 answers
RELEVANCY SCORE 85.6

Hi,

I have a REF field in word, which takes its content from a bookmark around a separate FILLIN field. The text is coming through fine, but it's using the formatting from the bookmarked text, which is inappropriate at the point the REF appears - the original field features prominently on the title page of the document, and the font is much too large for where it the REF appears.

Is there anyway of keeping the REF field in a certain format - specifically font size, face and colour?

Thanks, Oli.
 

Read other answers
RELEVANCY SCORE 85.6

I've created a form in Word that users fillout and print. Is there a way to make certain fields required?
 

A:Word Form - Required Fields

Read other 9 answers
RELEVANCY SCORE 85.6

I've created a form in Word that users fillout and print and save. Is there a way to make certain fields required?
I need it to be compatable with Word 2007 and 2002
 

Read other answers
RELEVANCY SCORE 84.8

Is there a way to lock certain fields in a Microsoft Word form while keeping others editable?
 

A:Solved: Lock certain fields in Word form?

Got it.
 

Read other 1 answers
RELEVANCY SCORE 84.8

I have a word template that is pulling fields from a DB and when a field has no data, it prints "Error! - Reference source not found".

Is there some way to tell Word 2000 not to print anything if the field is empty?

Thanks for any help you can give.
 

Read other answers
RELEVANCY SCORE 84.8

I was wondering if this was possible.

My mom wants me to write a template for school lesson plans. Each plan has several revisions, and each revision has several activity sets. For example, Lesson 1 might include Lesson Plans 1.1, 1.2, and 1.3. Lesson 1.1 might include activity sets A, B, C, D, and E.

She would like each activity set to exist in its own document, and at one point in the document she wants the activities listed ordinally while referencing the activity set, if that makes sense. In other words, she wants the activities listed 1a, 2a, 3a, 4a; 1b, 2b, 3b, 4b; 1c...etc., with each set being in a separate document.

I don't like the setup and I think she's duplicating information, but that's the way she says it has to be. Anyway.

Adding that letter to the bullets isn't difficult to do manually, but she's pretty computer illiterate so I need a way to do it automatically. I thought the easiest thing would be to use a FILLIN field to SET a bookmark, and REF the bookmark in the numbered bullet. I don't know if it's possible to insert a field into a list's ordination, though. Any ideas?

I have a couple other things I could try if I can't find a simpler solution. For example, I thought I might use a FILLIN field to grab the activity set, then use a macro to format the bullet style of the list in question.

Anyway, just thought I'd toss that out there, if anyone has any suggestions I'd be grateful.

Thanks,

chris.... Read more

A:Solved: Using fields as bullets in Word 2000

I don't like the setup, either. I think you're just asking for trouble. WHY does she want separate documents? Also, consider using Caption for the 1a, 2a...
 

Read other 2 answers
RELEVANCY SCORE 84.8

Hi there

I've been asked to set up a template in Ms Word which has fixed fields that cannot be edited by people and parts that can be filled in. i.e. a fill-in form.

I have searched everywhere today and can't find a way to do this and aware that a nasty deadline is approaching - can anyone give me some advice?

I would be very grateful!

Thanks!

Shaz

A:Setting up a Word template with fixed fields

Originally Posted by ShazMillz


Hi there

I've been asked to set up a template in Ms Word which has fixed fields that cannot be edited by people and parts that can be filled in. i.e. a fill-in form.

I have searched everywhere today and can't find a way to do this and aware that a nasty deadline is approaching - can anyone give me some advice?

I would be very grateful!

Thanks!

Shaz



It is quite a while I did this, and I have never done it my my current version of Word (2007). Have you checked in the Office Online tutorials?

Read other 1 answers
RELEVANCY SCORE 84.8

I would like to create forms in PDF...What I would like to do instead of creating the text fields in PDF is create them in Word placing a tag on the cell and when convert PDF will capture the text box. Is this possible with any plug-in even. I called Adophe and they informed me plug-ins are available for this but I could not find any.

We currently have forms on the web in HTML which I am converting to word the cell fields are carried over all I would need to is format the document the way we want it and rename the cells...The reason why I do not want to do it PDF is becuase I have approx. 100 forms and I know at some point they will be modified I would have to re-create the entire form in PDF where as in word it would be easier to re-create then I could just create a PDF and have it completed.
 

A:Convert word cell tag to PDF form fields (How can do this?)

Hiya and welcome

Looking here:

http://www.pdfzone.com/bguide/product/SearchResults.asp

There is Acropad, but you have to join to look at the actual program, but this is where you can get it:

http://www.acropad.com/

It may not be exatcly what you're after, as you said Word.

Also, there is this:

http://www.planetpdf.com/tools.asp?webpageid=550&TBToolID=1976

http://www.go2pdf.com/product.html

It may take a bit of playing with the plugins, to see which one will work, but the one above mentions this:

You may convert Microsoft Word, Excel, PowerPoint, Access documents into PDF formats, convert AutoCAD file into PDF, convert image formats to PDF, convert plain text file to PDFClick to expand...

Thats for Go2pdf, so you may want to look at that first.

Regards

eddie
 

Read other 3 answers
RELEVANCY SCORE 84

I have created a form in MS Word 2007. I used the form fields and have locked the form. When the user fills out the form it is saved and sent to someone to review, edit and/or comment. The receiving party unlocks the form and adds comments however, is not able to use track changes in the form fields. Do you know of a way that they can use track changes within a form field?
 

Read other answers
RELEVANCY SCORE 84

Hi All:

I am running windows XP version 2002, service Pack2
I am using Microsoft Word 2002 (10.6829.6830) SP3

I have a form that has been created in microsoft word by corporate that they want us to use for documentation. The form contains several grey alphanumeric fields, as well as many yellow "drop-down" style fields.

I am having a problem transfering the completed form into our text-only note system. The procedure I am using is as follows:

1. I fill in the information to the alphanumeric fields, and select the items I want from the drop-down fields
2. Under the tools menu I select "unprotect document"
3. Under edit, I select "select all"
4. Copy with hotkeys CTRL+C
5. Click into text only space with mouse, Paste with CTRL+V.

The Problem is that once I have pasted, while the alphanumeric information is still there, there is nothing but a blank space where the information from the drop-down fields should be. I am thoroughly convinced that I am overlooking something incredibly menial and arbitrary, but I have so far been unsuccesful in locating the source of my error either in the Office Help, or in any previous forum threads I have been googling. Any assistance on this matter would be greatly appreciated.

Thanks in advance
-LostGeekCred-
 

A:Solved: Microsoft Word: Drop-down Fields Don't Paste?

Read other 7 answers
RELEVANCY SCORE 84

Hi,
I'm completely new to vba and trying to modify a code I found here but failed.
While the original code exports cell data (1 row only) from excel into the form fields of a Word document, I tried to modify the code to work for multiple rows, one after the other.
My code works for the first row and generate a word file as supposed, but immediately stoped with an error message "Runtime Error -2147417848 (80010108), "The Object Invoked Has Disconnected from Its Clients"
Could anyone help me modify the code so that it works please? Thanks a lot!
I'm using 2003 excel and word.
P.S. I know this can be easily done by mail merge but I would like to use Word form for further process.

Code:
Option Explicit
'Requires reference to Microsoft Word (11.0) Object Library
Sub Copy_Cells_To_Word_Document()
Dim rng As Range
Dim row As Range
Dim wdApp As Word.Application
Dim wdDoc As Word.Document

Set rng = Range("A2:E4")
Set wdApp = New Word.Application
Set wdDoc = wdApp.Documents.Open(Filename:="C:\Desktop\file.doc", ReadOnly:=False)
wdApp.Visible = True

For Each row In rng.Rows
Copy_Cell_To_Form_Field wdDoc, Range("D" & ActiveCell.row).Value, "Surname"
Copy_Cell_To_Form_Field wdDoc, Range("E" & ActiveCell.row).Value, "Forenames"
Copy_Cell_To_Form_Field wdDoc, Range("B" & ActiveCell.row).Value, "Ref"

wdDoc.SaveAs ("C:\... Read more

A:import excel data into word form fields

Read other 6 answers