Threads Replies Last Post 14 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14   Creating a user selection using OptionButtons with a text field al I have created an group of radio buttons in a form coded like this: WordBasic.OptionGroup "OptionGroup1" WordBasic.OptionButton 20, 270, 148, 16, "Sir", "OB1" WordBasic.OptionButton 20, 290, 141, 16, "Sirs", "OB2" It is going to allow the user to pick which salutation they want for a letter. I want to add an "other field" aswell so that the user can either selec... 10 5/26/2007 7:52:21 PM Templates and Macros Hi guys and gals, I'm having trouble with a template in Word 2003. It has macros and forms in it. When I create a document based on the template, the macros work while on my machine. However, when I separate the document from the template, the macros and forms no longer work. It appers they are not copied into the new document. Does anyone know how I can make the document carry o... 2 5/19/2007 10:00:13 AM Manipulate IP address Hi - I want to manipulate an IP address such that whatever is entered into textbox1 is examined and then the last octet is increased by one. for example: user inputs 1.2.3.4 code will output 1.2.3.5 I tried to do it, but I'm not sure how to examine the contents of the textbox1 to know where to make the mathematical addition. Can anyone provide the code for something like that? ... 9 5/19/2007 1:50:25 AM Validating textbox text Hi - I tried doing this myself, but i didn't get very far. I just need to know the code to prevent a user from entering a specific string of test into a textbox. The text needs to be entered in the textbox in the form of ABC (as in three capital letters only). The letters must be capital. There can only be three of them. There can be no leading characters of any kind (numbers, punctuat... 4 5/16/2007 3:10:02 AM Copy Data From an ACCESS form to a Text From Field in a WORD Template I have a Front-End ACCESS db (linked to (3) Tables on a Back-End SQL Server). I have a series of Queries that manipulate the data and populate an ACCESS Form. This Form has the following features: 1. A Main Form, with several pages (Tabs) which display data from one (OverallData) Table a. One of these pages (Tabs) contains a Sub-Form which displays data from another (SpecificData) T... 15 5/15/2007 9:57:16 PM Handling events in template that is not document template I have a document based on some template, e.g. normal.dot. I also have another global template loaded, othertemplate.dot. Is there some way I can have a macro in othertemplate.dot handling the closing of the active document, e.g. Document_Close or AutoClose? Or does the macro have to be in normal.dot, or the document need to be based on sometemplate.dot for this to be possible? When i ... 2 5/11/2007 8:28:01 AM Userform and Excel Intersecting values Hi -- me again. This time, I want to create a Userform with Comboxes and docvariables. Here's the tricky part. I want the Userform to populate the ComboBox with values from an Excel worksheet. Let me give you an example: Excel Table: XXX YYY ZZZ ABC 5 10 15 DEF 2 5 20 GHI 4 4 5 ComboBox1 will be populated with the headers X... 8 5/11/2007 5:19:42 AM Checkbox populate I am creating several forms in Word and need to create a checkbox macro. For example, if a user clicks a particular checkbox, I would like another checkbox further down to auto-populate at the same time. How would I go about doing this? ... 2 5/10/2007 8:06:24 PM Activate / initialise event My current project uses multiple userforms to give the user the impression they are navigating around a separate program, before returning to MSWord to create a document based upon their entries. I'm currently writing a validation loop to make sure the forms are fully completed before we skip to Word, and this is where the problem occurs. Now, moving between the forms is fine, using th... 3 5/10/2007 6:59:54 PM reaching a subform through code I want my subform background to change color if a checkbox is true. The checkbox is in the subform. I have very minimal experience in vba. Can someone please provide explicit instructions for this, please? ... 8 5/9/2007 11:30:17 AM Calculating total minutes on a MS Word Form. I have form where I want to calculate the total minutes between two date/times. I found an Excel formula where basically you subtract the two fields and then multiply by 1440 to show the total minutes. It worked when I tried it in Excel but I cannot get to work in my Word form. http://office.microsoft.com/en-us/excel/HP030561081033.aspx?pid=CH010005121033#Time%20Unit In my form, I have... 5 5/9/2007 6:26:12 AM letters to contain multiple(# varying) addresses Hi, I'm looking to automate the generation of several hundred letters from data in an access database. The problem is there can be anywhere from 1 - 6 names and addresses that the letter is addressed to. I can get one address on the letter via my vba code from access, no problem. It's the multiple addresses I cannot find a way to do. Does anybody know if I can create a word table to ins... 13 5/8/2007 1:56:00 PM Copying contents from listbox in VB to a form in word with newline seperators So i've spent all day trying to figure this out... Here is the problem I'm trying to copy the contents of a list box to a document that contains word forms. I started by copying each item in the listbox array to a textbox with a vbNewLine char at the end so that it maintains it's formatting. The problem occurs when I select all in the text box, copy and then paste into the word form, ... 6 5/4/2007 11:13:40 AM Selecting text from Word between 2 text strings Hello all, I need to select a portion of a word document. I was able to do it using the range object but I can only select a range using starting position and ending position. I would like to select the text according to strings. Below is an example. My name is Jonathan.................... Some other text and this is the end of my story. I would like to select the text betw... 2 5/3/2007 4:41:03 PM Automate insertion of multiple PDF pages into Word I have a number of PDF documents with multiple pages that need to be inserted into a Word document. Instead of inserting 1 page at a time, I would love to have it done automatically. Can anyone assist me? Many thanks Jenny ... 2 5/1/2007 6:19:33 PM character limit on form text field Not sure if this is the correct forum to post this question.....Is there a limit to how many characters can be typed into a form text field? I thought it was 255 but I did a quick test and I can get more in. When I click on the field and bring up the options, I know I can choose unlimited for the max length, but is it really unlimited? Thanks -- Tina... 2 4/30/2007 8:11:20 PM BUG?: Control transparency in Word 2000/XP I haven't been successful in making a textbox control transparent over an image inserted into a document. My image is set to "behind text" under the layout tab. My textboxes are inserted and set "in front of text". Also, under the textbox properties I have set BackStyle to transparent and SpecialEffect to flat. While in design mode, my textboxes appear transparent, showing the image b... 5 4/19/2007 4:08:06 PM populating combo box in a form created in vba in word from an access database Hi there, I need to populate the contents of a dropdown combo box in a form which i have made in word 2003 using vba from an access database. i need to know the code for establishing connectivity between the two, as well as where to insert this code in. Cheers, Pats. ... 2 4/16/2007 5:03:24 PM Run routine when the Userform is in the active state I have a non-modal userform which allows the user to select back and forth between the document and the userform. There is a list box where the user can select different items. Every time the user clicks on the document, the userform loses focus and when the user clicks back to the userform, I need to run a refresh routine that I created. It's a routine that will update the items in... 5 4/13/2007 7:10:01 PM Userform with math formulas Hi - I need to create a very simple user form with a text box so that user can enter a value that box to be used to complete very simple math equations: Crude example: User enters: X Userform will calculate: (X*1000)+6 = Y Userform will then calculate: Y*4 = 8024 Userform will then paste the values ('2006' and '4012') into the document in the appropriate spots (using doc variables ... 4 4/12/2007 9:00:05 PM Sort a listbox in Ascending order I have a list box on a userform with items already added to it. Is there a way to change the box so that it sorts it in ascending order? The items are text and numbers mixed. These items are also loaded into an array as they are added to the list so I'm not sure if I need to sort the array first then add the values to the listbox or if there is someway to just alphabetize the listbo... 3 4/12/2007 12:20:01 AM Word2003 generating error 5479 - You cannot close Microsoft Office Word ..... Apologies for cross posting, I posted similar to WordVBA addins, but the more I investigate the more it relates to Wd2003 and UserForms. Create a template, add a UserForm1 with CommandButton1, add a Module with Sub Main. Sub Main code = UserForm1.Show CommandButton1 code below Private Sub CommandButton1_Click() Dim sFile As String sFile = "<any valid document path & name>... 5 4/11/2007 2:25:27 AM Cannot find Project or Library error Hello guys, I developed a userform on my laptop and it worked perfectly fine... Now I transfered the files over to the network and tested it and it all went pear shaped. I'm getting this "Cannot find Project or Library Error" or functions such as "Date" and "chr()"... Also I didn't include the option Explicit statement, and didn't declare variables... It's also picking on undeclared v... 2 4/10/2007 8:28:31 PM Profile not accessible I just reinstalled windws XP home edition coz my system32 config file was curropt... now i have a lot of file under my old profile... but after i have reinstlled i cannot acess the ld profile even though it shows under my document and settings folder... how do i restore this old profile as it dosent appear in the control panel (User) what shud i do??? or can i atleast access my files and... 2 4/6/2007 6:27:02 PM Using VBA To change XML root name Hi All, I'm new to using vba in word but have some practice with vba in excel. That being said I have no code to offer up for anyone to look at only what I need to get done via VBA if possible. Oh, and thanks tons in advance for anything that will help or at least point me in the right direction. We have over 100 stores and a coworker of mine is creating forms using acrobat 8. These store... 2 4/6/2007 6:25:14 PM 14 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14