hyperlink to word dokumnet

[Guest]

Hello,

I am trying to create a database tool in access which produces a list of
clickable items, hyperlinks which leads to word dokuments.

In short, I have a database with a lot of variables and I would like the
selecting question not only to produce a list of items that meets the
criterias, but a clickable list where each item leeds to a corresponding
dokument.

 

[Guest]

If you want to build your hyperlink list try this --

You can create a text file of your Word documents to import.

Click on windows START - Run and type in CMD. This brings up a DOS window.
It will default to C:\Documents and Settings\Your User Name.
Use the command CD\ and press ENTER to get to the root directory if
you files are on the C:drive. If they are on another drive then type in the
drive letter followed by a colon like this F: and then press ENTER.
Then CD and the folder name where the files are located. You will need to
tranverse one folder layer at a time.

Then use the command DIR to see the file listing. Then use the command
DIR /B >MyFileList.TXT to create the text file containing all files in
that directory. The /B only list the filenames with extention. If you
want size and other information omit it. If you also have files in
subdirectories the you can get them all by including a switch for
subdirectories like this --
DIR /S /B >MyFileList.TXT
When you finish close the DOS window. Open in Excel.
Build your hyperlinks by editing the Excel. Save as Excel file.
Import the Excel file.

 

[Guest]

Thank you for your easy to follow answer.

What I dont understand is how the list after each cell is hyperlinked to its
corresponding word dokument can be used to solve the problem.

The vision is to get a list of a few titles - which depending on which
qestions is put to the database - and that each title in the list is
hyperlinked to a dokument

Is your idea maybe that the hyperlinked cells in some way can be used as new
variable in the database and in the end, after the selecting question can
appear as links in the produced list?


"KARL DEWEY" skrev:

 

[Guest]

You can search the hyperlink documents.
Use a criteria like this ---
Like "*" & [Enter search phrase] & "*"
It will pull records that have the phrase in the hyperlinked documents. You
can then click the link and open the Word documents.