Open a different Word doc for each record?

[finchum]

here is what i want to do:
i have a database that has records of properties i list to sell and
then eventually sell. I have a Word document with pictures embedded
into it for each property. What i want to do is be able to, within the
input form i've created, click a button and have the Word document for
that property open up. Each record is different (probably close to
1100 records so far) and each has its own Word document. How would i
program the button?

Also, i read another topic in this group and he said to create another
table with a link to the main table (via the key "account #") that has
the drive, directory, and filename fields that are then used to feed
into the VB programming of the button. I tried it and no dice :-(

Please help! and thanks in advance

Ryan

[Tom van Stiphout]

On 29 Sep 2005 20:41:02 -0700, fi*****@gmail.com wrote:

Well, you could have a strict naming convention, such as
<property_id>.doc, or you could have an additional field in the table
to hold the word doc filename.
You open the document using the ShellExecute API. Here is a link:
http://www.mvps.org/access/api/api0018.htm

-Tom.

here is what i want to do:
i have a database that has records of properties i list to sell and
then eventually sell. I have a Word document with pictures embedded
into it for each property. What i want to do is be able to, within the
input form i've created, click a button and have the Word document for
that property open up. Each record is different (probably close to
1100 records so far) and each has its own Word document. How would i
program the button?

Also, i read another topic in this group and he said to create another
table with a link to the main table (via the key "account #") that has
the drive, directory, and filename fields that are then used to feed
into the VB programming of the button. I tried it and no dice :-(

Please help! and thanks in advance

Ryan

[lylefair]

If you don't want the overhead of maintining a list of the doc files
and their paths, you could search for OpenFileName here in CDMA and
use one of its many manifestations to browse the folder where the doc
files are. This function returns the path of any file selected, and
Application.FollowHyperLink Path opens the file.

When you can't play something because you have no dice, sometimes it's
a good answer to describe the circumstances so that others might
suggest why the dice seem to have disappeared.