| re: Access links, hyperlinks and headaches!
"Robin" <campbell.robin@gmail.com> wrote in message
news:1136826897.517236.263650@g44g2000cwa.googlegr oups.com...[color=blue]
> Hello!
>
> I'm having trouble with links and hyperlinks in MS Access 2003 - any
> help would be great!
>
> Question 1!
>
> The "insert hyperlink" icon opens a browser window, allows the user to
> browse to the desired file and paste the hyperlink on the form (which
> obviously remains for on all the records). I am trying to create a
> database of files and want to have records with individual links (i.e.
> record one has a hyperlink to word1.doc, record two has a hyperlink to
> word2.doc).
>
> Can anyone be clever and explain how you can get the functionality of
> the insert hyperlink function but recording the value in a table's
> field (so you can have individual links for each record)???? (Perhaps
> you have made a macro to run off a button...)
>
> Question 2!
> This database will be copied to different machines. Using the "insert
> hyperlink" function avoids problems of updating hyperlinks by using the
> "hyperlink base" in the "file/database properties" tab. If I move the
> database to another machine, will the hyperlinks opening files still
> work if the program locations are different to the machine which the
> hyperlinks were created on???
>
> Thanks![/color]
The hyperlinks are a pain in the neck and simply not worth it. You should
just store the path to the document in a palin text field. The simplest
case is when all documents are in the same folder, so you only need to store
the document name and the full path can be worked out by adding, say
G:\PublicStuff\WordDocs\ to the file name Doc1.doc.
That way if you can easily change the folder if you decide to move them.
And better then a mapped drive such as G:\ might be the unc path such as
\\Server1\Company\Public\WordDocs\
Then code in your form opens the correct file - loads of examples of this
have been posted and I suppose it depends on whether they will all be Word
or whether you might also have some Excel stuff.
| 
