Populating word 2002 forms with ODBC data

Tutorials Win: Microsoft Windows Forum

- Previous
  - 1
    - Need help with a looping macro I need help with writing a "Do Until" macro. I am inserting a text file (that changes daily) and need to insert spaces at fixed lengths in each line. I want to start on the first line and stop the macro at the end of the file. The macro is: Sub Insert_Spaces() ' ' Insert_Spaces Macro ' Macro recorded 9/7/2005 by keenpar ' Selection.MoveRight Unit:=wdCharacter, Count:=1 Selection.TypeText Text:=" " Selection.MoveRight Unit:=wdCharacter, Count:=7 Selection.TypeText Text:=" " Selection.MoveRight Unit:=wdCharacter, Count:=16 Selection.TypeText Text:=" " Selection.MoveDown Unit:=wdLine, Count:=1 Selection.HomeKey Unit:=wdLine End Sub Any help will be most appreciated. Thanks -- Jerry Keenan Tag: Populating word 2002 forms with ODBC data Tag: 74202
  - 2
    - EMail ing in word hi using Word2003. read thru postings but didn't find what i'm looking for. :) i've got a word document that needs to be sent as an email attachment. i know how to access fields and all, but have not been able to find an EMail object that allows me to send the word doc as an attachment to the address(es) that is/are required i'd rather use a library or object (such as ADO for data access, without opening Access or Excel) but not use the Outlook application to do it. typical setup is WinXP with Office2003 is this possible? thanx and please help riyaz Tag: Populating word 2002 forms with ODBC data Tag: 74201
  - 3
    - How to trap ClosePreview, when user clicks the X inupper right corner. I open a Word template from with in Outlook. The template that has a Public Sub named ClosePreview, I use this macro to close the Word application by calling Quit wddonotsavechanges, this works fine when user clicks the built-in Close button. If user clicks the X in upper right side my macro will not execute. Can some one please advise how to trap the event associated with clicking the "X", my goal is to close and quit Word with out saving any changes. Thank you Tag: Populating word 2002 forms with ODBC data Tag: 74200
  - 4
    - Text Box -- put IP at top I have a text box on a user form which receives multiple lines of text (more than a 'screenful' -- this particular text box can display only about 10 lines of text, and I have scroll bars visible). When the user clicks inside the textbox, the insertion point is always on the last line. The user has to scroll up to see the beginning of the text. I want the cursor to start at the head of the text. I have tried the CurX and CurLineX features, but cannot get them to work for me. What else can I do? Thanks, Ed Tag: Populating word 2002 forms with ODBC data Tag: 74199
  - 5
    - INCLUDEPICTURE prob When I place the merge field within the INCLUDEPICTURE it appears ok as { MERGEFIELD myfield}. However when I do a Save it instantly changes to the actual data, i.e., "MyFileName.jpg". I have a routine in the document open event that calls a routine in the dot file that reupdates all the fields. However, it never updates the picture. I have a feeling that once it gets changed in the Save as the actual data, it never changes again. What do I do to cause the picture to change from record to record? Tag: Populating word 2002 forms with ODBC data Tag: 74191
  - 6
    - merge doc opening message When I open a document that is merged from Access, I get a message that begins: Opening this document will run the following SQL command. Select * form 'queryname'.... Is there any way to prevent this message from appearing? Tag: Populating word 2002 forms with ODBC data Tag: 74190
  - 7
    - Menus en Word Tengo dos .dot a.dot y b.dot. El A.dot se encarga de administrar los men=FAs, de tal manera que b o cualquier otro .dot pueda agregar sub-men=FAs bajo el mismo men=FA de la barra de menues. Cada vez que un .dot se levanta, en el AutoExec agrega los men=FAs que le son particulares. Es decir que b.dot agrega sus men=FAs cuando se carga mediante la macro AutoExec, llamando a una funci=F3n en a.dot Es l=F3gico que cuando se descarga el complemento saque los men=FAs que agreg=F3, para esto en la macro AutoExit de cada complemento se borran los men=FAs que cada uno de ellos puso. Es decir que b.dot borra sus men=FAs en la macro AutoExit, llamndo a una funci=F3n en a.dot El problema que todo esto funciona maravillosamente cuando estoy editando y corro las macros a mano mediante F5. Cuando quiero poner todo esto en producci=F3n, copio los .dot al directorio STARTUP de Word. Hecho esto y levantado el Word, no funciona. He puesto trazas, por lo que se que se ejecuta, pero no logro borrar los menues. Para pero de males, luego saco los .dot del directorio de STARTUP de Word, o sea que no hay nadie que me pueda cargar los menues, pero sin embargo aparecen. Cualquier ayuda o sugerencia ser=E1 bien venida, no duden en preguntar si hay algo que no entienden de la exposici=F3n Suerte Gustavo Tag: Populating word 2002 forms with ODBC data Tag: 74189
  - 8
    - How to Copy-n-Paste into textbox how do you copy text from Outlook and paste it into a textbox of a Word form Seems like a simple operation. Right-clicking does not bring up a context menu. ALT - Edit - Paste pastes the text into the adjacent table cell. Any thoughts? Tag: Populating word 2002 forms with ODBC data Tag: 74188
  - 9
    - Transposing word doc into Excel doc If I have a word doc that my employees need to fill out and then I need the information they put in to be able to be transposed into an Excel doc, is this possible and if so how do I do it? Thanks, Tag: Populating word 2002 forms with ODBC data Tag: 74185
  - 10
    - align 2 paragraph styles with no line break (appear as 1 line) I need to have 2 styles look as follows: (style 1) 62340 Description line (style 2) The number would be bold, the description line would not. Description line can be very long, wrapping quite a few times. Is there an option to have no line break and choose to align 2nd paragraph with 1st? I have used Ventura for years but have been asked to try & setup in MS Word, which I don't think is going to work. Tag: Populating word 2002 forms with ODBC data Tag: 74181
  - 11
    - The list openend document On the right site when opening word than have you a list from the opening files what you haven don. When you opend the file than is the next time not the first one. The old program (word 2000) that was oke. The ask is that chance that when i for de second time opend the file that also in word2000 the second one is. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/community/en-us/default.mspx?mid=0d0f81f0-5560-4db6-81e9-2fc3bbab7040&dg=microsoft.public.word.vba.general Tag: Populating word 2002 forms with ODBC data Tag: 74180
  - 12
    - Unicode question I seem to have a strange unicode problem. Let me descibe what I am doing: Part of my VBA tool involves reading from a unicode saved text file which is in the format: findwordSPLITreplaceword The VBA code then processes the sequence of lines and keeps replacing "findword" with "replaceword". The sample text file is attached and its contents are: ?SPLIT&agr; ?SPLIT&bgr; ?SPLIT&khgr; Whenever I try to get the "findword" using a command like: SPL=split(EachLine,"SPLIT") msgbox strconv(SPL(0),vbfromunicode) ' Shows me gibberish for alpha and gamma BUT works for beta! The problems happen only for some unicode symbol fonts and work for all other normal fonts and most symbol fonts. My question is, if I need to have a file that may contain unicode characters and is saved in unicode format and I need to be able to do find and replaces the way mentioned above, what would be the best method? I have no idea why this doesn't work for alpha and gamma and works for many others! Thanks for your thoughts on this. Vince begin 666 test2.txt M__ZQ`U,`4 !,`$D`5 `F`&$`9P!R`#L`#0`*`+(#4P!0`$P`20!4`"8`8@!G E`'(`.P`-``H`QP-3`% `3 !)`%0`)@!K`&@`9P!R`#L`#0`*```` ` end Tag: Populating word 2002 forms with ODBC data Tag: 74179
  - 13
    - Running two instances of Word at the same time Can this be done? I've got some VBA scripts to run on about 800+ MIF files, and I want to run the simple ones in one instance, and the complex one in another instance (it has to be babied). Tag: Populating word 2002 forms with ODBC data Tag: 74178
  - 14
    - saving autotext to normal.dot I have a large autotext list with addresses etc. This has been saved to an alternated file named normal2.dot. Now when I add a new auto text or change an existing one it does not save it except in the current session of word. next time it is turned on it will be gone. It says normal.dot is read only but when I look at properties it says it isn't. It doesn't appear to be saving to the alternate file either. Also, the auto text doesn't appear automatically (although it used to). Everytime the machine is rebooted I have to go to templates and add-ins and select the extra file. Is there a way of making this a default. A Any ideas please Thank you Tag: Populating word 2002 forms with ODBC data Tag: 74175
  - 15
    - Greetings, problems with setting a bookmarked textbox value...it's protected? Hi all, I've been writing code in various environments, in varying application, for a wide range of customers, for about 35 years now and I'm still learning new stuff. ;) This week I'm helping a friend create a Word document template (Word 97) that stores a bunch of answers to questions in the registry (Using SaveSetting and GetSetting). In this document, as a part of the startup processing (AutoNew), I want to load the stored values back into the bookmarked places where they belong. The problem is I'm getting a error saying the location is protected. From what I understand of this, yes it is! I've protected the document so the body cannot be modified...but I want to be able to enter text/values into those places where I've defined fields (such as Textboxes, Checkboxes...et al) Here's the code I have so far, the error comes from this line: BkMrkRng.Text = RegVal <code> Option Explicit Private BkMrk As Bookmark, BkMrkRng As Range Sub AutoNew() Dim sBMName As String, S1 As String, S2 As String, RegVal As String For Each BkMrk In ActiveDocument.Bookmarks sBMName = BkMrk.Name S1 = Mid(sBMName, 1, Len(sBMName) - 1) S2 = Mid(sBMName, Len(sBMName)) RegVal = GetSetting("MBD", S1, S2, vbNullString) If RegVal <> vbNullString Then Set BkMrkRng = ActiveDocument.Bookmarks(sBMName).Range BkMrkRng.Text = RegVal ActiveDocument.Bookmarks.Add sBMName, BkMrkRng End If Next BkMrk End Sub </code> Hints: I've used the bookmark name, split into 2 strings, to name the Section and Key for the SaveSetting function so I can easily retrieve the values. I've learned that by setting the text value of a bookmark it clears the bookmark itself, therefore making it necessary to Add the bookmark back in after setting the text value. Thanks for any help, Shell (Yes, this is my real name) Tag: Populating word 2002 forms with ODBC data Tag: 74166
  - 16
    - =?Utf-8?Q?File=2C_Setup_=E2=80=93_Margins=2C_Paper=2C_La?= I prefer to work keyboard-driven as opposed to mouse-driven. In Word 2003, under File, Setup, the subheadings Margins, Paper, and Layout do not have alt+key strokes, so I have to take my hands off the keyboard to use the mouse to select them. Please fix. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/community/en-us/default.mspx?mid=8cef4bda-d47d-4572-92fe-f9201b4425cb&dg=microsoft.public.word.vba.general Tag: Populating word 2002 forms with ODBC data Tag: 74163
  - 17
    - How do I wrap drop-down items in a Word 2003 form? A textinput field will wrap in a form, but the contents of a drop-down will not. Tag: Populating word 2002 forms with ODBC data Tag: 74162
  - 18
    - Using Access as Data Source I am creating a Word template with a userform. The form features a combo box populated with 175 manufacturers (using .AddItem). When a manufacturer is selected, I would like text boxes elsewhere in the userform (for Contact Name, Address, Phone) to update with the chosen manufacturer's information. This gives the user a chance to verify this information before clicking OK and feeding it into various areas of the document. Rather than writing 175 Select Case statements to populate the text boxes, I'm thinking that since I already have the contact info in an Access db called CompanyInfo in a table called Contacts, I could somehow use this table to feed the text boxes. My problem is I don't know the code needed to call the table and have it populate the text boxes. How do I do this? Thanks! Tag: Populating word 2002 forms with ODBC data Tag: 74160
  - 19
    - how to create a table from info from several documents I have 1000 Word 97 documents. I want to "get" the name and address information from them (all located in same positions in docs) and create a TABLE to use for Mail Merge in the future. HELP. I also have Word 2003 and and received an email from a MVP with a Global macro (Finda & ReplaceAll) but need more help on modifying it to work with this. I am NOT very good with using macros. Tag: Populating word 2002 forms with ODBC data Tag: 74159
  - 20
    - Customize Task Pane in Word 2003, or alike toolbar Hi MS people, At our firm we have about 10 templates that I want to display when word starts up in the taskpane to the right, instead of the normal one, either customize the old one or maybe make a new one ( dont know how, there does not seem to be a easy way to add files/dirs so the user can easily click and open the templates ) How the question is, are there a way to customize the Task Pane, add direct links to files, or do I have to make one myself, and how? The best link describing a little of the same problem I have is this one, but its not that I'm looking for.... but close... http://www.mcse.ms/message481718.html best regards Mikael Syska Tag: Populating word 2002 forms with ODBC data Tag: 74158
  - 21
    - Macro not listed in OnExit dropdown box; why? Hello there. After creating the same macro (titled "SelectCheckbox") in both Normal.dot and in my template document titled "Expenses.dot", I then created a checkbox field. When I clicked the checkbox's OnExit dropdown box and scrolled down to find SelectCheckbox macro, it wasn't there. I even tried to look at one of the NewMacros, but it wasn't there either. SelectCheckbox is not a Public Sub by the way. Can anyone tell me why the SelectCheckbox macro wasn't listed under the OnExit dropdown box? Also, I find it exasperating that the width of OnExit dropdown box is so narrow that a long macro name is truncated. What gives with that? Thanks! Tag: Populating word 2002 forms with ODBC data Tag: 74153
  - 22
    - display a pdf file while in Word I am trying to add a command button that will display a .pdf file while I am in Word. I would also like to be able to use a command button to start a Flash application. Tag: Populating word 2002 forms with ODBC data Tag: 74152
  - 23
    - Obtaining full name in VBA How can I obtain the first and last name of the logged in user from within VBA. I know that Environ("Username") will give the username, but there is no such entry for the users full name. Thanks, ~ d Tag: Populating word 2002 forms with ODBC data Tag: 74150
  - 24
    - AutoText and Image question (Report for Database) Let me explain what i'am doing. I'd like to use Microsoft Word as a report generator for my database. (I created a VB6 application that creates and has access to a Microsoft Access database ) One of my fields contains links to photos (full path). I want to print/save every record on a new page. (One photo (with some text) per page in one single document) I created a Ms Word template with bookmarks (within cells) for my fields and has access from my VB application to this document. I create a new page for every new record from my database and use AutoText to create new Bookmarks. First question: If Ms Word is already active, the AutoText fails (Error numer 5825, The object is removed (translated from Dutch)) What can/must i do to prevent this ? (This error only occurs when Ms Word is already active) Second question: Is it possible to define the photo size in my template. (I has to resize the original photo to approximately 13 x 17 cm) When the original photo is 2272x1704 everything goes well. The photo fills the cell. (about 13x17 cm) But when the original photo is 800x600, it doesn't fill the cell) - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Some code i'am using: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Dim WordObj As Word.Application Dim WordDoc As Word.Document Dim WordRange As Word.Range Set WordObj = CreateObject("Word.Application") Set WordDoc = WordObj.Documents.Add(App.Path & "\report.dot") WordObj.Visible = False ' The code below will place the text/photo in the bookmarked location 'DESCRIPTION Set WordRange = WordDoc.GoTo(What:=wdGoToBookmark, Name:="description") WordRange.InsertAfter rs!description 'PHOTO Set WordRange = WordDoc.GoTo(What:=wdGoToBookmark, Name:="photo") WordRange.InlineShapes.AddPicture Filename:=rs!filename, LinkToFile:=False, SaveWithDocument:=True ' The code below will go to end of page, create a pagebreak and insert the AutoText Selection.EndKey Unit:=wdStory Selection.InsertBreak Type:=wdPageBreak WordDoc.AttachedTemplate.AutoTextEntries("MyAutoText").Insert Where:=Selection.Range, RichText:=True - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Thanks in advance, Robertico Tag: Populating word 2002 forms with ODBC data Tag: 74142
  - 25
    - AutoText and Image question (Report for Database) Let me explain what i'am doing. I'd like to use Microsoft Word as a report generator for my database. (I created a VB6 application that creates and has access to a Microsoft Access database ) One of my fields contains links to photos (full path). I want to print/save every record on a new page. (One photo (with some text) per page in one single document) I created a Ms Word template with bookmarks (within cells) for my fields and has access from my VB application to this document. I create a new page for every new record from my database and use AutoText to create new Bookmarks. First question: If Ms Word is already active, the AutoText fails (Error numer 5825, The object is removed (translated from Dutch)) What can/must i do to prevent this ? (This error only occurs when Ms Word is already active) Second question: Is it possible to define the photo size in my template. (I has to resize the original photo to approximately 13 x 17 cm) When the original photo is 2272x1704 everything goes well. The photo fills the cell. (about 13x17 cm) But when the original photo is 800x600, it doesn't fill the cell) - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Some code i'am using: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Dim WordObj As Word.Application Dim WordDoc As Word.Document Dim WordRange As Word.Range Set WordObj = CreateObject("Word.Application") Set WordDoc = WordObj.Documents.Add(App.Path & "\report.dot") WordObj.Visible = False ' The code below will place the text/photo in the bookmarked location 'DESCRIPTION Set WordRange = WordDoc.GoTo(What:=wdGoToBookmark, Name:="description") WordRange.InsertAfter rs!description 'PHOTO Set WordRange = WordDoc.GoTo(What:=wdGoToBookmark, Name:="photo") WordRange.InlineShapes.AddPicture Filename:=rs!filename, LinkToFile:=False, SaveWithDocument:=True ' The code below will go to end of page, create a pagebreak and insert the AutoText Selection.EndKey Unit:=wdStory Selection.InsertBreak Type:=wdPageBreak WordDoc.AttachedTemplate.AutoTextEntries("MyAutoText").Insert Where:=Selection.Range, RichText:=True - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Thanks in advance, Robertico Tag: Populating word 2002 forms with ODBC data Tag: 74141
- Next
  - 1
    - Macro on Folder and Subfolders Hi, with the help of another post I am trying to combine two macros into one to execute the macro on a folder of .doc files. Here is my code that has a bug: Sub Macro1() ' ' Macro1 Macro ' Macro recorded 22/09/2005 by Warringah Council for folder macro on Position Descriptions With Application.FileSearch .NewSearch .LookIn = "C:\Documents and Settings\gilleg\Desktop\testPDF\" .SearchSubFolders = True .FileName = "*.doc" If .Execute() > 0 Then For i = 1 To .FoundFiles.Count With Selection.Find .Text = _ "<http://intra.warringah.nsw.gov.au/pdf/oh&s/GM Ohsrprocedures201 OHSR Respon.pdf>" .Replacement.Text = "" .Forward = True .Wrap = wdFindContinue .Format = False .MatchCase = False .MatchWholeWord = False .MatchWildcards = False .MatchSoundsLike = False .MatchAllWordForms = False End With Selection.Find.Execute Replace:=wdReplaceAll With Selection.Find .Text = _ "http://intra.warringah.nsw.gov.au/pdf/oh&s/GM Ohsrprocedures201 OHSR Respon.pdf" .Replacement.Text = "" .Forward = True .Wrap = wdFindContinue .Format = False .MatchCase = False .MatchWholeWord = False .MatchWildcards = False .MatchSoundsLike = False .MatchAllWordForms = False End With Selection.Find.Execute Replace:=wdReplaceAll Selection.Paste Next i End If End With End Sub Thanks. Tag: Populating word 2002 forms with ODBC data Tag: 74133
  - 2
    - Unlinking a document from the template Hi Group Once again I'm trying to let people use my templates not only at work, but at home as well. To make things complicated, they shouldn't need to take the template with them. So, I need to get things out of the template and into the document. Three problems arise: 1) There can't be autotext in a document (right?), so I'll have to unlink the autotext entries from the template and insert them directly into the document. 2) Macros, Toolbars, Menus: I'll have to copy them to the document in Document_new. 3) Styles are automatically copied by word and only updated from the template on request. So, for once, Word is working with me. So, my questions are: Is this all right? Isn't there an easy way of doing all this? And: how can I do 2) right? E.g. I can't see any means of enumerating all macros (and forms, and toolbars, etc.) in a certain document. Thanks for any input! cheers, Bernhard Tag: Populating word 2002 forms with ODBC data Tag: 74130
  - 3
    - Can I print a document so that the print is in reverse I want to try and make my own rubb-off lettering and need to print a document so that the letters are reversed. I am using Windows ME. Tag: Populating word 2002 forms with ODBC data Tag: 74125
  - 4
    - Macro allowing user to select one of two templates I need to create a macro that has two option buttons. If the user selects the first option button, a specific template using singular language will run. If the user selects the second option button, a specific template using language for multiple signers will run. Tag: Populating word 2002 forms with ODBC data Tag: 74116
  - 5
    - Word Screen Refresh When I open a template I have created with a picture logo and macros in it, the screen refresh is really slow. Is there any way I can make this quicker? Thank you. Tag: Populating word 2002 forms with ODBC data Tag: 74114
  - 6
    - Last Modified doc property? Is there a property like LastSaveTime that I could use but that it shows only the the date of the last save or last modified? I really dont need to show at what time was modified Thanks in advance. Tag: Populating word 2002 forms with ODBC data Tag: 74113
  - 7
    - Dropdown List Values In a "protected" Word2000 form template using Tables: I have a drop down list in a Cell containing only 5 items: 1, 2, 3, 4 and 5 When someone clicks on the dropdown and selects one of the numbers, I want to place a numeric value represented by the number in the dropdown in another column. This value will ultimately be totaled in a column at the bottom of the form. This is replicated 25 times on the form, so would like to use cell references in the formula. Example: IFB1=1,0.00,0.00 IFB1=2,0.25,0.00 IF B1=3,0.50,0.00 IF B1=4,0.75,0. 00 IF B1=5,1.00,0.00 Basically: IF, THEN, ELSE - I understand the concept, just don't know where quotes, brackets and commas should go so Word interprets it correctly. Can this be written as a nested IF statement? I believe it falls under the 7 items rule. The cell reference in the formula would have to be changed for each of the 25 instances in the table. Help in constructing this so it works would be appreciated.... My thanks and Best regards -- Message posted via http://www.officekb.com Tag: Populating word 2002 forms with ODBC data Tag: 74111
  - 8
    - Do you wish to discard changes to ... and load the latest version? Hello- We are experiencing a problem with Word 2003 involving word documents that either contain macros and/or merge documents when we open them from our software. Our software just calls word and opens the document and prior to using the combination of our newest release of our software and Word 2003 we have not had a problem. Nor do we have a problem with the document UNTIL we save it in word 2003. If the document was created in office 97 through 2002 the document initially opens fine, but once we save it in Word 2003, anytime there after when we open it from our software we get the message 'Do you wish to discard the changes to <file name of the document being opened> and load the latest version?. If we say no, the document loads but reverts to a normal document instead of a mail merge main document and the autoopen or document_open macros to not fire. If we say yes to revert, the standard (2003) security message comes up - 'Opening the document will run the following SQL command:' and it opens normally and macros behave normally. I have made sure to remove all personal information from the document, accepted all changes and turned of change tracking, turned off fast saving, and stopped storing a random number to improve merge accuracy to no effect. Our software works fine with these documents in prior versions of word (97, etc), even after being saved by Word 2003 and we have tried this on Windows 2000, Windows XP, and Windows 2003 Server. Any ideas anyone might have would be greatly appreciated. Thankx, -- Scott Lowden Tag: Populating word 2002 forms with ODBC data Tag: 74109
  - 9
    - can i format a word cell like formatting an excell field. I would like to be able to format a word cell like formatting an excel field. example is by typing in excel Sep21, I can format it to show as Wed Sept 21. I am using office 2000 Tag: Populating word 2002 forms with ODBC data Tag: 74108
  - 10
    - Insert rtf formatted text Hi Is ther any method to insert .rtf formatted text into a word document other than inserting an existing file (which I believe is quite slow) Thank you, Shmuel Shulman Tag: Populating word 2002 forms with ODBC data Tag: 74107
  - 11
    - Footer Dates We have several dozen documents in one folder (G:\Specs)where the same footer information was inserted on each page. Among that information is a date (manually typed -- it is not a Date field), which is the same for each document in that folder. What we want to do is if the footer date in all of these documents needs to be changed, run a macro that opens each document, seeks out the date in the footer and replaces it with whatever date we want (provided by perhaps an Input Box). The format of the date is typically 09-21-05, but also may be 09/21/05. Can anyone give me some ideas? Thanks! Tag: Populating word 2002 forms with ODBC data Tag: 74104
  - 12
    - VB or VBA code for permutations Could you please help with writing a VB or VBA code for permutations: Context: There are some sentences in Word that will be selected by a user. The result should be a permutation (only one, not all of them) of these sentences (i.e., sent4, sent2, sent1, sent3 instead of the initial sent1, sent2, sent3, sent4). Thank you in advance for every help. Tag: Populating word 2002 forms with ODBC data Tag: 74103
  - 13
    - Problem with Printing Word Documents I have a VB.NET application I wrote to assist users in printing groups of Word 2000 documents multiple times. Let say that 1 group consists of 10 word documents and I need 10 copies of the group, 100 documents total. When these documents are printed, some of the pages within the documents do not print completely. Incomplete printing would be, a document with a header and footer but no data or a document with only part of the pages data. The page or pages that are incorrect are not always the same. I have tested with several different print drivers as well as a few different printers. I believe that it is a Word issue, due to my last application change. I modified the application to print to a file and the same thing is happening. I am using Word 2000 SP3. Any help would be appreciated. Thanks Tag: Populating word 2002 forms with ODBC data Tag: 74102
  - 14
    - Getting AutoIncrement Number I want an auto increment number on my document exactly where the cursor stays. For example while typing a text I need a autoincrement number (using as a reference number of a document) sometime on the 1st line, sometime on 6th line of the text or some time in next paragraph. Therefore I am looking for a solution to get auto increment number exactly where my cursor stays (any where in the document). Please advise. Regards. Irshad. Tag: Populating word 2002 forms with ODBC data Tag: 74099
  - 15
    - how to programmatically select a certificate to sign a word Docume Dear all, I would like to find the way to select programmatically the right certificate in my store before issuing the digital signature. It looks like it is quite challendging because the set signature=activedocument.signatures.add command does pop up a listbox to manually choose a certificate from . I would like to bypass this and be able to select programmatically the certificate to issue a digital signature from with some conditions on issuer and signer and has private key properties (for example). Must I use Capicom objects instead ? Is it the same if I make a signature from capicom versus from Word internally ? any code snippet to solve my issue or to show me the way is more than welcome Best regards Herve Cadieu Paris Tag: Populating word 2002 forms with ODBC data Tag: 74096
  - 16
    - Paste a bitmap from VB.NET2005 to Word2000 I am trying to paste an image in a pictureBox in vb.NET to a Word document. When using the paste method, the image quality in Word is bad. If using pasteSpecial method, all the dataType, like wdPasteBitmap or wdPasteEnhancedMetafile, etc. are not available. The code is as follows: wdApp = CreateObject("Word.Application") wordD = wdApp.Documents.Add My.Computer.Clipboard.Clear() My.Computer.Clipboard.SetImage(bm) wordD.Sections.Item(1).Range.PasteSpecial(Link:=False, DataType:=Word.WdPasteDataType.wdPasteShape) Does Anyone know how? I also find that when using pasteSpecial to paste a picture to Word, the foramt of JPeg, Png, etc are not available until you cut the pasted picture and do the pastSpecial again. Thanks. -- I like Vb. Tag: Populating word 2002 forms with ODBC data Tag: 74094
  - 17
    - What is the difference between the two different Save methods? When I save the modified document, I find the Save button on the General Toolbar is different from the Save command in VBA code. The document size is smaller when using the Save button to save. I wonder what is the difference? Any reply is appreciated. -- Tag: Populating word 2002 forms with ODBC data Tag: 74093
  - 18
    - Calling MS Word Mail Merge with Database Password How do I call an MS Word Mail Merge document from VB.NET so it does not ask the user for the MS Access Database Password? (not user password) I am performing Word XP automation from a VB.NET program. The Word document is set up to mail merge against an Access XP database. The Database has a Database Password on it. Without the database password, the document comes up just fine and without any user interface intervention from MS Word. I have tried a couple of commands that still popup the enter password dialog: 1.) mWordDoc.MailMerge.OpenDataSource( Name:="C:\Develop\TestMSWord\TestMSWord\bin\Docs\mydb.mdb", LinkToSource:=True, PasswordDocument:="mypassword", SQLStatement:="TABLE SellerInfo") 2) mWordDoc.MailMerge.OpenDataSource( _ Name:="C:\Develop\TestMSWord\TestMSWord\bin\Docs\mydb.mdb", _ PasswordDocument:="mypassword", _ Connection:="Provider=Microsoft.Jet.OLEDB.4.0;Data Source & _ "C:\Develop\TestMSWord\TestMSWord\bin\Docs\mydb.mdb;" & _ "User Id=admin;Password=;Jet OLEDB:Database Password=mypassword;", _ SQLStatement:="Select * from `SellerInfo`") Thank you. Tag: Populating word 2002 forms with ODBC data Tag: 74091
  - 19
    - Does the free Microsoft Word Viewer have an open API? I would like to use the viewer, but want to hide the menu and toolbars so factory personnel do not have acces to navigate on the network. The Word documents will be opened from a customized program, so all opening operations are dictated outside of the viewer itself. Tag: Populating word 2002 forms with ODBC data Tag: 74079
  - 20
    - load form into word upon opening I have a form that I have created in word using VBA, how do I call it up automatically when MS Word opens? What is the code and where do I put it? Thank you, Tag: Populating word 2002 forms with ODBC data Tag: 74078
  - 21
    - HOW DO I TRANSLATE A ENGLISH DOC. TO FOREGIN LANGUAGE Trying to convert same english text to forgein language - chinese, ukrainian, and spanish Tag: Populating word 2002 forms with ODBC data Tag: 74077
  - 22
    - how do I create a database using the word 2003 toolbar I am using Word 2003. I want to create a database using the database toolbar that is in Word 2003. Once the database is made I cannot save it unless I close the dbase screen. The screen that is left open shows my dbase setup i.e name, address etc. How do I save the dbase so that when I call it up to use it all I have to do is fill in the Blanks? Tag: Populating word 2002 forms with ODBC data Tag: 74070
  - 23
    - How to select programmatically the digital certificate for signing Hi all, I would like to know how to select programmatically (VBA) one specific certificate to issue a word doc signature , the certificate could be either in mystore or smartcard or LDAP I would like to parse the available certificates properties like issuer , common name, etc.. to select the precise certificate I would like to use for signing purposes. When using the (addsign macro) set sig=activedocument.signatures.add instruction it displays a listbox but I would like to avoid this listbox and select programmatically the certificate instead. Any suggestion with code snippet is very welcome Best regards Herve Cadieu Tag: Populating word 2002 forms with ODBC data Tag: 74068
  - 24
    - Is it possible to call and use MSWORD in command line mode? Hello all, Actually I would like to use the "Compare and modify" function in Word and Excel, but instead of opening the word application to complete the task, is there anyone know how to do it in command line mode? like c:\..\MSWORD c:\test1.doc c:\test2.doc "Compare and modify" or I need to write a VB program to call the function in MS office? Any comment, suggestion? or any related document for reference? Thanx so mush for your help MK Tag: Populating word 2002 forms with ODBC data Tag: 74064
  - 25
    - Apply formatting to XML Tag Hi, Could anyone help me with these please I have the following situation: The user has a blank word document with a schema attached and has to add text to that document and tag the text accordingly. Now, i want to show each tag he adds with a different style. For eg, if he tags text with the <title> tag, i would like these texts to be displayed in bold with green highlight. he tags text with the <subtitle> tag, i would like these texts to be displayed in italic. Is there a way to achieve this? Thanks Alicia Tag: Populating word 2002 forms with ODBC data Tag: 74061

Is there a way to access ODBC databases easily from within Word 2002?

I have a template that starts with a user form, in that user form, the end
user is asked to enter a client number. I want to be able to retrieve the
client data based on that number.

The data is in Foxpro 6

Any direction here would be great as I'm not having much luck finding a "yes
you can/no you can't" type answer

Top

Re: Populating word 2002 forms with ODBC data by Doug

Doug
Mon Sep 26 02:47:42 CDT 2005

See the article "Access a database and insert into a Word document the data
that you find there" at:

http://www.word.mvps.org/FAQs/InterDev/GetDataFromDB.htm

Not sure how applicable it is to Foxpro however.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"mR" <mR@discussions.microsoft.com> wrote in message
news:8C123579-3F44-43E6-A2AB-63CCA12E1D67@microsoft.com...
> Is there a way to access ODBC databases easily from within Word 2002?
>
> I have a template that starts with a user form, in that user form, the end
> user is asked to enter a client number. I want to be able to retrieve the
> client data based on that number.
>
> The data is in Foxpro 6
>
> Any direction here would be great as I'm not having much luck finding a
> "yes
> you can/no you can't" type answer

Top