I am trying to create a Word document, after filling in some bookmarks
from my DB, and then save the Word .doc in an attachment field. Many
years ago, I wrote the code to create, edit, save and retrieve the
Word doc, so I don't have a problem with that. Now I am using Access
2007, and I would like to take advantage of the attachment field type,
but this new field type is, admittedly, confusing me. Do I have to
save the Word doc first, then save it in the DB? If I do that, it
seems that there is a file left in the directory that will no longer
be used because the document will then be within the DB. All I want
to do is programmatically open Word, drop in some data, let the user
edit the Word document, then save it in the DB. I don't want to keep
track of all those document files in the directory. Am I asking too
much?!? LOL I hope someone can point me in the right direction
before I spend a horrendous amount of time coding in the wrong
direction.

Thanks so much!

Patti

Haven't had the wonderful pleasure of working with the RIBBON of Torment and
Torture... (my subtle way of saying I haven't worked with O2007
personally)... but...

From what I've read the file will have to be saved to a disk and then
imported. But you can always save it to a Temp folder and then delete it
afterward.

"Patti" wrote:

> I am trying to create a Word document, after filling in some bookmarks
> from my DB, and then save the Word .doc in an attachment field. Many
> years ago, I wrote the code to create, edit, save and retrieve the
> Word doc, so I don't have a problem with that. Now I am using Access
> 2007, and I would like to take advantage of the attachment field type,
> but this new field type is, admittedly, confusing me. Do I have to
> save the Word doc first, then save it in the DB? If I do that, it
> seems that there is a file left in the directory that will no longer
> be used because the document will then be within the DB. All I want
> to do is programmatically open Word, drop in some data, let the user
> edit the Word document, then save it in the DB. I don't want to keep
> track of all those document files in the directory. Am I asking too
> much?!? LOL I hope someone can point me in the right direction
> before I spend a horrendous amount of time coding in the wrong
> direction.
>
> Thanks so much!
>
> Patti
>