Open Word Help Docs

[onefootout]

I've written a bunch of help files for our database, all in word documents. Now I have to make them available from within the database. I'd like to find some way to have the values in a linked table and use them from there to open the documents, so I don't have to release a new form every time I add a new doc.

I've looked into using hyperlinks from a form, but passing the #name#pathname# back and forth between sql server & access is not working. (at least not the way I tried it) I also thought about making a table with 'name' and 'pathname' fields, then trying to add them togther to make that hyperlink string. I don't know, something like this?

='#'&([helpdocs].[Name]) & '#' & ([helpdocs].[path]) & '#'

I also made some buttons, which work great, but I run into the same problem. I'd have to release the form every time I add a new help doc & button.

Before I go any further with these, I was hoping to get some feedback.

Thanks for all your help!
Onefootout

 

[PHV]

Have a look at the FollowHyperlink method:
Application.FollowHyperlink strFullPathnameOfDoc

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[onefootout]

PHV,

I solved this using a different method, then came back to this. Gets a name from a combo box, then opens the corresponding file.

Application.FollowHyperlink Me!pickname.Column(2)

Worked fine when it was opening word docs, then after I changed them to .pdfs, it doesn't work anymore. Just opens the reader and shuts it again, without opening the file. If the reader is already open, it brings it into focus, but doesn't open the doc.

Any ideas?
Thanks in advance!