Accessing a word document

[mystery45]

Not sure how complicated this is.

I am creating a simple form that opens an existing word docuement (which i have working).

once the person is done editing that docuement they need to save it off to another folder.

what i would like to do is link where they save it off to a hyperlink in an access database.

i have a command button that opens the word template being used but I am not sure how once they save it that it passes the hyperlink to the hyperlink box.

 

[The_Doc_Man]

Solve the problem by asking where your user wants to save the file. (Look up the FileOpen dialog in this forum for some ideas on how to do that. Also look up the fileopen object as a topic in MS Office Help that is part of your Access Help). When you get a reply from the user, you also have the file spec handy for filling out your hyperlink. You can fee the answer from the FileOpen dialog to as many places as you like; it is, after all, just a string when returned from that dialog box.