Create new Word document.

[Bill H]

I have an Access database that I use for document control. I would like to be able to fill out a form in the database, and have it open a document template, and automatically enter certain information, such as a document number, and author. Is there a way to do this?


Thank you for your time and assistance.
Bill H.

[June7]

Sounds like a mail merge operation.

[help_me_with_access]

Bill,

there is a very easy way you can make microsoft office teach you what is what, in terms of coding a visual basic operation inside the software suite. record a macro in your target app and copy the code directly into your source app. usually you don't have to replace many of the qualifying statements (e.g. - the object in the code) other than those that are directly related to the target application on the top level. for instance, in the case of word, a document object or the app object itself.

below is PSEUDO code (probably not perfectly correct) that shows how to do this. ask word to tell you how to code a basic app...opening a new template:

Documents.Open FileName:="Doc2.dotx", ConfirmConversions:=False, ReadOnly _
    :=False, AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate _
    :="", Revert:=False, WritePasswordDocument:="", WritePasswordTemplate:="" _
    , Format:=wdOpenFormatAuto, XMLTransform:=""

so in your source app, other than creating the instance of the target app and replacing the qualifiers, things should stay exactly the same:

Dim wd As Object
Dim wt As Word.Document


Set wd = CreateObject("word.application")
    wd.Visible = True


Set wt = wd.Documents.Open(Filename:="path")

More than likely, as in this example, almost all of the code written by the target app itself could be duplicated by the source app just by adding the prefix wd. to it.

[orange]

I don't work with Word at the vba level -- just use it as word processor.
However, I did a few searches after reading help_me_with_access post.

These links may give you some additional/contextual info or ideas to go with the previous post #3-

http://www.fontstuff.com/vba/vbatut09a.htm
http://www.techrepublic.com/blog/mso...ccess-data/164
http://www.functionx.com/word/Lesson06.htm
http://www.functionx.com/word/Lesson...m/chap11b.html