| Auto populate a drop down or text box from the selection in another drop down box Posted: 12 Mar 2015 02:13 PM PDT Making a very simple, time saving form that will be used over and over. I have a drop down box with nurses names, only 10 of them. When I select a nurse I want the other assigned box, either drop down or simple text box, to auto populate with their corresponding phone extension. I haven't done any programming since Modula 2 in the 90's and it wasn't much anyway. This is what I have compiled from looking but, yep I'm stuck. thanks for any direction on this. Private Sub Text10_Change()
If Dropdown1.Text = "AB" Then
Text10.Clear
Text10.AddItem ("54060")
End If
If Dropdown1.Text = "RA" Then
Text10.Clear
Text10.AddItem ("54067")
End If
If Dropdown1.Text = "DS" Then
Text10.Clear
Text10.AddItem ("54069")
End If
If Dropdown1.Text = "JR" Then
Text10.Clear
Text10.AddItem ("54068")
End If
If Dropdown1.Text = "LD" Then
Text10.Clear
Text10.AddItem ("54029")
End If
If Dropdown1.Text = "CA" Then
Text10.Clear
Text10.AddItem ("54070")
End If
If Dropdown1.Text = "MT" Then
Text10.Clear
Text10.AddItem ("54034")
End If
If Dropdown1.Text = "SG" Then
Text10.Clear
Text10.AddItem ("54035")
End If
End Sub |
| Fourth heading in TOC won't indent correctly Posted: 12 Mar 2015 02:05 PM PDT I created a table of contents from my document headings, and it is displaying as such: 1. Heading……….……................….pg #
1.1. Heading…….….................pg #
1.1.1. Heading….........….pg #
1.1.1.1. Heading……..........….pg # It looks like the fourth heading is in its own separate text box, but I can't copy and paste the text out of it. I don't know what settings to alter in order for it to display correctly. Please help!
|
| Word template Posted: 12 Mar 2015 01:54 PM PDT I am creating a Word 2013 template and using the Date Picker Content Control. Whenever I add it to a document, it defaults to the date that I added it. This means that whenever someone uses my template, the date displayed is longer and longer in the past. Is there any way to make it default to Today's date? |
| How do I merge multiple excel files into one word document Posted: 12 Mar 2015 12:43 PM PDT I need to merge information from multiple excel documents into one word document. Is this possible? If it is, how? |
| Inserting a QR code in a Word document Posted: 12 Mar 2015 12:33 PM PDT I've created a QR code and downloaded it both as an svg and an EPs file. When I try to insert in a document I get a blank square with a message that says "this image cannot be displayed at this time". So how can I insert the QR code? |
| Embedded Visio Objects in Word Posted: 12 Mar 2015 12:19 PM PDT I'm not sure if this is the correct place to report a bug, but I've found a repeatable one that should be quite easy to fix. Preface: I am working in Word 2013 and using embedded "Microsoft Visio Drawing" objects to create flowcharts. The object is created and by default it is 8 1/2" x 11"... which if you working with an 8 1/2" x 11" document with margins in word makes it to big. So I manually go in and re-size it to be 5.8" x 7.25", a nice size for my purposes. Since I create many of these flowcharts, and since I don't want to do this step each time I copy and paste the object to get many of this same sized object. Doing this is what led me to find the following bug. Bug If right-click the Visio Drawing Object and select Visio Object > Open it opens the object in Visio for editing. If you then delete the first page that was created, I happened to do this because I had other pages and no longer needed that first page for that particular object instance, then it renders the object un-editable both from Word and from Visio. I'm sure you just need a line of code saying if that first page got deleted... then open up the next available page for editing. Notes I am using: -RemoteApp to open Word and Visio -Windows 7 -Dell Latitude Laptop
Thanks for your time, Nick |
| Table of Figures - Posted: 12 Mar 2015 11:49 AM PDT I have a very similar error with inserting the Table of Figures with respects to the Figure not showing up. My case is that I have a Figure 23 - Image 1, and a Figure 24 - Image 1, displaying on the Table of Figures. In the basic document, the figures are displayed as Figure 23 - Image 1, Figure 25 - Image 1, but there is no Figure 24 in the basic document that I can find. When I hover my icon over Figure 24 - Image 1, in the Table of Figures, press the Control button and click, it takes me to the next page where supposedly, Figure 24 is located but there is nothing there. I have moved the figures and there is no figure captions there. I have deleted both Figure 23 and 25 from the basic document and re-entered them. Figure 23 will enter as 23, but, when I enter the next Figure, supposedly, it is suppose to enter as Figure 24 but it does not, it enters as Figure 25. I also deleted the Table of Figures and re-inserted it and Figure 24 still appears in the Table of Figures but in in the basic documents. Tracking is off. Anyone else experiencing a similar problem. Thank you for your time and inputs. |
| Can I Save documents to iCloud Drive? Posted: 12 Mar 2015 11:33 AM PDT Im using word for iPad and just want to know how I can save documents to iCloud drive. I can load files from there but not save files. Am I missing something? Do I have to purchase the upgrade? I'm using iOS 8.1.3 |
| [Word 2013] How do I disable the annoying bullet-list-all-the-lines function whenever I just want to bullet-list 1 line? Posted: 12 Mar 2015 10:17 AM PDT This is an issue where I don't know how to disable the function. All I wanted to do was to have 1 line, which is the "3 units", be bullet-listed. When I clicked on "Bullet List", instead, Word 2013 bullet-lists all the lines. I want to turn it off. 
How do I turn it off/disable this function? Thanks in advance. |
| Recent Documents in Word Posted: 12 Mar 2015 09:20 AM PDT Hello, I use Office 365, daily. In particular, I use Word, daily. I have a word document named Notes.docx. I am paranoid about OneDrive, for which I have numerous posts and no solutions. [Everything and everyone is culpable for the problem, EXCEPT for Microsoft. There is no way Microsoft has written problematic code with OneDrive.] Therefore, daily, I save a copy of my notes.docx file as yyyy^mm^dd^notes.docx, where ^ is a space. Therfore, I have numerous copies of notes.docx for edits made on respective days. So, In Word, under recent files a paying Microsoft customer would erroneously believe: - that notes.docx would be listed as a recent documents because, in fact, it is used and saved daily.
- recent documents would be listed either in descending date order by the nomenclature of the file, e.g, the file saved yesterday with the yyyy^mm^dd^notes.docx would be listed as well as the day before that and the day before that an so on or by the actual save date of the file
This paying Microsoft customer erroneously believed the above. This paying Microsoft customer: - does not even see notes.doc.x in the recent documents list, a file that was in fact used and saved yesterday.
- does not see the immediately 3 preceding files of notes.docx with the following naming structure yyyy^mm^dd^notes.docx
This paying Microsoft customer sees as his recent documents: - notes.docx files with the naming structure yyyy^mm^dd^notes.docx as of 75 days ago, seventy five days ago!!!
Stated differently, the code that Microsoft has written is telling this paying customer that: - files saved 75 days ago are the most recent files
- files used yesterday and saved yesterday are OLDER than files used and saved 75 days ago
- Word has not saved a single document for 75 days; therefore, Word has not been used in the past 75 days either to create or to edit Word documents.
Remember Forrest Gump? Microsoft is a technological box of chocolates, you never know what the Microsoft problem du jour you are going to get. Oh, yes, I know the fault lies with me or some third party or failure to have everything updated (because it was released to the public as **** in the first place with the intention of proclaiming corrections with updates) or the man-in-the-moon, because it is never Microsoft's fault. QUESTION: Is this how the free Google Docs does it? |
| Template Titles Displaying in Spanish Posted: 12 Mar 2015 08:56 AM PDT I'm not sure when this changes, but when I go to open a new template in MS Word 2013, the template titles are now displaying Spanish instead of English, making it hard to tell what they are. The only title still in English is the Blank document. I have checked the options in Word and it is set for English to be my default language, so I'm at a loss why this is happening and how to fix it. Note: I know about dummy text and this is not what I'm referring to. Look at this screen shot and the template titles. 
|
| How to I stop Word 2013 from randomly changing style formats? Posted: 12 Mar 2015 07:44 AM PDT So -- I'm in a document where all of the text is "Normal". I realize I need to turn it into an outline. I click on the first paragraph and set that to Heading 1. I modify the style of Heading 1 as necessary, and set the "following paragraph" to Heading 2. I click the next paragraph and set that as Heading 2. I modify the style of Heading 2 as necessary, and set the "following paragraph" to Heading 2. I click the next paragraph and set that as Heading 3. I modify the style of Heading 3 as necessary, and set the "following paragraph" to Heading 3. Things are going fine, until one time I put the cursor at the end of a heaingr 2 paragraph and hit "delete". Prior to this, it had pulled up the following "X" paragraph (which was Normal) into the Heaoing 2 paragraph. I then hit enter, the "X' paragraph is now Heaingr 2. But sometimes, when I hit delete, it pulls up the following "X" paragraph and changes the Heading 2 paragraph to normal -- instead of the other way around. I can't figure out why this happens. As far as I can tell it's completely random. Then, I right click on the style for Heading 1, modify, and click the "B" to bold the text in Heading 1. For some reason, the number for Heading 3 paragraphs is now also bold, although the text is normal. Heading 2 remains unchanged. for the love of christ, why does this fricking program constantly make random and unintelligible formatting changes? And how do I stop it? |
| Problem with Formatting Macros Posted: 12 Mar 2015 07:28 AM PDT I've made certain Macros that change the formatting of text when used, i.e. going from single spacing to 1.25 spacing, etc. Unfortunately, when running the macro, it will change other formatting to that which may have been in effect when I made the macro, i.e. say I'm using justified alignment but when I run the 1.25 spacing macro it will change the alignment to Center. How can I get the macros to simply make the formatting change assigned to it and NOT change other formatting that might be in use? I'll apologize if I'm not making sense! I couldn't figure out how to state the problem! |
| Help with ListNum indentation problem - Word 2013 Posted: 12 Mar 2015 07:23 AM PDT I have set up a list number for a template that could be used by a lot of people. It works pretty well, but I have one problem in getting indentation set up properly, and I have been in the list number set up window (and experimented with settings) a thousand times with no resolution. In the image below that shows an excerpt of the document, I want the 2nd line of the 3rd level list (3.2.1) to indent like 2nd line of the 2nd level list (3.1). In other words, I want the second line of text to align with the first line of text, not align with the number. And, of course, I want it to happen automatically and consistently throughout the document when someone does a Decrease Indent to add a 3rd level list number and has enough text to have a second line - it should have that alignment-format. The only way to do it now is to manually go to the paragraph setting and set up the hanging indent after the 3rd level is created. Obviously not a great solution for a template. The 2nd line on the 3.1 level always aligns with the 1st line. The 2nd line on the 3.1.1 level never does (unless I have modified paragraph settings for an existing list item). I am including the List Setup window too. Please help me! I want this template to work great. 
|
| I am having problems with the coding for a mail merge combining multiple rows into 1 document. Posted: 12 Mar 2015 07:12 AM PDT I am trying to get a data set from excel that includes company name, contact name, check numbers, check date, amount, and payee name to come into a mail merge document in word. I would like my company name to be the key for notating a new document. I am not doing something correct in my coding, and I am not sure where I am going wrong. This is the coding that I am using (with the control F9 command to get my brackets). { IF { MERGESEQ } = "1" "{ MERGEFIELD COMPANY_NAME }" "" }{ SET Company1 { MERGEFIELD COMPANY_NAME }} { If { Company2 } <> { Company1 }"
{ MERGEFIELD COMPANY_NAME }
{ MERGEFIELD CHECK_DATE } { MERGEFIELD EE_NAME_1 }" "{ MERGEFIELD CHECK_DATE } { MERGEFIELD EE_NAME_1 }" }{ SET Company2 {MERGEFIELD COMPANY_NAME }} This is the result from this coding: ABC Company «CHECK_DATE»«EE_NAME_1»""«CHECK_DATE»«EE_NAME_1»" Furthermore, I am at a loss as to how I would incorporate this into my document that I have typed up. I would like the company name and a contact name to flow through (but again only one document per company), and this would be referenced a couple of times in the document. I would like the check information to show at the bottom of the document - preferably as a table, but as long as the information shows I won't get too picky at this time. Thank you for any help! |
| How to make multiple copies from a word template Posted: 12 Mar 2015 06:54 AM PDT I have created a word template. I want to fill a table in the template with the details i retrieve from ms Access database. The code I have written is to fill only one document which i later want to change to suit multiple records Dim oWordDoc As Word.Document Set oWordDoc = GetObject("C:\Users\user\Desktop\Access2Word.dotx") With oWordDoc .Bookmarks("TName").Range.Text = "L.Venkatarao"
.Bookmarks("Toffice").Range.Text = "ZPHS, Palasapuram"
'.Bookmarks("EmpId").Range.Text = "0125183"
.Bookmarks("TdateofBirth").Range.Text = "03-07-1981"
.Bookmarks("TPolicyNumber").Range.Text = "L-420421422"
.Bookmarks("TPremiumEnhancement").Range.Text = "150"
.SaveAs "C:\Users\user\Desktop\Sivasri.docx"
.Close
End With Set oWordDoc = Nothing
when i save it with SaveAs, the new document is not opening. when i save it with .save, the changes are saved in the original template. but i can't get a copy. Please give ideas By the way, i am totally new to ms word vba
|
| Macro to split mailmerge files into sepertae PDF files Posted: 12 Mar 2015 06:01 AM PDT Hi I am using MS word 2013 version. I have a agreement template that will need to create a large number of word files which need to convert to PDF files. I am not familiar with VB. If some one can help me by share a macro to split the emrged files into individual PDf format it will be very helpful for me. Thanks to anyone who can provide help... |
| Templates Don't Open when Preview is On in Explorer Posted: 11 Mar 2015 11:44 PM PDT The title pretty much explains it. If I have preview showing in Explorer and double-click a Word template nothing happens. If I then Start Word, the template appears as a second window. The problem then is that the window has no ribbon or other interface and I can't seem to edit the file. Can anyone tell me how to get the files to open properly. Thanks Gordon |
| Copying Excel to Word - Conditional Formatting Not displaying Posted: 11 Mar 2015 11:03 PM PDT Just wondering if anyone can help. I've got a data set in excel with conditional formatting, 22 columns with up to 4 conditional formatting rules per column. Everything works fine in excel, but when copying to word (to paste into a report template), some of the conditional formatting disappears. I've tried pretty much all combinations for copying (as picture etc) and pasting (paste special, as image, as link etc). Example pictures below. Using Office 2013 on Windows Server 2008 R2. Interestingly, it seems to work when only half the data is copied (in 2013) and it also works fine in Office 2010. Original data (excel): 
Data when pasted into word: 
Any help or suggestions would be appreciated. |
| Restricting editing to Groups in Word Posted: 11 Mar 2015 09:51 PM PDT Hi, I have a form which I have set up for one Group to have full access to all areas designated, but limited access to just a few other areas to "Everyone". So I initially formed the Group by creating a list of Individuals, and then selecting them all. Unfortunately, as I move through the document and assign parts that the Group can edit, more "Groups" appear in the Groups box which seem to be duplicates of the first but the individual names are in different orders. First question: Is there a way I can delete all these "duplicates" and just have my original Group showing, as all the duplicates are confusing? Second question (and this could be solved by the answer to the first): I want to add some individuals to the original group. Is it just a matter of adding these individuals as users to the Individuals list and then adding them to the Group? I suspect it is, but if there are many "duplicate" Groups showing, this can become a bit of a problem. Thanks in advance of the answer. |
| Word 2010. all my template folder are empty. Posted: 11 Mar 2015 09:06 PM PDT Original title: Word 2010 template
I went to do a fax template in Word 2010 and I notice all my template folder are empty. How can I get all my template back? |
| How do I display templates in certain format Posted: 11 Mar 2015 08:02 PM PDT How do I display templates in ms-word 2010 in this format every time I click on File->New: 
|
| Automatic formatting of URL in Word 2013 Posted: 11 Mar 2015 06:48 PM PDT Windows 8.1 I have two documents, both are assignment documents received from an online college. When I type a URL in one of them and then press space I get a nicely formatted link, in normal type and blue and, I think, underlined. In the other document, the URL gets turned into italic, no blue lettering and no underline. This behaviour seems to be set somewhere in defaults within the respective documents but I have been unable to find where. I like the blue etc. response, not the italic etc. response. Could somebody please advise me as to where I can find the appropriate settings. I have searched online help but cannot find an appropriate answer. With thanks in anticipation. Philip, Bendigo, Victoria |
| MS word 2007 crashing when pressing function button at top left Posted: 11 Mar 2015 06:43 PM PDT my program immediately closes when I press the button at the top left corner (the one you press to access save, open, etc). it does not do this all the time, but does do this frequency to be a nuisance. Any insight is greatly appreciated! (running windows 8.1, legitimate copy of Microsoft office 2007) |
| When I open a manual in Word, the text is in Greek, but should be English Posted: 11 Mar 2015 05:24 PM PDT Hi. I am using a PC and running Windows 7. I have Word 2010. I am opening a file created by someone else and when I open it, the file is in Greek. The language settings say Arabic, though. Someone else within my office uses the same computer and versions as me and they are able to view the manual in English, which is what the language should be in. What settings can I take a look at to fix the issue? |
| How can I remove Japanese from Word 2013? Posted: 11 Mar 2015 03:51 PM PDT My word worked fine until I accidentally added a japanese keyboard to my computer, now word has all the asian language editing buttons and I just want it to go back to normal! I have read other questions and try different ways but I cannot seem to remove japanese! Word tells me to restart after changing language settings but when I open it back up japanese is always back... I have triple checked that the japanese keyboard is off on my computer in the language settings and no longer know what to do! can anyone help? (My computer is Windows 7 if this helps!) |
