Threads Replies Last Post 10 Pages: 1  2  3  4  5  6  7  8  9  10   Outlook 2007 Beta and Sony P910i Sync Software Just another little thing, has anyone tried these two together, the Sony sync software doesnt seem to recognise that Outlook 2007 has replaced Outlook 2003. I suspect it's a Sony problem, but has anyone found a workaround ? -- Regards Haydn... 1 28.05.2006 15:52:01 Listbox Rowsource in Word Help Please, I am trying to link my listbox on a word userform to rowsource data in excel. As far as i know, this is possible. The same code works fine when i run it from excel, but it will not work from word. Can i not link my word listbox to my data in excel? -- Jeff "Spike" Zapinski ... 7 03.06.2006 22:17:02 Using CheckboxX in a loop My document has 10 checkboxes (Checkbox1 to Checkbox 10). I want to populate the Caption of each checkbox with text from 10 tables in the document, so I have a loop. Here's my code so far: Private Sub UserForm_Initialize() Dim X As Integer For X = 1 To 10 If ActiveDocument.Tables(X).Cell(1, 1).Range.Text <> "" Then CheckBox1.Caption = ActiveDocument.Tab... 5 02.06.2006 03:05:34 Remove checkbox/control from userform How do I remove a checkbox that was created at design time from a user form? The Help says: This method (the Remove Method) deletes any control that was added at run time. However, attempting to delete a control that was added at design time will result in an error. (I guess I can just move it farther down on the form, past the margins of the userform, so it'll be hidden, but can't I s... 2 02.06.2006 02:01:01 protecting a WORD 2003 document I am trying to protect a document, such that section 1, 3 is protected as read only and Section 2 is protect as form field only. Any idea how I can do this? I have only been able to protect it one way or the other, but not both. I think that I may need the use of a Marco however I am not sure of the code. Any help would be great. Thanks, Amanda ... 2 01.06.2006 21:40:29 Modify or Add to Color Palette This is a multi-part message in MIME format. ------=_NextPart_000_000E_01C67F02.74D535F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Is there any way to modify or add to the 48 colors available to the = "backcolor" property of a control?. I am playing around with a Userform = to create a tool for shading text and I want to match the color... 19 30.05.2006 22:08:27 FAQ - Frequently Asked Questions - vba - please read before posting - unofficial May posting FAQ = Frequently Asked Questions - brief - vba - unofficial This FAQ is posted every ten days or so. Please save us all some time by reading it before posting to the news group. This newsgroup is about VBA - Visual Basic for Applications - which is the programming language for Word 97-2003 (macros). There is a longer FAQ with more questions and links that is regularly posted in the non-... 3 30.05.2006 19:40:36 Thanks Doug Robbins and Macropod Thanks for the help guys. Pat ... 1 23.05.2006 21:50:00 Inserting Alternate Dates for Lotto Draws Hi, Can anyone here help me with a project I am attempting with MS Word. I have an ten page document whereby I want to: 1) Insert a date range commencing with a Wednesday and ending on a Saturday covering an eight week period. The data needs to appear in pages 1 and 2 in the format "DD/MM/YY to DD/MM/YY". Can this be done by using an input form asking the question "What is the dat... 4 23.05.2006 21:44:20 Auto populate form fields Hi, I' wondering if anybody can tell me if there is a way to automate a form based on the value of a form field. e.go. I have an Excel worksheet listing each recipients information that I want to insert in various field of a document based on their response to the first field (e.g. Name). Can VBA be written that will look at the field, and based on the text in the field, go to the Excel wo... 2 22.05.2006 22:11:14 Understanding MSForm Controls This is a multi-part message in MIME format. ------=_NextPart_000_0026_01C67C48.614AF630 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I was helping another person today to list the name and caption of each = optionbutton and checkbox in a userform. My code is shown below, but I = don't understand some of the behaviour I observed while cons... 7 22.05.2006 12:21:07 Saving .doc name based upon fields I would like to have the name of new documents (based upon a particular template) to be automatically generated based upon fields within the document. For example: Name the document based upon a client's name and date of service. Can this be done? If so, how? Thanks -- EWR... 2 17.05.2006 14:46:35 AutoSave a doc based on a form field Howdy, I have a word doc which users enter in field information. The form is locked and data entry is great. When the users leave a field, log no, I'd like to autosave the document using a macro. So after they leave field LogNo, save the document as "report_12334.doc" to the default directory. Well, this is pulling from SharePoint WSS, so it should save back to the WSS list. How do I ... 2 17.05.2006 09:13:53 Picking records/rows from a recordset Hi I have a recordset containing rows selected by a SELECT command. I want to present the selected rows in a list, grid or .... and give the user the option to select one or more of the presented rows using a check box or something like that. Afterwards I want to do something with the checked rows, when the user presses a command button. How am I solving this problem in the right way? ... 7 16.05.2006 20:25:23 Standard Conventions for UserForms Yesterday I was in a discussion (buried deep in another string) with Jean-Guy Marcil about the proper conventions for developing userform code. In particular, where the bulk of the code should reside. Here is a very simple example where a userform provides one text input to supply a bookmark in the document. I am using this to illustrate at least four different approaches for processing t... 18 15.05.2006 11:40:45 Shortcut key to textbox and commandbotton In forms is it possible to underline a letter in the text of a command botton and in the label of a text box. The command botton is pressed when pressing ALT-<underlined letter> and the textbox is focused in the same way. How do I do in my userform to use the same functionality? Ebbe ... 4 13.05.2006 19:00:16 Create Form in Office 2007 Does anyone around know where to find the Form toolbar equivalent in Office 2007 beta 2? -- --------------------- Thanks Rajiv Das... 3 12.05.2006 10:38:01 current field in protected document Hi! I'm tryin to run a macro on the "on enter" event on some formfields of a protected document. The following code n = Selection.FormFields.Count MsgBox n Selection.FormFields(1).TextInput.Clear returns n=1 and works untill I protect the document, moving through fields by clicking on them or using the tab key. Once i protect the document, and move through those fields the code retu... 6 11.05.2006 19:41:57 Return a File Path to a label on the user form I have written the code below that displays the file path in a msg box but I want it to display in the user form. I have created a label to hold the file path but I can not find the write code to make it display. My other problem is I am not sure where the code should go, behind the label or do I just reference the label? Could you give me some pointers. Thanks Pam Private Sub ... 2 09.05.2006 11:50:54 Clearing Form Fields on 1st Doc Open only? This seems it should be simple, but I'm spacing on it.... Hwo can I call the same macro from several Command Buttons without having to copy the script to each Click() event? So, I have a macro: Sub ShowHello() UserForm1.Show End Sub And let's just say I have three Command Buttons from which I would like to launch the userform. Right now I would have: CommandButton1_Click() Use... 3 05.05.2006 11:10:34 Setting the Default Option when opening a form. On a Form I have an Option Group. How do I set the first radio button option to be default, that is, automatically selected, when the form opens? Thanks ... 3 05.05.2006 06:45:03 Code requested to require password to view the form I have a form template that requires publishing in a public directory but the form can only be viewed by one team for their use. Unless you have other suggestions, is there a way (and code) to require a password to display the form? This will be a different password than the private one that unlocks the template for editing. Is this possible? Thanks, Charlie charlie6067 ... 4 04.05.2006 17:36:31 Inserting to next row and user form. I have a user form that inserts text on the next row of a table. The following code works great, but the entry does not show until I close the form. I dont want to close the form to see the inputted values. Any refresh command I can use? I tried Me.Refresh, but that didnt work. Dim NewRow As Row Set NewRow = ActiveDocument.Tables(1).Rows.Add With NewRow .Cells(1).Range.Te... 3 02.05.2006 14:48:02 Fill in scanned form Is there a way to scan a form and fill in the information and then print? ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =----... 2 02.05.2006 04:56:10 PROTECTED FORM AND TOC I am working on a doc with a TOC. I am trying to insert forms with drop downs and check boxes but as soon as I protect the form and update the TOC, the TOC doesn't work. Am I doing something wrong? ... 4 01.05.2006 18:27:18 10 Pages: 1  2  3  4  5  6  7  8  9  10