Word document

[Guest]

Is it possible from an Attachment or Hyperlink( or any other) field to
launch Word, create a document, save the document and place the document name
in the field where launched? I know that there is code to launch Word it is
the return part that I do not know about.

thanks in advance.

 

[Albert D. Kallal]

As a general rule, you don't want to save the document in the database, but
only store a path name to the word doc.

I would suggest that you *ask* the user for the name, and *then* launch
word, create the doc. that way, you already know the name + path name.

I have a sample word template system that lets you or users create word
templates, and I also included a set of routines that allow you to specify
the output document for these templates.

check out my super easy word merge here:

The sample I have can be found here:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

what is nice/interesting about my sample is that is specially designed to
enable ANY form with ONE LINE of code....

Thus, each time you build a new form, you can word merge enable it with
great ease.

I would also consider genreate the document id based on custorer id, or some
other such numbering system, and then users will not even have to speicfy a
document name.

 

[Guest]

Thanks for your reply Albert.

In this case I do wish to store the doc in the database. I am using 2007
and the attachment data type.

People will be creating and storing many docs and I want to simplify the
process as much as possible.

Ideally this is how it would go: User double clicks a control which would
launch Word and open a new doc with a file name created with passed
parameters. The user finishes the doc and clicks Save(possibly changing the
name of the document). The name of the doc is passed back to the database
and stored.

thanks again.