How to create Word .doc, then save as attachment?

[Patti]

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

 

[dch3]

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.