Populate Word Userform with data from Access

[edi dhar]

Hi,



I'm hoping someone can help with a problem i have as I am completely stumped. First off I guess I need to know if it is possible to do what I am trying to do and secondly if anyone can provide any help.

I am trying to populate a userform in MS Word with data from an MS Access userform. The idea being a user will look at the database and pick a record that will open up in the userform that appears when the MS Word template opens. I have been working on this for the past 2 days and I am able to send data to a word document and populate either formfields or bookmarks but the letter templates I've been given to work with come with a userform and they have to stay as the users require them to complete a few more fields not available in the Access database and there's other bits of VBA code that is contained within the userform.

Any help would be gratefully appreciated...even if that's just to say what I'm trying to achieve isn't possible.

[ItsMe]

Response number three, marked as answer, seems to be a good description of how to populate Word doc form fields.
http://stackoverflow.com/questions/1...tion-through-w

[edi dhar]

Hi ItsMe,

Thank for you for the quick response however i don't think that option works for me. I'm trying to populate a userform in Word not formfields on a word document. I don't even know if this is possible as i can't find anything on it. All the help out there points to using bookmarks, formfields, or using DAO/ADO within the word document to return data from the database. All of which i am able to do but the scope i've been given requires me to populate the existing userform within the word template.

Cheers

[ItsMe]

Hmm, was not aware of this userform thing....

I found this, which supposedly creates the bookmarks in a word form. I am not sure it populates the text though. It seems that the idea of a userform is to collect data from user input. So not any support for supplementing the User Input action or replacing the User Input action via Automation.
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx


You may already have seen this.
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

I created some air code here. But not seeing any Text property or way to write to the Bookmark. It seems to be read only.

Dim myWordApp As Word.Application
Dim docNew As Word.Document
Dim docBookmark As Word.Bookmark
Set myWordApp = CreateObject("Word.Application")
myWordApp.Visible = True
Set docNew = myWordApp.Documents.Open("C:\Test\SampleDoc.docx")
    
    For Each docBookmark In docNew.Bookmarks
    
        Debug.Print docBookmark.Name
    
    Next
docNew.Close
myWordApp.Quit
Set docNew = Nothing
Set myWordApp = Nothing

[edi dhar]

Yeah unfortunately the userform is non negotiable and has to be included as part of my solution. I have a compromise where i populate the bookmarks on the word template then call the userform within the word document to then pick up the bookmarks during form load. This will work (I think) but it's not very clean and would be much better if i can send data straight to userform.

The code i have for populating the bookmarks is something like below.

Dim appword As Word.Application
Dim doc As Word.Document


Set appword = GetObject(, "Word.Application")
Set appword = New Word.Application

Set doc = appword.Documents.Open("C:\Test\SampleDoc.docx", , True)

With doc
.Bookmarks("word_bookmark").Range = Me!Access_Field
.Visible = True
.Activate
End with


Thanks for you effort so far. Those links a quite good and could prove to be handy.

Cheers

[ItsMe]

This looks like your solution right here
.Bookmarks("word_bookmark").Range = Me!Access_Field

All you need to do is get the names of your bookmarks using the code snippet I provided (and provided the code I provided iterates your doc). With that, you can use a DAO Recordset to populate the bookmark using the Document's Bookmark collection and the .Range property.