opening word from access

[Ivano via AccessMonster.com]

I have a DB for my contacts. For each contact I have one or more template for
fax and letters.
What I'd like to do is to open word using the contact's template and when I
save the word file to store in the DB a link, so that I have an historic of
all documents sent to the contact.

 

[Guest]

You might want to download the mdb "hyperlinks demonstration form" that
demonstrates how to look into a folder and collect all files and dump them
temporarily into a hyperlink field. You can filter the lookup of course by
customer name...

URL: http://www.emrupdate.com/files/folders/al_borges/entry58232.aspx

Cheers,
Al

 

[Ivano via AccessMonster.com]

thank you but what I wanted was something like this:
a botton for the user to create the template in word, DB save automatically
saves the link.
a botton to create document from template. As the user save the document in
his own folder, the DB saves the link. Should the user move the file to
another folder, the DB should also record the change (if possible)

by

 

[Mr. B]

thank you but what I wanted was something like this:
a botton for the user to create the template in word, DB save automatically
saves the link.
a botton to create document from template. As the user save the document in
his own folder, the DB saves the link. Should the user move the file to
another folder, the DB should also record the change (if possible)

by

Albert Kallal has a tool that might really help you.

Take a look at the following:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html


HTH

Mr B

 

[Guest]

Hi Ivano:

It just seems like so much wasted effort when if all the templates and docs
are in the same folders, named, for example, "DoeJohan8020404", you can do a
lookup on "DoeJohn*" and dump all findings into a hyperlink field to look at
on any given time. You can do this in MS Word too, using a UserForm. You
don't need to statically save the link in a database. For example, what if
someone deletes the file(s) or moves them manually? How are you going to
handle that?

In a couple of hours I'll dive into saving the file location in an external
Access mdb table, but again I don't recommend it.

Cheers,
AL